web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

In Dynamics AX 2009 for Retail, how to setup different prices for a single item in different stores for all customers?

(0) ShareShare
ReportReport
Posted on by 145

In our company we have an item whose price is 40 in one store and 25 in another store. What is the correct way to setup AX for Retail in order to get this effect. We tried the following and failed to get the desired result:

1- We created a price group having the lower price and linked this price group to the cash customer of the store. No effect.

2- We tried the location filter wherein we specified the store in the "Groups to distribute to" of the price record in the trade agreement. It works only if you use A-Jobs and sometimes if you need to change the record should be deleted and entered again with the correct "Groups to distribute to".

I also looked at the code that selects the price in the POS. It creates a price arguments object on the store level and another on the customer level. The store level price arguments contain a price group argument but it is always empty, whereas the customer level price argument's price group contains the correct price group linked with the customer account.

Your input is highly appreciated

*This post is locked for comments

I have the same question (0)
  • Ivan Peraza Profile Picture
    130 on at

    We have have 2 stores, and items are priced sales per store, create two price groups and assign a price group to each store, in Retail> configure> prices and discounts, we indicated that the two groups are commercial prices.

    Importantly, the two stores point to a single database, I hope these comments help you, we do it in AX 2012

  • Tom Sebastian Profile Picture
    465 on at

    Hi Fato,

    Did you get any solution for the above issue? if yes, please share, I have the same issue.

  • Community Member Profile Picture
    on at

    Hi Fato,
    If I understand right, you need find different prices in sales (purchase) orders for specific stores. Stores are represented by dimensions (location in your case).

    1. You have to set which dimensions are involved in price finding. It is in Dimension group-> Item or storage dimension -> General -> Use in price search (For purchase and sales).
    2. Then you can use this dimension in trade agrmt. In order line price is changed every time when you change dimension.

    I hope it will help little bit.

    Daniel.

  • Fato Abdulfattah Profile Picture
    145 on at

    Dear Daniel,

    What you mentioned in your answer was the first thing we tried, expecting that it will work in the POS. However, setting prices by dimension in the trade agreements only applies to back office sales orders and purchase orders.

    We came to find out that setting different prices in different stores is controlled by distribution groups which are a bit complicated to set up and we finally ditched the whole idea of different prices.

  • Mustafa-Chohan Profile Picture
    on at

    Can you please let me know how to achieve this in Dynamics AX 2009 as we have a requirement to specific prices as per store

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Basit Profile Picture

Basit 1

#1
GL-01081504-0 Profile Picture

GL-01081504-0 1

#1
Roya Profile Picture

Roya 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans