Skip to Content
Former Member
Jun 20, 2011 at 05:51 AM

FIFO Query to generate report Which relates the out-quantity to in-quantity


Dear Experts,

I am trying to generate a report to find out the Inward documents of Items which are issued or transfered. Items are managed with FIFO. Certain Items are serially managed and certain not.

I am using the tables OIVL, OIVE and OIVQ for getting the details.

Now my problem is in certain situations the relation between OIVE and OIVQ returns more line items than required and not able to specifically found out the rows. (Same TreeID is used for several transactions)

Please help

Thanks and regards

Ajith Gopalakrishnan