I want to develop material ageing report based on FIFO method for given date.
The user will provide the list of material, plant and Date for ageing report. System should fetch up the stock as on given date i.e. 500 Nos, then system should check the last receipts of the said material and calculate the ageing between date of receipt and given date. i.e. there are last three receipt are 200 nos + 150 nos + 150 nos, the system will check the receipt date of said three receipt and calculate the ageing of said material.
I want to know the tables and field or any other details which i can use for preparing the functional specification.