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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

"Net amount per line" V/S "Net amount of invoice balance"

(0) ShareShare
ReportReport
Posted on by 1,260

Hi all,

I was looking for the following error: “Update for voucher XXXXX has been cancelled to avoid oversettlement.  The settled customer or vendor balance for the transaction must not exceed the transaction amount.” and there is a configuration change for the sales tax codes.

The suggestion as per the link that I followed is to set the Marginal base to "Net amount per line".

Currently or Marginal base is set to "Net amount of invoice balance" and I am not sure what area this configuration change will affect. Can someone please suggest which configuration should one go for and reason. If the change is made to "Net amount per line" what should be cross-checked and verified in DAX.

*This post is locked for comments

I have the same question (0)
  • Tim Schofield Profile Picture
    on at

    If you use 'Net amount per line' sales tax is calculated (and rounded to the nearest cent) on each sales order invoice line. Then those line vales are added up to give you total tax.  If you use 'Net amount of invoice balance' the sales tax is only calculated (and recorded) on the sales order invoice journal header. Because of the rounding you can get a different sales tax total calculated in each case. So my advice is to check all of the fields on the sales invoice journal header and lines, and make sure you are using a test case that will generate a discrepancy.

  • Daljit Kaur Rahsi Profile Picture
    1,260 on at

    Hi Tim,

    We also having the penny rounding issues - would this resolve if we change to "Net amount per line"?

  • Tim Schofield Profile Picture
    on at

    Sorry Meethu, I'm not competent to give you an answer on your penny rounding issues. Sales tax is not my speciality. I just looked at this issue once, when an EDI partner asked us to send the sales tax on each invoice line, but in the end we used the tax calculated on the header, because I think it was the recommended method for the tax authority.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans