Hello community,
My problem is the following, after generating a document using a Word template, the user has to enter some numerical values in the table (Quantity and Unit Price), once made a calculation has to be done to get the Extended Price = Quantity*Unit Price.
Word does not allow this type of formula.
By adding an Excel template, I can't access the dynamic values.
I even tried to reach it via DocumentCorePack but without success.
Here is my table :
Any Ideas to do this ?
What you generate is flat XML file, in the end, that is interpreted by Word application.
Such operations are not allowed within the current Word Document feature with NAV or BC.
In my opinion, instead of performing such kind of post-processing operations, I would encourage your customer to input values within BC and generate the word file afterwards.
In theory, if you certify your documents, these should not be manipulated outside your ERP.