Sumit Potbhare

Microsoft Dynamics AX for Retail

Customer-based discount using Retail Periodic discounts in Dynamics AX for Retail R3

Hi Guys, Its been a long time since I have written a new blog. So I though of staring with something light. I have seen many people exploring the possibilities of the Retail Periodic discounts and the challenges and limitations associated with it. There was a question regarding the Customer based discount on retail POS using the Retail Periodic discount. So I thought of writing a blog post to explain in a better way how to configure a Customer based retail Periodic discount. So first lets start with the basics –

 Retail Periodic discount

What is Retail Periodic discount? This term might be new to some people but Retail periodic discounts are nothing but the Discounts configured in the Retail module which are as follows:

  1.  Discounts
  2. Mix and match discounts
  3. Quantity discounts
  4. Threshold discounts
  5. Price adjustments

The path is as follows : Retail >> Common >> Pricing and discounts


Affiliations are useful when the retail stores give discounts to a particular group of customers that are affiliated with your Retail store. These can be considered as the discounts to the Loyal customers to provide extra benefit to them.

To set up affiliations first we need to create a price group, follow these steps:

  1. Go to Retail > Setup > Pricing and discounts > Price groups.
  2. In the Price groups form, click New to create a new price group.
  3. Select the Retail check box if the price group is exclusively a retail price group. These price groups are only available for retail-specific discounts.
  4. In this illustration, I have created a Price group “CBased”. You can use some other names which is more relevant to your Discount.

Price group

Once the price group is created, it is time to create an affiliation and attach it to the price group. Follow these steps:

  1. Click Retail > Setup > Pricing and discounts > Affiliations.
  2. In the Affiliations form, click New.
  3. Enter a name and a description for the affiliation.
  4.  Click Price groups.
  5. In the Affiliation price groups form, click Add, and then in the Price group column, select the price group that you created above.

Price group

Price group

Mix and Match discount

In this I will take example from Mix and Match discount. You can configure any type of Retail periodic discount. This procedure works for all type.

In my earlier blog I have explained the configuration of BOGO free discount using Mix and Match discount. Follow the same blog to create a discount – ( However you can create another discount type such as % off or amount off.

Now assign the above created Price group to the Discount.


Price groupNow go to the Customer form, select the customer and click on retail action pane. Click on Affiliation and select the affiliation created above. Now the discount will be triggered only for this Customer. This makes it a customer based discount. Run the scheduler jobs 1020,1010,1050 and the try it on POS.

Do comment if you face any difficulty in applying this.

Enjoy RetailDAXing…


Disclaimer: The information in the weblog is provided “AS IS”; with no warranties, and confers no rights. All blog entries and editorial comments are the opinions of the author.

Single Post Navigation

One thought on “Customer-based discount using Retail Periodic discounts in Dynamics AX for Retail R3

  1. Hi Summit,

    Interesting area but I have one issue it is not working for me.. can you please help me where I am missing any configuration.

    Your response will help me alot..


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: