web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) "Net amount per l...

Microsoft Dynamics AX (Archived)

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

(0) Share

Report

Report

Posted on by Daljit Kaur Rahsi

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)

All responses Img

All responses (3)

Answers Img

Answers (0)

Tim Schofield on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

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

Hi Tim,

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

Was this reply helpful? Yes No
Tim Schofield on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Community Member 4

#1

Martin Tocauer 4

#3

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans