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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Will Thornton Profile Picture
    Will Thornton 380 on at

    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.

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    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

    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

  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    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

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

  • Will Thornton Profile Picture
    Will Thornton 380 on at

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

    Many thanks

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    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

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

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
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans