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.