Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Cost Price by Variant vs Product Dimension Group

Posted on by 77

Hi 

I have setup a product dimension group that has both colour and size active, but only size is active for purchase/ sales .

This now allows me to add pricing as follows

Size A  | Colour (blank)  Value $ X

Size B | Colour (blank)  Value $ Y

This works well in all my trade agreements as expected. however I wish this logic to flow through to the calculated costs as well?

Currently when cost price by variant is selected it still breaks this down to each and every variant instead of just one line per size.

 

Any ideas on a possible solution ?

  • Charles0252 Profile Picture
    Charles0252 77 on at
    RE: Cost Price by Variant vs Product Dimension Group

    Hi Charlotte

    Thanks for your reply, however I have already activated this value in released products, the problem I have is with the pending / actove costs.

    Ultimately by setting my product dimension group as

    EG, Colour & Size but only size is active for purchase and sales orders I am able to load only 2 lines in my trade agreement 1 per size and all colours of that size attract the same Purchase or Sales price. The issue at the end is that under manage costs the cost is then split down to each colour & size again.

    See below

    pastedimage1678823164852v1.png

    Trade Agreement

    2023_2D00_03_2D00_15_5F00_8_2D00_48_2D00_28.jpg

    Cost Price

    pastedimage1678823589130v5.jpeg

  • Suggested answer
    Charlotte X Profile Picture
    Charlotte X on at
    RE: Cost Price by Variant vs Product Dimension Group

    Hi Charles,

    According to your description, you can enable the use of cost price by variant setting for products in Cost management>Cost administration>Released products, and you can check out the following links for questions and discussions related to you, if needed.

    Product variant cost price - Microsoft Dynamics AX Forum Community Forum

    Defining Sales price on product variants - Dynamics 365 Supply Chain Management Forum Community Forum

    pastedimage1678784893609v1.jpeg

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans