Skip to main content

Notifications

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

Purchase invoice - total sum rounding

Posted on by 2

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.

rounding-4.png

rounding-5.png

rounding-6.png

  • Elnur Profile Picture
    Elnur 2 on at
    RE: Purchase invoice - total sum rounding

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

  • Suggested answer
    Amit_Sharma Profile Picture
    Amit_Sharma 2,545 on at
    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

  • Elnur Profile Picture
    Elnur 2 on at
    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.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Purchase invoice - total sum rounding

    If you are using foreign currency PO, then go to Currencies page and change as per below.

    pastedimage1667213901518v1.png

    Then go to the PO take that currency code and see the effects.

    pastedimage1667213979783v2.png

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Purchase invoice - total sum rounding

    hi

    look this

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

    DAniele

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    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.

  • Elnur Profile Picture
    Elnur 2 on at
    RE: Purchase invoice - total sum rounding

    do you have any idea?

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,101 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,896 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans