Adjust Exchange Rate Batch Job posted to wrong date

leewhite1234

We have a client who ran the adjust exchange rate batch job on 19 April with a posting date of 29 April. The clerk immediately ran it again with a posting date of 19 April. Only when closing the month was this discovered. About 20 customer invoices in non-LCY were fully paid prior to 29 April. For those 20 transactions, Navision made a closing entry to the unrealized gains(losses) account and offset to the receivables control account, as is standard and marked the sales invoices as not Open with no remaining amount, but a balance in the remaining amount ($) field. The transactions do not show on the Aging Accounts Receivable report, but there is still a balance in the remaining LCY ($) field, and this amounts remains in the receivables control account and the unrealized gains(losses) account. How do we clear this out?

Also, what is the best approach to preventing the client from running the adjust exchange rates batch job in the wrong posting date sequence? (i.e., 17, 18, 29, 19, 20, etc.)

Thank you for any suggestions on cleaning this up.

SD-JR

Hi,

If it's only 20 invoices then get them to unapply the payments and re run the adj exchange rates, when you re-apply the payments it should clear the remaining LCY values.

Making them do the work should help avoid it happening again.