You’re offline. This is a read only version of the page.
20
HELLO GUYS,
MY ORGANISATION IS RAISING SALES INVOICES FOR EXPORT SALES IN EUR AND USD. WE ARE BASED IN INDIA AND OUR LOCAL CURRENCY WILL BE INR. DURING RAISING EXPORT INVOICES, ROUNDING OFF IS DONE IN FOREIGN CURRENCY WHICH IMPACTS LOCAL CURRENCY. E.G. IF I HAVE AM RAISING INVOICE FOR $433.22, NAV WILL ROUND OFF $ 0.22 WHICH WILL HAVE IMPACT IN AS INR 15 IN LOCAL CURRENCY . AS PER MANAGEMENT THE ROUNDING OFF SHOULD NOT EXCEED INR 2.
WE SUGESTED OUR DEVELEOPER TO CALCULATE THE WHOLE INVOICE IN LOCAL CURRENCY AND ROUNDING OFF SHOULD HAPPEN IN LOCAL CURRENCY TO GIVE THE IMPACT IN FOREIGN CURRENCY. BUT HE IS SAYING IT IS NOT POSSIBLE.
CAN ANYONE HELP TO FIND OUT THE WAY AROUND.
Hi Joyal,
Rounding for Local Currency and Foreign Currency is being handled through two different setups at different places within NAV i.e. rounding setup of Foreign Currency is provided on the "Currency" page and for Local currency, the setup is on "General Ledger Setup". Hence, you can give it a try for your scenario.
Joyal,
My first question is what Currency is the Customer? I have several customers that have Export customers and their Invoices are set to the Customers Currency. For example, my LCY = USD but my Customers are EUR, GB, CAD. When the Invoice is posted the Invoice reflects the Customer FX Currency and is posted in the Customer Ledger and General Ledger with an LCY amount. The rounding comes from 2 setup cards: General Ledger Setup (Invoice Rounding Precision/Type), Currencies (Invoice Rounding Precision/Type).
I would look at both setups to see if your settings are producing this incorrect result. Seems like the Currency Rounding is set to 1, not cents.
Hope this helps.
Thanks,
Steve
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (