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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Sales Discount with Sales Tax - Strange calculation at Sales Discount

(0) ShareShare
ReportReport
Posted on by 190

Hi,

We are applying sales line discount manually on the sales order and the price is inclusive of tax. The system is booking tax on the price after the discount, booking receivable correctly, however, revenue and discounts are not correct. 

Please consider this example:

Unit Price 1000

Net Amount = 1000 (Inclusive of tax)

Sales Tax  = 10%

Discount (on item line) = 100

Now please see the voucher for the sales invoice.

Sales-Discount-and-Tax.png

Please see that the discount is not booked with 100 but with 91.7 (deducting 10% inclusive) and Revenue is not booked with 1000. I would like to understand why this is happening?

I tried different configuration of sales tax:

Origin = Percentage of Net Amount, Margin = net amount per line

Origin = Percentage of Gross Amount, Margin = Gross amount per line

and some others. But no luck.

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Khalid Ashraf Profile Picture
    190 on at
    RE: Sales Discount with Sales Tax - Strange calculation at Sales Discount

    What we would like is to system post the discount with 100 and Revenue with 1000 - Sales tax over net price 925.69.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans