Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Word Report Layout and Word Templates

(1) ShareShare
ReportReport
Posted on by 27
I have created a word email body report for a sales invoice as well as a word template report with a formula field so that the email body states
 
/Good morning/ or /Good afternoon/ when I go the send the email.
 
The formula is { IF { TIME //@ /am/pm/ } = /AM/ /morning/ /afternoon/ } 
 
The formula works no issues if executed purely in Word but once it is loaded into BC the system does not update the field when inserting into the email body.
 
I'm assuming BC does not update fields otherwise this would appear correctly in the email body but I cannot find any commentary around limitations of Fields and Word layouts for business central.
 
I do not want to do this via coding - the end user needs to be able to do such things as well.
 
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,029 Moderator on at
    Word Report Layout and Word Templates
    Kaspars gave you the correct answer here.
    But you have a brilliant idea and you shoudl consider adding that as a product idea using this link:
    Other users can then vote for it and Microsoft will consider your idea.
  • Verified answer
    KasparsSemjonovs Profile Picture
    4,411 Super User 2025 Season 1 on at
    Word Report Layout and Word Templates
    Unfortunately this requires slight modification. This formula check, has to be done on BC side as a separate dataset, and user would indicate/place this dataset as XML field in the Word Layout. 

     

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans