Small and medium business | Business Central, N...

Purchase invoice - total sum rounding

(2) Share

Report

Posted on by Elnur

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.

I have the same question (0)

All responses (7)

Answers (0)

Elnur 2 on at

Like (0)

Report

RE: Purchase invoice - total sum rounding

do you have any idea?

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (1)

Report

RE: Purchase invoice - total sum rounding

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.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,393 on at

Like (0)

Report

RE: Purchase invoice - total sum rounding

hi

look this

learn.microsoft.com/.../finance-set-up-invoice-rounding

DAniele

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

RE: Purchase invoice - total sum rounding

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.

Was this reply helpful? Yes No
Elnur 2 on at

Like (0)

Report

RE: Purchase invoice - total sum rounding

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.

Was this reply helpful? Yes No
Suggested answer

Amit 2,557 on at

Like (0)

Report

RE: Purchase invoice - total sum rounding

hi,

Refer the link

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-set-up-invoice-rounding

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Elnur 2 on at

Like (0)

Report

RE: Purchase invoice - total sum rounding

Thank you Amit, but Daniel send me this link, pls see the answers

Was this reply helpful? Yes No