> Example

Your pricing method is FIFO. You have created a work order that creates demand for 10 air filters. Presently you have 19 air filters in stock with different insertion dates and prices. At the time of issue, the R5FIFO table contains the following information:

To fulfill the requested quantity of the air filters for the work order, Datastream 7i locates the 4 parts inserted into stock on 1-APR-2002 at 7 USD each, inserts a record of 4 parts at 7 USD into the R5ISSUES table, and then deletes the record of the 4 parts at 7 USD from the R5FIFO table. Datastream 7i then locates the 3 parts inserted into stock on 7-MAY-2002 at 8 USD each, inserts a record of the 3 parts at 8 USD into the R5ISSUES table, and then deletes the original record of the 3 parts from the R5FIFO table. Datastream 7i then locates the 8 parts inserted into stock on 10-JUN-2002 at 16 USD, inserts a record of 3 parts into the R5ISSUES table, and updates the quantity of the 10-JUN-2002 record to 5 in the R5FIFO table. Datastream 7i then creates the issue to the work order and calculates the transaction price of the issue using the following equation:

[(4 air filters @ 7 USD) + (3 air filters @ 8 USD) + (3 air filters @ 16 USD)] / 10 = 10 USD

After completing the issue to the work order, the R5ISSUES and R5FIFO tables contain the following information: