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

All responses (11)

Answers (1)

Guy Terry 28,714 Super User 2025 Season 1 on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

Hi Nils,

A note on using the On-hand inquiry to view cost amounts. On your Storage and Tracking dimensions, some will be enabled for 'Financial Inventory'.

When using the On-hand inquiry to view your Financial Inventory, you should ensure you can see the Dimensions which are enabled for Financial inventory (and only those dimensions).

I note in your first screen shot that you have the Pallet dimension enabled. AX is most likely not tracking financial inventory at pallet level, so viewing the financial inventory for the pallet level does not make sense.
Community Member on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

Thank you for your efforts!
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

Yes
Community Member on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

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?
Verified answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

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
Community Member on at

Like (0)

Report

RE: On-hand financial cost amount (missing)
Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

can you send to me this transaction in excel?

and share item model group setup?
Community Member on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

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.
Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

the cost for every site is 0 ??!
Community Member on at

Like (0)

Report

RE: On-hand financial cost amount (missing)

we don't use serial numbers