This is a quick walk through of setting up total discounts for a customer. With trade agreements this is specified optionally in 3 ways as a singled discount, a tiered discount and a fixed amount. These are configured with the trade agreement or the price discount agreement journal.
This can be specified as a discount 1 %, discount 2 %. If you use both the fields for the % then it’s tiered as you will see in the walk through. The calculation is
((100 * discount 1 %) + ((100 – (100 * discount 1 %)) * discount 2 %))
if we replace the values
((100 * 0.02) + ((100 – (100 * 0.02)) * 0.02))
This calculates as
2 + 1.96=3.96%
100 * 3.96% = 96.04
In the video you can see the result
So use the discounts as you see for encouraging the behavior you need from your customers.
Cheers
Lachlan
OrganicAX 
Pingback: Calculate total discount on posting Accounts Receivable parameter | OrganicAX·
Pingback: Calculate total discount on posting Accounts Receivable parameter - Microsoft Dynamics AX Community·
Hello Lachlan,
Am very nw to AX 2012 and now have a request to adjust how discounts are applied to customer…
The request is:
For each customer, condition 1. If they pay on time they will get a percentage discount from their total(the exact base price), (the total on the invoice is a premium), condition 2. If the customer pays before the due date then another set of percentage discount is attached to their bill and finally condition 3. If the customer pays after the due date then they pay the amount billed on the invoice (bill at premium).
Your help is greatly apprectiated
LikeLike
Hi Lionel
You will have to have a look at Cash Discounts for this.
https://technet.microsoft.com/en-us/library/aa496945.aspx
https://technet.microsoft.com/en-us/library/aa590275.aspx
https://dynamicsax-fico.com/tag/cash-discounts/
I don’t think I did a recording yet of the customer side cash discount but you can see the payment side here.
https://organicax.com/2014/10/02/accounts-payable-payment-processing/
Cheers
Lachlan
LikeLike
Lachlan,
Thanks a mil for your response. i have implemented same following your link and it sem to be working fine. my only oncern is the follow:
So when a customer pays and amount which is more that the invoice amount how does DAX treat that discount and the extras? Any help would be greately appreciated
LikeLike
Hi Lionel
Usually the customer pays as minimal as possible and hence you might have to deal with a deduction. Here is a link to a quick overview of that https://organicax.com/2017/04/24/customer-deducations-from-payments/
If the customer overpays you would need to decide if you want to handle that as extra revenue or try to credit them so that is the likely outcome. You can over accept payment if the customer pays you more so that might put the customer in credit. You can decide if you just leave that if they are a frequent customer or decide to pay them back. There are a couple of ways to handle the re-payment.
https://organicax.com/2015/06/17/paying-a-customer-their-balance-second-option/
Cheers
Lachlan
LikeLike