why is Cost Price is ZERO?

(0) Share

Report

Posted on by Abdo Khoury

14,855

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

I have the same question (0)

All responses (15)

Answers (2)

Verified answer

Weaveriski 23,616 Moderator on at

Like (0)

Report

RE: why is Cost Price is ZERO?

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.

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: why is Cost Price is ZERO?

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

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,866 Moderator on at

Like (0)

Report

RE: why is Cost Price is ZERO?

It looks like you run negative stock; is that right? I think this might be the cause, but I want to test it. After all, how can AX know the cost of items you haven't purchased yet?

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: why is Cost Price is ZERO?

is this a technical issue or something missing in my setup?

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: why is Cost Price is ZERO?

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?

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: why is Cost Price is ZERO?

thank guys , that is clear

but even at site level , it is not showing any cost

something seems to be missing

Was this reply helpful? Yes No
Guy Terry 28,866 Moderator on at

Like (0)

Report

RE: why is Cost Price is ZERO?

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.

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: why is Cost Price is ZERO?

I am very much interested to understand the reason, not just solve the issue.

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report

RE: why is Cost Price is ZERO?

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

Was this reply helpful? Yes No
Guy Terry 28,866 Moderator on at

Like (0)

Report

RE: why is Cost Price is ZERO?

Hi Silvano,

On the item's Storage and Tracking dimension groups, what lines are ticked 'Active' and 'Financial inventory'?

On the item's Item model group, is 'Include physical value' ticked?

Was this reply helpful? Yes No