On-hand financial cost amount (missing)

(0) Share

Report

Posted on by Community Member

Hi,

i'm currently struggeling with On-hand financial cost amount (screenshot).

It's a purchased item and we use "Weighted avg. date" as the inventory model. "Post physical inventory" and "Post financial inventory" are ticked in item model group. There were two product receipts with cost amount > 0 and one without any costs (all by purchase orders).

All items received with a cost amount where already consumed bei production orders, so the remaining on-hand qty was received with zero costs. But due to the inventory model the financial cost amount shouldn't be zero right? I expected the weighted average costs to be displayed in the On-hand form but it's missing completely. What did i forget?

Regards,

Nils

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Mahmoud Hakim 17,887 on at

Like (0)

Report

can you display site, warehouse, batch, serial in on hand form ??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

we don't use serial numbers

Was this reply helpful? Yes No
Mahmoud Hakim 17,887 on at

Like (0)

Report

the cost for every site is 0 ??!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There is only one site. Yes the displayed cost for this particular on-hand is zero. As i said we "purchased" the last pallet with zero costs, but there where two other purchase orders with cost amount, so i don't understand why the "weighted average" is 0. Maybe i missed a piece in the workflow that updates the cost amount on the on-hand inventory? I thought every transaction updates the cost amount.

Was this reply helpful? Yes No
Mahmoud Hakim 17,887 on at

Like (0)

Report

can you send to me this transaction in excel?

and share item model group setup?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

Hi Nils

I review this transaction and system calculate correctly as shown below

before last transaction Total quantity is zero and last purchase order with amount zero, so moving avg is zero

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

So the item's cost will stay 0 until a new purchase order is invoiced and all future transactions will calculate with zero costs for this item?

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

Yes

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your efforts!

Was this reply helpful? Yes No