Pricing and discounts to products on retail module
Published on: Mar 4, 2016
Transcripts - Pricing and discounts to products on retail module
Pricing and discounts to products on retail module
First of all we need to create Price Groups, you can use price groups to create and manage prices
and discounts for retail products. For example, you could use price groups to offer specific products at
different prices to different groups of customers in different stores.
Set price in a Channel
1. - Creation of a price group
Click Retail > Setup > Pricing and discounts > Price groups.
In the Price groups form, click New to create a new price group.
In the Price group’s field, enter a unique ID number for the price group, and then, in
the Name field, enter a descriptive name for the price group.
If the price group is exclusively a retail price group, select the Retail check box. Only these price
groups are available for retail-specific discounts.
2. - Link the price group to a channel
Click Retail > Common > Retail channels > Retail stores.
On the Retail stores list page, select a store, and then click Edit.
In the Stores form, on the Action Pane, in the Pricing group, click Price groups.
In the Retail channel price groups form, click New, and then in the Price group field, select the
price group that you created in the previous procedure.
Close the Retail channel price groups form.
3.-Create trade agreements
Click Sales and marketing > Journals > Price/discount agreement journals.
In the Price/discount agreement journals form, click New to create a journal.
In the Name field, select a journal type.
On the General tab, set the Default relation field to Price (sales).
In the Journal lines, price/discount agreement form, press Ctrl+N to add a line, and then in
the Relation field, select Price (sales).
In the Account code field, select Group.
In the Account selection field, select the price group that you created in the first procedure.
In the Item code field, select Table.
In the Item relation field, select the product whose price you want to change.
If the product is a variant, select the appropriate values in the Configuration, Size, Color,
and Style fields.
In the Amount in currency field, enter the new price.
Select the Find next check box.
After the journal is posted, close the Price/discount agreement journals form.
4. - Send the changes to the channel
Click Retail > Periodic > Data distribution > Distribution schedule.
In the Distribution schedule form, for each of following jobs, select the job in the list. Then
click Run now or, to run the job later, click Create batch job.
1. 1020 – Discount
2. 1040 – Products, prices, and bar codes
3. 1070 – Channels and tenders
Close the Distribution schedule form.
Set category-based prices
This topic explains how to manage the prices of many products at the same time by using price rules and
price groups that affect entire categories of products. This is especially useful if your company has many
You can specify a markup, margin, or fixed amount for the products in one or more categories, and then
generate a price/discount agreement journal for sales prices. You can also limit the selected products to
specific price groups and vendors.
The results of the proposed changes are displayed as an unposted price/discount agreement journal so
you can modify them before you make the changes final.
To set category-based prices, follow these steps:
The price group created
Click Retail > Periodic > Category price rules.
In the Category price rules form, click New to create a price rule.
In the Account code field, select Group, and then select a price group in the Account
In the Category field, select a category at any level from one of the retail category hierarchies.
To price only the products from a specific vendor, select a vendor in the Vendor account field.
In the Price rule field, select which type of price change to use:
1. Markup – A percentage of the price basis is used to calculate the sales price.
1. Example: A product that costs 10.00 and sells for 15.00 has a markup of 50
2. Margin – A percentage of the sales price that is used to calculate the amount of profit.
1. Example: A product that costs 10.00 and sells for 15.00 has a margin of 33.3
3. Fixed amount – An amount added to the price basis that is used to calculate the sales
1. Example: A product that costs 10.00 and sells for 15.00 has a fixed amount of
In the Price basis field, select the type of price to modify:
1. Base cost – The amount that the retailer paid to the supplier.
2. Base price – The sales price before trade agreements and price adjustments are applied.
3. Current price – The sales price after trade agreements and price adjustments are applied.
In the Amount / percent field, enter a percentage or the amount of the price change.
In the Rounding version field, select a rounding method.
To price for a specific unit of measure, select a unit in the Unit field. If this field is left blank, the
product’s default unit of measure is used.
Click Generate trade agreements.
On the Product selection page of the Generate trade agreements form, select which items to
price, and then click Next >:
1. All items – Price all the products in the selected categories.
2. Items without prices – Price only the products that don’t have prices. You might select
this option to price products that have recently been added to Microsoft Dynamics AX
and that don’t yet have prices.
On the Trade agreement options page, select options for the trade agreements that will be
created, and then click Next >.
On the Price summary page, review the summary.
Select the Run as a batch job check box to use a batch job to generate the price/discount
agreement journal at another time. You will still have to post the journal after it is generated.
1. You might want to use a batch job if you’re updating lots of products, which could take a
1. If you didn’t select the Run as a batch job check box, the proposed price changes are
displayed in the Journal lines, price/discount agreement form.
Review the proposed price changes, make any modifications, and then click Post.
Set prices in a catalog
This topic explains how to manage the prices of retail products in catalogs by using price groups.
To set prices in a catalog, complete the following tasks in this order:
1. Create a price group
2. Link the price group to a catalog
3. Create trade agreements
4. Send the changes to the stores
Create a price group
1. Click Retail > Setup > Pricing and discounts > Price groups.
2. In the Price groups form, click New to create a new price group.
3. Enter an identification code, and a descriptive name for the price group.
4. Select the Retail check box to identify the price group as an exclusively retail price group.
5. Close the Price groups form.
Link the price group to a catalog
1. Click Retail > Common > Catalogs > Catalogs.
2. In the Catalogs list page, select a catalog, and then click Edit.
3. In the Catalogs form, on the Action Pane, in the Pricelist group, click Price groups.
4. In the Catalog price groups form, click Add, and then in the Price group field, select the price
group that you created in step 1.
5. Close the Catalog price groups form.
6. In the Catalogs form, on the Action Pane, in the Publish group, click Validate catalog.
7. In the Validate catalog form, click Validate catalog, and then close the form.
8. In the Catalogs form, in the workflow message bar, click Submit.
9. Close the Catalogs form.
In Retail, you can make price adjustments to products, as well as set up discounts that are
applied to a line item or a transaction at the point of sale. Both price adjustments and discounts
can be linked to specific price groups. You can also specify start dates and end dates. You can
delete a price adjustment or a discount. However, statistical information is lost.
Price adjustments and discounts can be applied to products, variants, or retail hierarchies. If
more than one discount applies to a product, a customer may receive either one discount or a
Microsoft Dynamics AX for Retail POS automatically applies the discount or combination of
discounts that gives the best price to the customer.
Simple discount – A single percentage or amount.
Quantity discount – A discount for the purchase of one or more specific quantities.
Threshold discount – A discount for a transaction total.
Mix and match discount – A discount for purchasing a combination of products.
Both price adjustments and discounts can be associated with specific price groups, which can then be
associated with channels, catalogs, affiliations, and loyalty programs.
1. Click Retail > Common > Pricing and discounts > Price adjustments.
2. Click New to create a new price adjustment.
3. Enter a discount ID number and a name for the price adjustment. If number sequences are set up,
the ID number is entered automatically.
4. On the General FastTab, in the Status field, select Enabled or Disabled to enable or disable the