What I was hoping to do is use electronic reporting /document management to customize the sales order invoice and add the delivery address. I have copied and modified the template to add the field on the Excel template, mapped it to the field in the data model, but nothing shows. Does the invoice model need to be modified to join another table to get the delivery address. not sure why the existing model is blank for the delivery address.
Sales invoice (Excel) was copied in order to modify, mapped the following
Cell<DocumentDetails_DeliveryAddressName_Value>: String = model.InvoiceBase.DeliveryName
however it appears model.InvoiceBase.DeliveryName is blank