What table holds the inventory items cost amounts as they are entered into the inventory module using FIFO valuation method?

(0) Share

Report

Posted on by Community Member

What table holds the inventory items cost amounts as they are entered into the inventory module? using the inventory item valuation method of FIFO. Is there a sql query available? I would like to see what amounts are associated with the inventory item as it was entered into the GP.

Regards,

Deborah

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Community Member on at

Like (1)

Report

RE: What table holds the inventory items cost amounts as they are entered into the inventory module using FIFO valuation method?

It is under IV10200.

This table is a perpetual FIFO table so when you query into it, query only for records where QtyIn-QtyOut <> 0.

Cheers

Luc

Was this reply helpful? Yes No