Parts transfers - 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 following transfer reports are available from the Reports list box in the Standard toolbar. For a sample of these reports, refer to the Directory of Standard Reports.
TFR-TRANSFER DETAIL: Provides details about specified part transfers, including the status of the transfer; sending and receiving location IDs; shipping references; dates requested, transferred, received, and/or declined; part ID/suffix; and quantity requested
TFR-TRANSFER IN TRANSIT: Lists part transfers with a status of SEND PARTS OUT for a specified sending location
TFR-TRANSFER RECEIPTS: Lists all part transfers with a status of RECEIVE PARTS IN for a specified receiving location
TFR-TRANSFER REQUEST: Lists all part transfers with a status of REQUEST TRANSFER for a specified sending location
On a REQUEST PARTS action, the printout for the originating location lists the following information for each part: part ID, quantity, from bin, to bin, and keyword/short description.
On a SEND PARTS OUT action, the printout for both the originating and receiving locations lists the following information for each part: part ID, quantity, from bin (if available), to bin (if available), and keyword/short description.
TFR-TRANSFER STATUS: Lists all part transfers for a specified sending location within a specified range of insert dates