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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Rounding on the total of an invoice and not the lines (Sales side)

(0) ShareShare
ReportReport
Posted on by 140

Dear All, 

Is there a possibility in the newest version of Dynamics 365 (spring release) to tell the system to calculate the rounding of an invoice only on the total level and not on the line level?

Current set up is in the Currencies, General: 0.05 rule, normal rounding.

When a free text invoice or a project invoice or a sales order invoice is created we can see that the rounding rule is applied to the lines of the invoice line by line. This is also how the rounding is shown on the invoice when printed.

We would like to have this rounding not on the line level but on the invoice total level. 

Line 1: 10,21 VAT 10% : 1,021

Line 2: 20,41 VAT 10%: 2,041

Total:

Net: 30,62 VAT: 3,062 Gross: 33,682 -> this value should be rounded to 33,70 this is the payment amount, and the rounding should be booked to a rounding account.

And this is how it should be shown on the printed invoice. 

But for some reason we see the rounding done line, by line.

Is there a parameter setup some where? We looked in AR parameters and Sales and Marketing and General ledger. 

Strangely multiple people say that they have seen this work correctly for the total amount already. I do have to mention it was on the fall release.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Emilia_R,

    How is the calculation method parameter set up? (GL Parameters - sales tax)

    Line or total?

    Best regards,

    Ludwig

  • Emilia_R Profile Picture
    140 on at

    Hi Ludwig,

    The parameter is set to Total.

    Thank you

    Emilia

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans