You’re offline. This is a read only version of the page.
14,849
Dear
I have a case where COGS is not being posted to ledger when a sales order is invoiced. so i investigated and found that the field Cost Price is ZERO in the Inventory On-Hand Form
Although there are receipt transactions to this item,
i was trying to check what could cause the issue i found , i found that the Price update Last Cost Price was not checked,
but i created another item with the same setup and did a receiving and the Cost price field was filled even without this check
the item model group is weighted average
any idea's what to investigate next ?
*This post is locked for comments
Whilst the item is in a negative position AX will not recalculate the stock - in your test system receipt in enough to have positive inventory and then run the inventory recalculation.
The reason for the zero at the start is the creation of the item at zero, the item cost of the first one would eventually recalculate, but only when a recalculation is run and the inventory position is positive.
True , and True , AX can't possibly know
but the weird part is i have other items that are setup the same exact way, and with the exact same circumstances meaning , Sales , Sales , Sales then Receipt and yet the field cost price is filled,
and even after i ran inventory calculation yesterday , the field didn't blink
is this a technical issue or something missing in my setup?
I ran inventory recalculation , for this specific item , i thought maybe this will update the Cost price field but it didn't , it did though post a ledger journal for the COGS that has not been posted yet , i thought this might fix the issue ,
any other ideas?
thank guys , that is clear
but even at site level , it is not showing any cost
something seems to be missing
In your first screen shot of the On-hand inquiry, were you looking at your inventory with the Warehouse dimension shown?
When using the On-hand inquiry to look at the cost of your stock, you should use Dimension display to ensure that only Site is visible.
This is because you are tracking financial inventory at the Site level only. Looking at the cost of your stock at, say, Warehouse level will give you odd results, because AX is not tracking cost at that level.
I am very much interested to understand the reason, not just solve the issue.
Hey Guy
on the storage dimension group Physical Inventory is Checked at the Warehouse level
Tracking dimension group is NONE
and yes the include Physical value is checked
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 (