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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Sales price Agreements

(0) ShareShare
ReportReport
Posted on by
Hi All,
 
Can anyone please help me with the following scenario? Lets say I have two inter company customers A & B. I want to sell my inventory at cost for A and 10% markup on B for all items.
 
My thinking is to firstly create a Trade Agreement journal type for Price (sales). Then I create a new trade agreement journal and make the account code Table and specify the customer. I should then name the item code All, correct?
 
Now I am not sure what the next step is. Should I create an attribute-based pricing ID? If so, what will the variables and formula be? If attribute pricing is not correct, what must I then use?
 
Regards,
Surya.V.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Fredrik Sætre Profile Picture
    12,644 on at
    RE: Sales price Agreements

    You add a price group to your items grouping them in categories A and B.

    Then you create a trade agreement with the customer and instead of selecting All, you select the groups.

    Put one line with the price for the default cost and then create a new one with a 10% add on it.

    As this is an intercompany sales order and you need to have cost it is simple if you have standard cost. Then you can set a fixed price. The issue is if you use FIFO or something else.

    If you do not use standard cost. Maybe you would set the sales price to be automatically generated based on cost price. Make sure that your cost price is always updated and tick the update sales price and base it on cost price. Set the calculation to have 0 addon. This should update your sales price. This can be used for the A items. On B items you do a 10 percent addition.

    Remember to add a price agreement for all other customers if you sell direct to market as well. You do this by creating a customer price group ("customers" and "internal") and using this when entering a price agreement.

    Good luck.

  • real_ashwin Profile Picture
    1,225 on at
    RE: Sales price Agreements

    So create 2 different Trade agreements for each customer that should work but you have to define price for each item.

  • Community Member Profile Picture
    on at
    RE: Sales price Agreements

    Hi All,

    Thanks for the quick response.

    I was just trying to find a process by which i can send the same item 001 to customer A and customer B for different pricing .

    Example:

    Item  001 value is 100

    I will sell the item to A at 100$

    and to B at 110 which is an markup of 10%

    Request you to suggest how can i fit this process in AX 2012 R3.

    Regards,

    Surya.V.

  • real_ashwin Profile Picture
    1,225 on at
    RE: Sales price Agreements

    I believe you mean sales instead of cost right?  If it is sales cant you just create 2 different price lists for each company itemwise?

  • Guy Terry Profile Picture
    28,870 Moderator on at
    RE: Sales price Agreements

    Hi Surya,

    Are the items that you are selling costed using Standard Cost?

  • Sagar Suman Profile Picture
    6,248 Super User 2025 Season 2 on at
    RE: Sales price Agreements

    Hi Surya,

    I think you mean sales price in this quote of yours " I want to sell my inventory at cost for A and 10% markup on B for all items"

    You cannot control cost price with which inventory will be sold through sales agreement.

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Community Member Profile Picture

Community Member 2

#1
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans