web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to add “Email Sent” indicator for the Sales Order Confirmation

(2) ShareShare
ReportReport
Posted on by 4,133

I would like to have a field in Sales Order List Page and Sales Order Page to indicate that the Sales Order Confirmation has been sent by email. 

There is “Last Email Sent Time” field in Sales Header Table. I could add it using AL Code, That shows Date/Time of email, but I find it is not specific to SO Confirmation email. It gets updated even after other activities like after user send Approval Request notification and also when the SO's Invoice is sent by email. How can add a field such as Email Sent (Y/N) or Email Sent Date for SO Confirmation?

Thank you

  • Suggested answer
    Teagen Boll Profile Picture
    4,339 Super User 2026 Season 2 on at

    The No. Printed field will update when the Confirmation is emailed (or printed/downloaded).

    See example below:

     

    After selecting Email Confirmation…:

     

    You could test using that field. Sent Emails get logged in the Sent Emails table too. I havent tested if that updates on other scenarios but it should give you a bit of a starting point.

     

    Best,

     

    Teagen Boll, CPA
  • Suggested answer
    YUN ZHU Profile Picture
    104,090 Super User 2026 Season 2 on at

    Apologies, I haven't implemented this customization before, but it looks feasible. Hope the information below helps give you some ideas.

    Dynamics 365 Business Central: How to display/add “Sent To” on the Sent Emails (8883, List) page?

    https://yzhums.com/72539/

     

    Thanks. 

    ZHU

     

  • Suggested answer
    OussamaSabbouh Profile Picture
    20,817 Super User 2026 Season 2 on at

    Hello,
    There is no standard Sales Order Confirmation Sent field, and I would not use Last Email Sent Time or No. Printed for this—Last Email Sent Time is generic, while Microsoft confirms that No. Printed can increase simply because the PDF was generated, even if the email was not sent. The clean approach is a small extension: add something like Order Confirmation Sent At (DateTime) to Sales Header and update it only after a successful email of the Sales Order Confirmation (normally report 1305 – Standard Sales - Order Conf.) through the document/email sending process; then expose that field on the Sales Order and Sales Order List. If you only need history rather than a field, you can also enable Log Interaction and review Interaction Log Entries/Sent Emails.

    Regards,
    Oussama Sabbouh

  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    3,888 Super User 2026 Season 2 on at

    Hi DinB, that field can’t do it. Last Email Sent Time is a FlowField, it takes the newest Email Related Record linked to the sales header, so any email connected to the order moves it, and as far as I see there’s no document type in that table to filter on.

    What I’d do is your own field on Sales Header, say Order Conf. Email Sent as DateTime, and fill it from the Document-Mailing codeunit. It has an event OnAfterEmailSentSuccesfully (spelled like that) which gives you PostedDocNo and ReportUsage. For the order confirmation ReportUsage is S.Order from the Report Selection Usage enum and PostedDocNo should be the order number, so you Get the header and stamp CurrentDateTime.

    One catch, with the email editor that event fires when the user presses Send I think, the mail then sits in the outbox, so it means sent by the user, not delivered.

    Glad to help - follow up if anything is unclear.   

    ►  If this solved it, marking it verified helps others too.       

    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer

    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 664 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 446 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 282 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans