web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / ROUNDING OFF IN LOCAL ...
Small and medium business | Business Central, N...
Suggested answer

ROUNDING OFF IN LOCAL CURRENCY

(0) ShareShare
ReportReport
Posted on by JOYAL SHAH 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.

I have the same question (0)
  • Suggested answer
    Gulshan Shubham Profile Picture
    Gulshan Shubham 2,210 on at
    RE: ROUNDING OFF IN LOCAL CURRENCY

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: ROUNDING OFF IN LOCAL CURRENCY

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,885

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,405

#3
Sumit Singh Profile Picture

Sumit Singh 2,837

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans