When exporting a set of data from Dynamics365 , for example ''posted sales invoices'' Im trying to get the sales amount in LCY (USD) for invoces issued on a different currency.
To be more specific: if my currency code for a specific invoice is JYP, for example , In the list extracted in Excel from ''posted sales invoices'' page , the value is shown ONLY in JYP and not in our Local currency (LCY) which is , for example USD.
Is there any way to add the field containing the amount in LCY on the ''posted sales invoices'' table view in dynamics and consequently into the excel file created by exporting the data?
Thanks a lot for your help
B