When Parts are removed from Inventory using the FIXED cost method, the Quantity will be deducted from the oldest active (in green) Part History record's Current Quantity column (in blue). The unit price associated with the Parts removed will be the Avg. Cost (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 |