Part History Tab

The Part History grid documents:

when parts are added to Inventory,

when parts are returned to Inventory from a Work Order (dispersed by mistake and then deleted); and

when parts are understocked.

Most information in this grid is automatically populated by the system and cannot be deleted. The exception is the Cost Per Unit, which is the only field that can be edited.

A sample of the Part History grid appears below. Sort records in the grid by clicking on the headings. An up or down arrow (highlighted in orange below) indicates whether data appear in ascending or descending order.

Double-click on an existing record to open it.

Right-click on an existing record for options to Adjust Cost Per Unit or Change PO Number.

Adjust Cost Per Unit - Enables users to change the Cost Per Unit field for a historical record.
Change PO Number - Enables users to change the PO to which the transaction is linked.

Grid Columns

Inventoried Date

Tracks the date the Part was added to or removed from Inventory (either from the Inventory tab, Transactions tab, or On Order tab).

Cost Per Unit

Specifies the Per Item Cost at the time the Part was added to Inventory.

Note: This is the only field the user may edit. To edit, right-click in the record within the grid and select Adjust Cost Per Unit.

Note: If the Part is linked to the Work program (via the Material or Fluid Code), the Unit Cost entered here in the Parts Inventory overrides the Default Unit Cost in the resource's Work Flow Setup record. If the part is understocked, the system uses the last cost recorded until more inventory is received.

Original Qty.

Records the original quantity for each particular inventory transaction or order at the point the part was added to inventory.

Current Qty.

Tracks the part quantity remaining from each order after individual parts transactions or dispersals occur. As parts are used, the numbers in this column will decrease. The transaction the parts are removed from depends on the Cost Method selected on the Order Info Tab.

If using the FIFO cost method on the Order Info tab, part quantities will be adjusted in the order in which the parts were received. If using the LIFO cost method, part quantities will be adjusted in the reverse order in which the parts were received.

Thus, in the sample grid above, the parts Cost Method is set to LIFO. Two transactions added Parts to the Inventory. When parts were later removed, the items were subtracted from the last inventory transaction that occurred, rather than the first. We know this is true because, in the earlier transaction, the Original Quantity was 10, and its Current Quantity is 10. In the more recent transaction, the Original Quantity was 30, but its Current Quantity is 20.

PO Number

Tracks the Reference Number of the purchase order each time the part was added to or removed from inventory.

Avg. Cost

Calculates the average part cost using the following process:

Finds all records with a Current Quantity > 0.
Calculates Cost Per Unit x Current Quantity = Total Price for each of those records.
Finds the sum of all Total Price fields to find the Total:Total Price.
Finds the sum of all Current Quantity fields to find the Total:Current Quantity.
Calculates Total:Total Price/Total:Current Quantity = Average Cost.
Only updates the Avg. Cost field for the records where Current Quantity > 0.

Right-click in the grid and select Adjust Cost per Unit. The following warning appears:
Click OK to continue. The following window appears:
Enter the new cost per unit.
Enter the part's Reference Number.
Click .

Right-click on a record in the grid and select Change PO Number.
The following pop-up appears:
Enter a New Reference number for a different PO.
Click OK.