We have invoice with item prices like 0,472 but unfortunately it shows in line amount as 0,47.
If we add 3 lines with q-ty 1 and price 0,472 in lines will be 0,47 and total sum of invoice will be 1,41
And if we add only one line qith q-ty 3 and price 0,472 it shows line amount as 1,42 and total invoice amount as 1,42
We need system to show in line amount as 0,472 if q-ty 1 and 1,416 if q-ty 3
And total sum of invoice if there are 3 lines with 1 -q-ty and price 0,472 as 1,42
How should we setup rounding. I used different variants, but can't find any right one. Please help.
Thank you Amit, but Daniel send me this link, pls see the answers
hi,
Refer the link
https://learn.microsoft.com/en-us/dynamics365/business-central/finance-set-up-invoice-rounding
Regards
Amit Sharma
Thank you everybody for answers.
I would like to share my investigation on this topic
For the setup of invoice rounding you need:
1. Setup fields Inv. Rounding Precision (LCY) and Inv. Rounding Type (LCY) on Gen.Led Setup page
2. Enable field Invoice Rounding on Purchases&Payables Setup. After that your setup on step 1 will be work
3. Insert Invoice Rounding Account on Vendor Posting Groups page
After all of this, on the Purchase Invoice page, rounding of sums by lines does not occur (there are 2 digits after the decimal point), and only after posting of this Purchase Invoice, an additional entry is automatically created for the amount of rounding.
On the Purchase Invoice page there is the Line Amount and there is the Total Amount (the total amount of the Invoice). The Total field is formed from the Line Amounts, and if there is no rounding in the Line Amount fields, then the Total field will not be rounded too.
So, the rounding of the Total field in the Purchase Invoice in system is developed in the form an additional entry.
If you are using foreign currency PO, then go to Currencies page and change as per below.
Then go to the PO take that currency code and see the effects.
Hello,
If you do not get further traction from the community, feel free to raise this issue to Microsoft via your partner or CSP.
Thanks.
do you have any idea?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,101 Super User 2024 Season 2
Martin Dráb 229,896 Most Valuable Professional
nmaenpaa 101,156