Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) What table holds the i...

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 Microsoft Employee

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

All responses (1)

Answers (0)

Community Member Microsoft Employee 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