Movement

The Movement tab for parts items displays information about a part's movement and its internal rebuild activity. This tab contains summary data for all locations at which the part is stocked. Up to 500 months of history data displays.

For movement data and internal rebuild activity at a location, use the Movement tab of the Parts Items -> Location Information screen.

Tip: You can use the filter to restrict the information that displays to a specific part ID, part suffix, inventory month, keyword, stock status, product category, or part classification, among others. The list of searchable fields on the filter is extensive; use the scroll bar to view them all. If you specify a cross-reference part ID that cannot be found, the applicable part ID displays.
Note for Sybase database only: When the Manage parts ordering and Economic Order Quantity (EOQ) values field on the General tab of the Parts Items -> Setup -> Options screen specifies CENTRALLY, this tab does not display information for part movement for any month in which a part had order activity but no receipt, issue, special issue, adjustment, transfer in, or transfer out activity at any inventory location.

Detail View Header

The fields in the top section of this tab define the data that displays.

Part ID

Identifier of the part currently selected in the grid or that you are defining.

Note: If there is a check in the Enable automatic part numbering field on the Data -> Parts Items -> Setup -> Product Categories screen, the part ID is assigned automatically. Its characteristics, if any, are based on information entered in other fields on that screen.

The part ID may only consist of valid bar code characters. This field has a zoom button to the Data -> Parts Items -> Cross-references screen, which defines cross-references of part IDs. It also has a list box. The part description displays to the right of the ID. This field is required.

The combination of this part ID and the part suffix must be unique for each part.

To delete a part and all its data from inventory, refer to how to delete a part from inventory.
To delete a part from a specific location, use the Basic Info tab on the Parts Items -> Location Information screen.

Note: You cannot delete a record that has part quantities to be reconciled.

Part suffix

Number associated with the part in the Part ID field, which distinguishes it from other parts with the same part ID.

This applies only if the part ID is a valid part ID.

New part/location/inventory

If you are entering a new part, you can click the New part/location/inventory button to launch the Add New Part wizard. The wizard walks you through specifying the required data for the Part Primary, Part Location, and Inventory Adjustment screens.

Note: The wizard must be activated before it will launch. Refer to Add New Part Wizard for more information.

Detail View

The fields in the box in the bottom section of the tab, presented in a screen group, display information about the movement of the part during the time period specified. Data returned is limited to 12 rows, sorted by year and month in descending order. To view more than 12 rows, use the Queries/Reports -> Query/Report Generator screen to create and run a report that includes the information. You can also use Web Modules Reporting, Microsoft Access, or any other reporting tool to create and run reports. Refer the related documentation for these products. All fields are display only.

Month

The month to which the information in the columns to the right pertain.

Year

The year to which the information in the columns to the right pertain.

Order quantity

Quantity of units of the part that were ordered for all locations during the month and year specified previously.

Order value

Value of the orders for this part for all locations during the month and year specified previously.

Order quantity due out

Quantity of units of the part that were ordered on quick orders for specified work orders at all locations during the month and year specified previously.

Order value due out

Value of the orders for this part that were ordered on quick orders for specified work orders at all locations during the month and year specified previously.

Receipt quantity

Sum of the quantities of this part received at all locations during the month and year specified previously.

Receipt value

Sum of the values of this part received at all locations during the month and year specified previously.

Issue quantity

Sum of the quantities of this part issued to all locations during the month and year specified previously.

Issue value

Sum of the values of this part issued to all locations during the month and year specified previously.

Special issue quantity

Sum of the quantities of special issues of this part issued to all locations during the month and year specified previously.

Special issue value

Sum of the values of special issues of this part issued to all locations during the month and year specified previously.

Adjustment quantity

Sum of the quantities of adjustments of this part made at all locations during the month and year specified previously.

Adjustment value

Sum of the values of adjustments of this part made at all locations during the month and year specified previously.

Transfer in quantity

Sum of the quantities of this part transferred in to all locations during the month and year specified previously.

Transfer in value

Sum of the values of transfers of this part in to all locations during the month and year specified previously.

Transfer out quantity

Sum of the quantities of this part transferred out of all locations during the month and year specified previously.

Transfer out value

Sum of the values of transfers of this part out of all locations during the month and year specified previously.

Qty out for repair

Sum of the quantities of this part out for repair for all locations and out for repair during the month and year specified previously. This field updates automatically when you insert a part ID on the Line Items tab of the Parts Repair -> External Rebuilds screen.

Qty repaired

Sum of the quantities of this part repaired for all locations during the month and year specified previously.

Qty scrapped

Sum of the quantities of this part scrapped for all locations during the month and year specified previously.

Note: As of Release 5.8.5, scrapped consumable parts are not tracked.

Qty rebuilt

Sum of the quantities of this part rebuilt at all locations during the month and year in the Month and Year fields.

Note: Does not reflect data entered prior to Release 5.2.

Value rebuilt

Sum of the values of this part rebuilt at all locations during the month and year in the Month and Year fields.

Note: Does not reflect data entered prior to Release 5.2.

Fields to the right of the screen group provide additional information about the movement of the part. All fields are display only.

Last date

Order

Date of the last order of this part at any location.

Receipt

Date of the last receipt of this part at any location.

Issue

Date of the last issue of this part at any location.

Adjustment

Date of the last adjustment to the quantity of this part at locations that have a check in the Adjust inventory to counts for all items at this location ID for part counts on or after (date) field of the Parts Activity -> Inventory Counts screen.

Transfer in

Date of the last transfer in of this part to any location.

Transfer out

Date of the last transfer out of this part from any location.