Bar code - standard reports |
Location ID and Equipment ID Columns Expanded in the Database: Effective with Release 6.0.x, location ID columns expanded from 6 to 10 characters and equipment ID columns 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 bar code reports, which are available from the Reports list box in the Standard toolbar. For a sample of these reports, refer to the Directory of Standard Reports. (To use bar codes, the optional Bar Code module must be installed.)
PR:BC-DIRECT TIME CODES: Lists direct time-code bar codes and provides their time code and description.
PR:BC-EMPLOYEES: Lists employee bar codes and provides their employee name and ID.
PR:BC-INDIRECT TIME CODES: Lists indirect time-code bar codes and provides their time code and description.
PR:BC-LOC(ation) CODES: Lists location code bar codes and provides their location code and description.
PR:BC-PART FAIL CODES: Lists part fail code bar codes and provides their failure code and description.
PR:BC-PARTS BY ID: Lists part ID bar codes (up to 22 characters), sorted by location ID and part ID/suffix. It provides part descriptions.
PR:BC-PARTS BY LOC(ation): Lists a specified location’s part ID bar codes (up to 22 characters). It provides part descriptions.
PR:BC-TASK CODES: Lists task bar codes and provides their task ID.
PR:BC-VENDORS: Lists vendor bar codes and provides their vendor ID and name.