You’re offline. This is a read only version of the page.
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
We are running Standard Cost, so physical value is not an available option
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.
Have just run a test performing a stock adjustment and it posts the items financially, causing the ABC Classification to apply.
Many thanks
Will find out for sure soon - but thank you very much. You've put a few minds at ease.
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (