When Parts are removed from inventory using the Last In Last Out (LIFO) cost method, the Quantity will be deducted from the newest active (in green) Part History record's Current Quantity column (in blue). The unit price associated with the Parts removed will be the Cost per Unit (in yellow) from the History record that the Quantity was pulled from.
Inventoried Date |
Cost per Unit |
Original Qty. |
Current Qty. |
PO Number |
Avg. Cost |
8/20/2019 |
39.5 |
8 |
8 |
Added Thru Parts Module |
37.28 |
8/1/2019 |
35.5 |
10 |
10 |
Added Thru Parts Module |
37.28 |