Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / ABC Classification - w...
Microsoft Dynamics AX (Archived)

ABC Classification - where is value calculated?

(0) ShareShare
ReportReport
Posted on by Will Thornton 380

I am trying to run the 'Periodic' ABC Classification in Stock (that's invent-Ory if you are American!) & Warehouse Management. When I click OK I get a STOP error 'Total value is 0.00 GBP'.

I am using 'value' as the classification.

I have left the To/From dates empty (have tried entering various combinations).

I've sent A/B/C as 20/70/10.

I guess I'm asking where EXACTLY the value is pulled from in the item in order to generate the classification. There are so many cost/price/unit/quantity etc. fields on each item it seems that the one required here has not been completed. Any ideas what I have missed?

There are plenty of items in Stock - all received from purchase orders, so some sort of cost must have been calculated.

Many thanks if you can help - I am going mad trying to find where the difference is between our Test environment (classification works) and The Real Thing (does not). We are running R2.

*This post is locked for comments

  • Will Thornton Profile Picture
    Will Thornton 380 on at
    RE: ABC Classification - where is value calculated?

    We are running Standard Cost, so physical value is not an available option

  • Guy Terry Profile Picture
    Guy Terry 28,626 Super User 2024 Season 2 on at
    RE: ABC Classification - where is value calculated?

    By the way, I assume that your physically updated receipts do not influence the 'value' because you do not have 'include Physical Value' ticked on the Item Model Group (and you are not running standard cost). Am I right?

    Unless your purchase order prices (or production order estimated costs) are often significantly wrong, I would consider ticking it. Of course, your partner may know other valid reasons why it's not.

  • Will Thornton Profile Picture
    Will Thornton 380 on at
    RE: ABC Classification - where is value calculated?

    Have just run a test performing a stock adjustment and it posts the items financially, causing the ABC Classification to apply.

    Many thanks

  • Will Thornton Profile Picture
    Will Thornton 380 on at
    RE: ABC Classification - where is value calculated?

    Will find out for sure soon - but thank you very much. You've put a few minds at ease.

  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,626 Super User 2024 Season 2 on at
    RE: ABC Classification - where is value calculated?

    Posting a Stock journal will generate a financial cost.

    Stock journals do not have the Physical stock -> Financial stock concept that is used elsewhere. The stock is posted directly as financial.

    In this way, I assume the cost will be available to the ABC classification, but I don't know this functionality.

  • Will Thornton Profile Picture
    Will Thornton 380 on at
    RE: ABC Classification - where is value calculated?

    Hi Guy,

    We will be using stock journals to import the stock - as we haven't migrated all of the items across yet (as we are still defining the information required in AX that wasn't necessarily in O**cle we can't import the stock). Both a cost price and a stock level will be attached to the stock when it is transferred - will the journal generate a financial cost, so as to generate an accurate classification?

    Thanks again

  • Guy Terry Profile Picture
    Guy Terry 28,626 Super User 2024 Season 2 on at
    RE: ABC Classification - where is value calculated?

    Hi Will,

    Presumably you are using stock journals to import stock from your legacy application. Are you specifying a cost price or amount on these journals?

  • Will Thornton Profile Picture
    Will Thornton 380 on at
    RE: ABC Classification - where is value calculated?

    OK I've answered my own question. The value comes from the 'Financial Cost' of the item. Therefore, items that have been received into stock do not earn a classification until the invoice has been posted.

    The classification is then based on how much the stock has cost the company. This does not help with existing stock being transferred onto the system from our outgoing software, since the stock is being created without incurring a cost. It seems that we could be logging high value items that will be automatically classified as C, and will not be reclassified until significant orders have been made, and the classification refreshed - which is something we were hoping to do only once a year.

    So I've answered my own question, but there still seems to be a significant issue.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans