We have an issue with currency changes and freight invoiced to customer on an Advance invoice.
We have implemented Direct Delivery Freight Price Lists, which only can be in Base Currency.
When we have a customer order in Currency the Charge Price/Curr is calculated on customer order using Direct Delivery Freight Price list and Default Sell Currency Rate Type and current valid currency rate.
When we create Advance invoice the invoice amount in currency includes the current calculated amount in currency for freight.
When creating final Customer Invoice, Charge Price/Curr is different due to changes in currency rates. The final invoice always creates a difference in Accounts Receivables, due to changes in currency rates and recalculation of Charge price /CURR for freight.
We have found that it is possible to create advance invoice without charges (Base for Advance Invoice in Company/Order Tab), but this is not a good solution. Preferable we will be able to send a 100% Advance Invoice to Customer (including calculated freight) and create the final invoice using the same currency rate for freight as used for the Advance invoice.
Any ideas for how to handle the above issue?