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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Item cost for base pro...
Microsoft Dynamics AX (Archived)

Item cost for base product and variants

(0) ShareShare
ReportReport
Posted on by Sreehari 2

In Dynamics 365 for Operations, I tried the following. Created two new items with 'Moving average' costing. Both items had two color variants Black and Blue. For one of the items, I enabled the flag for tracking 'cost by variant' and for the other the same was not enabled. I did multiple receipt transactions for both items (both colors) at different prices and then made one issue transaction. It looks like, irrespective of the flag enabled or not, item cost is maintained at the color level. i.e. issue cost is the average of only a particular color and not averaging the receipt price of both colors. Is it the normal behavior of AX? If so, we won't be able to maintain cost at the item level and it will be always at the dimension level (or variant level). Also the flag 'cost by variant' has no significance.

Please let me know your views.

*This post is locked for comments

I have the same question (2)
  • Nagendra Varma K Profile Picture
    Nagendra Varma K on at
    RE: Item cost for base product and variants

    Hi Sreehari,

    Cost by variant is used for standard cost method, to capture cost at variant level, So that the issue and receipts will be settled based on the cost activated.

    In your case when you say moving average, System will take average of receipts to issues based on the transactions.

    Thanks

    Nagendra Varma K

  • Sreehari Profile Picture
    Sreehari 2 on at
    RE: Item cost for base product and variants

    Thanks Nagendra.

    What about non-std cost items? The cost will be always maintained at item variant level?

  • Suggested answer
    Nagendra Varma K Profile Picture
    Nagendra Varma K on at
    RE: Item cost for base product and variants

    Hi Sreehari,

    The cost will be maintained variant level, However cost calculation will be dependent on transaction and average cost. regardless costing version.

    Thanks

    Nagendra Varma K

  • Tina Bex Profile Picture
    Tina Bex 10 on at
    RE: Item cost for base product and variants

    I am finding that I can see inventory journal receipt transactions by variant, which includes both unit price and total Amount. However I am not getting a physical cost for issue transactions at the product variant level. I only get a physical cost price at issue if I have selected last cost price update on the product master. Of course the cost price at product master is only one cost price rather than by variant.  Is this expected functionality?

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans