Parts activity - standard reports |
Location ID and Equipment ID Columns Expanded in the Database: Effective with Release 6.0.x, location ID columns were expanded from 6 to 10 characters and equipment ID columns were expanded from 12 characters to 20 characters.
Although the location ID and equipment ID fields throughout the GUI were expanded, standard reports in the Query/Report Generator were not changed to accommodate the expansion. If you use more than 6 characters for a location ID or 12 characters for an equipment ID, you will need to modify your reports to ensure that they display the full number of characters.
Note: Using a longer location ID may increase the size of part bar codes. If a part bar code is too long, it may run off the right side of the label and become unusable.
Tip: Before you run the conversion against your production data, make sure that you run a test conversion from your current version to 6.0.x. The conversion could take a long time to complete as these expansions affect several large tables. You will need to plan how much time to set aside for your production conversion.
The application includes the following parts activity reports, available from the Reports list box in the Standard toolbar. For a sample of these reports, refer to the Directory of Standard Reports.
PR:PTS-ADJUSTMENTS: Lists parts with a quantity and/or value which has been adjusted in a specified month.
PR:PTS-ADJUSTMENT DAILY: Lists parts with a quantity and/or value which has been adjusted on a specified date.
PR:PTS-ADJUSTMENT DETAIL: Lists parts with a quantity and/or value which has been adjusted on a specified date and provides details about the adjustment.
PR:PTS-DLY ACTV BY ID-CEN: Lists all parts that were ordered, received, issued, adjusted, transferred in, or transferred out on the current system date. This report is designed for organizations that specify CENTRALLY in the Manage parts ordering and Economic Order Quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen.
PR:PTS-DLY ACTV BY ID-LOC: Lists all parts that were ordered, received, issued, adjusted, transferred in, or transferred out on the current system date. This report is designed for organizations that specify BY LOCATION in the Manage parts ordering and Economic Order Quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen.
PR:PTS-DLY ACTV BY KW-CEN: Lists, by keyword, all parts that were ordered, received, issued, adjusted, transferred in, or transferred out on the current system date. This report is designed for organizations that specify CENTRALLY in the Manage parts ordering and Economic Order Quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen.
PR:PTS-DLY ACTV BY KW-LOC: Provides a specified purchase order’s requisition order form for a vendor. This report is designed for organizations that specify BY LOCATION in the Manage parts ordering and Economic Order Quantity (EOQ) values field on the General tab of the Data -> Parts Items -> Setup -> Options screen.
PR:PTS-ISSUES DETAIL: Lists negative cost values for returned parts posted on the Data -> Parts Activity -> Direct Issues screen.
PR:PTS-ISSUES DIRECT-ACT: Lists negative cost values for returned parts, posted to account IDs, on the Data -> Parts Activity -> Direct Issues screen.
PR:PTS-ISSUES DIRECT-DPT: Lists negative cost values for returned parts, posted to departments, on the Data -> Parts Activity -> Direct Issues screen.
PR:PTS-ISSUES DIRECT-EQ: Lists negative cost values for returned parts, posted to equipment units, on the Data -> Parts Activity -> Direct Issues screen.
PR:PTS-ISSUES DIRECT-LOC: Lists negative cost values for returned parts, posted to locations, on the Data -> Parts Activity -> Direct Issues screen.
PR:PTS-ISSUES NON INV: Lists all non-inventory parts that were issued to work orders within a specified range of issue dates.
PR:PTS-ISSUES PTS-LEAST: Lists parts, for a range of location IDs, that have the lowest issues from inventory during a specific issue month.
PR:PTS-ISSUES PTS-TOP: Lists parts, for a range of location IDs, that have the highest issues from inventory during a specific issue month.