Hi,
I think there is a bug in the way Navision includes open entries to run unrealised FX adjustment at the end of a period. Here is the scenario:
I have an Invoice posted at 20/10/2009 and this is paid at 20/03/2010. My fiscal year ends at 31/12/2009 (starts at 01/01/2009).
I apply the payment to the Invoice today and after a few dates I decide to run adjust FX for 2009 since I didn't do it before. The system will check the Invoices not closed for 2009 and calculate FX gains/losses. However, although the payment is paid in 2010 the system marks the Invoice as paid and the FX adjustment batch job will not calculate unrealised FX gain/loss for this Invoice.
I'm using Navision 5 sp1. I know we also had this with Navision 4. Hopefully this is already fixed as they did with unrealised FX batch job start date.
Comments
Check out KB 942614.
Are you specifing dates before running the Exchange Update?
Doc