You’re offline. This is a read only version of the page.
485
Hello Experts,
I need some help in understanding what is happening with AX 2012. I have a particular item which when I look at the transactions on the items, the Cost Amount column is blank. This recently started to happen. It has never happened before. When I checked the database there is nothing in the column that should be used to populate this column
I have attached a screenshot to for your reference. Please anyone whit any idea as to what is causing this? please help.
*This post is locked for comments
Hello Lionel07,
If your question has been answered, please do not forget to mark the answer as verified to let also other community members know.
Many thanks for your support.
Best regards,
Ludwig
If you allow negative inventory, there is no limit on how negative you can go.
There's not much you can do other than continue to raise POs as and when, Invoice those POs and periodically run the Inventory close routine.
Does this co-incide with the item actually going negative inventory?
The FIFO model will cost your sales orders based on the cost of the receipts of the inventory that you are selling (i.e. if it's an item you purchase, it will use the cost from the Purchase orders). If you have no inventory (if you are going negative), then there are no POs which to base the cost on. When this happens, AX can try to use find the cost elsewhere. It can look at the Price field of the Manage costs fast tab. If that is blank, then AX cannot find a cost to use.... so it will use nothing.
However, because you are using the FIFO model, you are also using the Closing and adjustment functionality (i.e. Inventory close). When you do receive and invoice some Purchase orders for these items (or Production orders, or whatever), Inventory close will assign the cost from them to the Sales orders. Retrospectively, if you like.
Hi Guy, thanks for your response, to answer your questions:
the Inventory model that you have set on that Item's Item model group, and whether Include physical value is ticked. this is FIFO and physical value is ticked.
Is the item allowed to go negative in inventory? YES
does the item have Latest cost price ticked on the Manage costs fast tab? On the same tab, does the item have a Price set? Yes but no price is set.
It is weird because this just started happening as you can see from the screenshot.
I am attaching the inventory mode
.
It means that AX could not determine a cost for the item's when those sales order were invoiced. Are you able to investigate why?
If you need some pointers, please share some more information
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (