Your pricing method is FIFO. You approve a credit note valued at 100 USD associated with purchase order 10003. Before you approve the credit note, the R5FIFO table contains the following information:
|
Quantity in store |
Price |
Purchase order number |
|
1 |
8 USD |
|
|
6 |
10 USD |
10003 |
|
3 |
12 USD |
10004 |
Datastream 7i locates the 6 parts at 10 USD from the original purchase order 10003 in the R5FIFO table and applies 60 USD of the 100 USD credit to the value of the stock, reducing the stock value to 0 USD. Since 40 USD from the credit note still needs to be applied, but there are no other existing records in the R5FIFO table that are associated with the same purchase order line, Datastream 7i stores the remaining 40 USD from the credit note in the IVL_LOSTCREDIT column of the R5INVOICELINES table.
After approving the credit note, the R5FIFO table contains the following information:
|
Quantity in store |
Price |
Purchase order number |
|
1 |
8 USD |
|
|
6 |
0 USD |
10003 |
|
3 |
12 USD |
10004 |