Program Description
This report can be found on the Inventory Reports Inventory Control menu (INV-4-3-3). This report prints out the technicians warehouse inventory if the maximum on hand minus the on hand is greater than zero.
The following prompts are described below:
Beginning Technician Number, A'll, Or E'nd
Enter a specific technician number, or beginning technician number range. Enter A for all technicians to be included. Enter E to end the program and return to the menu. The technician is taken from the technicians Item Warehouse (ITEMWHD) file. (4 numeric)
Ending Technician Number
The beginning technician number will display as the ending technician number. Press enter to accept this as the ending technician number or enter an ending technician number. If the beginning technician number is greater than the ending technician, the following message will display: Beginning Technician Is Greater Than Ending Technician. The cursor will return to the ending technician number for re-entry. The technician is taken from the technicians item warehouse (ITEMWHD) file. (4 numeric)
Initialize Temporary Index (Y/N)
The MINV.IX index file stores warehouse, item number, and on hand. Enter Y for yes to delete and recreate this index for use in the report. Enter N for no to use the existing index and add and delete records to this index.
Results
The program will build two temporary indexes: MC#.IX and MINV.IX. It will go through the Item Warehouse index file (ITEMWHX) and calculate the maximum on hand minus the on hand amount. If this number is less than or equal to zero, the item record information is skipped. The first index (MC#.IX) stores the warehouse number, bin location from the Item (ITEM) file, item number, maximum on hand, on hand, and the bin location from the Item Warehouse file (ITEMWHD). This information is needed for sorting the report. The second index (MINV.IX) stores warehouse, item number and on hand. As the indexes are building, the following messages will display:
Building Indexes
Wh# Item#
Printing Report
Wh# Item#
The following screen display shows the results for all technicians warehouses:
TECHNICIAN
The technicians warehouse number will print once at the beginning of each new page of the report. The number from the Item Warehouse (ITEMWHD) file and the name from the Sales Representative (SLMD) file.
ITEM NUMBER
This is the item number from the ITEMWHD file.
DESCRIPTION
This is the description of the item number from the ITEM file.
OPTIMUM
This is the maximum on hand from the ITEMWHD file.
ON HAND
This is the on hand from the ITEMWHD file.
NEEDS
This is a calculation of the OPTIMUM minus the ONHAND.
BIN LOCAT.
This is the bin location of warehouse one from the ITEM file.
RECVD
This is the line used for inventory personal input.
REC.LOC.
This is the bin location of the item from the ITEMWHD file.
Support Notes
This report is from MT Business Technologies, Inc. Their version of the program is called MANCAR. The report has been changed to have a MANSW set up. For MT Business, set this MANSW to 1 (LINE 55), and for everyone else, leave this at zero.
Rev 15 Changes
The rank number from the Item file has been added to the report. See report sample below.
