Physical inventory by inventory dimension report

Finance and Operations/AX User Forum
1

Hi,

Can anyone explain to me what is those columns at Physical inventory by inventory dimension report?

We are using FIFO,

I dont understand what each of the following is except for a few

Deducted Received On-hand Financial value Physical value (posted) Physical value (not posted) Inventory value Known financial difference Estimated inventory value

Thanks

2

Deducted - An issue which is not posted financially (Ex: Qty in SO which is updated to packingslip but Invoice yet to be posted)

Received - A receipt transactions which is not posted financially (PO with packingslip updated but not yet invoiced)

Financial Value - Financial cost of the posted quantity

Physical value(Posted) - Total amount for which Pslip posted but invoice not yet posted)

Physical value(not posted) - Total amount “Registration/Picking” is posted but packingslip not yet posted.

Inventory value - (Financial value+physical value(posted + Not posted)

3

Hi Santosh,

Can you please let me know in which scenarios value in “Physical value(not posted) - Total amount “Registration/Picking” is posted but packingslip not yet posted.” comes.?

Means by doing which type of transaction, value will come in the "Physical value(not posted) ".?

Thanks in advance.

Jainal

4

Create a PO and do the registration of the items. This will be Physical value(not posted) because physically you have the stock but the packingslip yet to be posted.

5

ok.

does this field get any value at the time of Sales Order.?

Means is it possible that I can get value in to “Deducted” and "Physical Value (Not Poster).?

Thanks,

Jainal

6

From sales side, you will get this value when you do the picking i.e., when the status is “picked”.