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)

Purchase order discount issue in calculation of gst

(0) ShareShare
ReportReport
Posted on by 515

Hi all,

In po if we define discount at line level then net amount is on purchase order report ( ap>all po > Purchase tab >journals> puchase order confirmations > select any version > preview/ print

In this report following are the observations..

> Price = (unit price * qty) - discount amount

It will calculate gst for each line and that will be applicable to above Price. So sum of gst for all po lines posted will be less than gst amount which is calculated without any discount. So there is mismatch in invoices reports one report is showing the po amount where they are calculating gst on price which excludes the discount and it shows this discount as rebate.

Now my question is

1. Is there any way by which gst will get calculated on price ( unit price * qty) and discount will get posted to discount ledger by doing some configuration?

2. Using x++ how we can post any custom amount to discount or any particular journal?

Any sample code or any pointers pls.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ZvikaR Profile Picture
    152 on at
    RE: Purchase order discount issue in calculation of gst

    It sound like before starting to customize the system the business need to discuss and agree to the correct accounting handling of this discount.

    It might be this can be solved with out of the box functionality. For example - if this is a cash discount given at time of payment, it can be configured to not impact tax.

  • Dhanshri Profile Picture
    515 on at
    RE: Purchase order discount issue in calculation of gst

    Yes this what i want to achieve.

    Actually i am technical and not sure about this setup and all. I dont know if it legal practice or not.even i am not sure where is the setup and should i change it or not . If not then how can acheive this by doing some customization?

  • Suggested answer
    ZvikaR Profile Picture
    152 on at
    RE: Purchase order discount issue in calculation of gst

    I am not sure what you are asking for.

    Are you asking for your discount to not impact your GST calculation?

    So you want to calculate GST on the whole amount, and then deduct from the invoice total the discount, without reducing the total tax?

    Are you sure this is legal practice in your country? it's definitely not legal in Canada....

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans