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)

UK VAT setup Supplier Discount & Settlement Discount on PO

(0) ShareShare
ReportReport
Posted on by

Hi, I'm usually able to sort issue out my self, however, I'm really stuck, can somone please give me some pointers?

How would one go about setting up AX to handle the case described in the link below?

https://www.brightpearl.com/support/documentation/supplier-discount-settlement-discount

Lets assume that the line total is 100 and the supplier gives a 5% discount if settled within 10 days. So far so good, however in the UK the calculation is a bit different from what I'm accustomed to,

The Vat (if settlement discount is given) is calculated as (100*(1-0,05)*0,2) = 19

Making the the invoice total 100+19 =119 (as opposed to 100*1,2 = 120)

How would I go about replicating this behaviour in Ax? If I try to set a line discount of 5% i get this calculation:

total value = 100 * 0,95 * 1,2 = 114.

I seem unable to get the 119 as the invoice total using the inquiries-->Totals on the PO.

I'm lost.

BR

KSA

*This post is locked for comments

I have the same question (0)
  • KS.A Profile Picture
    on at

    I should add that it it's paid on time I pay 100*0,9*1,2 = 108, but this i guess is normal settlement discount behaviour.

  • Guy Terry Profile Picture
    28,924 Moderator on at

    Hi KSA,

    I don't know how to get AX to do what you describe, but I note that HMRC in the UK are changing the way to account for what they call prompt payment discount from 1st April 2015. Have a look at these!

    www.gov.uk/.../vat-prompt-payment-discounts

    www.gov.uk/.../revenue-and-customs-brief-49-2014-vat-prompt-payment-discounts

    It looks a closer fit to what AX is doing. Perhaps HMRC have adopted a different business process to suit AX :-)

  • Guy Terry Profile Picture
    28,924 Moderator on at

    Hi KSA,

    I stumbled across this post (on an excellent blog) about how to setup Settlement discount for UK VAT. It doesn't mention additional discounts, but it might be a good starter.

    www.daxfinanceblog.com/.../vat-on-settlement-discount-ppd

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
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans