"Timing" of Posting Sales Invoices for Foreign Currencies

(0) Share

Report

Posted on by john.ellis

3,530

Hi:

In NAV, we always have to hold off on posting sales invoices for the current month until the previous month's invoices are posted. This is due to foreign currency exchange rates.

If we were to post the current month, either the previous month's invoices or the current month's invoices would be updated with the wrong rate.

It's as if the exchange rate in the system is not being "careful" in terms of applying the previous month's rate to the previous month's invoices and the current monthly rate to the current month's invoices.

What is the fix for this?

Thank you!

John

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

John,

Exchange Rates have Effective Starting Dates. You can also create a Job Scheduler/Queue to import the Exchange Rates into NAV to update and record that days Exchange Rate.

This way the rate to be used on the posting would be correct based on the one in effect. You can test this manually by entering Exchange Rates for multiple days and see how Sales Invoices can be calculated and posted with the days exchange rate and prove you can post them immediately vs. waiting.

Thanks,

Steve

Was this reply helpful? Yes No