Program Description
This new program can be found on the Inventory Reports Stocking and Analysis Reports menu (INV-4-2-17). This report prints all machine item numbers that are in stock with all accessories linked to it printing underneath it. An item is considered a machine item number if the Accessory Y/N field in the Item (ITEM) File is set to N and the Spare Part field in the Item file is set to N. The report prompts for ranges of Host Item Numbers (or machine item numbers), Host Serial Numbers, Accessory Item Numbers, Accessory Serial Numbers, Custody Sales Rep/Customer Number, Product Class, Warehouse, and Sales Rep. This report can be sorted by Custody Sales Rep/Customer Number, Sales Rep, or Host Item/Host Serial Number.
There is the option to use the Accessory File (SERACC.DT) to determine accessories or using the Serial file (SERIALD) to determine accessories. Also, there is the option to print the Item Messages associated with the Host Item/Host Serial Number.
All machines that are within ranges specified will print as long as the warehouse field is not equal to 0. If it is 0, that means that it was placed and it will not print on the report. A machine will print even if it does not have accessories attached to it, unless a range of accessory item and accessory serial numbers are entered and the machine does not have an accessory within those ranges.
All of the input criteria except the accessory item and serial number range is related to the host machine and not the accessory. The Serial file is searched for all input criteria except the product class range. The Item file will be searched to determine the product class.
Results
The report will total the Machine Cost and Comm Cost for every machine and print the total. If the report is sorted by C'ustody Sales Rep/Customer Number, there will be a Custody Sales Rep/Customer Number total. If the report is sorted by Sales Rep, there will be a Sales Rep total. There is also a report total. If theAccessory file is used to determine accessories, and the accessory item and serial number do not exist in the Serial file, the warehouse, custody sales rep/customer number, sales rep, machine cost and commission cost will all be blank and the message NOT FOUND IN SERIAL FILE will display next to the accessory. The following results are displayed for the data entered on the input screen above:
The following fields in the results screen are described below:
HOST ITEM #
This is taken from the Serial file (SERIALD).
ACCESSORY ITEM #
This is taken from the Accessory file (SERACC.DT).
HOST ITEM DESCRIPTION
This is taken from the Serial file (SERIALD) if the Serial file option is used to determine accessories.
HOST ITEM DESCRIPTION
This is taken from the Accessory file (SERACC.DT) if the Accessory file option is used to determine accessories. Otherwise, the Serial file is used.
WH
This stands for warehouse. This is taken from the Serial file.
SREP
This stands for Sales Rep. This is taken from the Serial file.
CUSTODY #
This stands for the Custody Sales Rep Number or Customer Number. This is taken from the Serial file.
LAST MTR RDG DATE
The date associated with the highest meter reading is used from the Serial file. This consists of either date placed, date last service call, date last pm call, or date last meter reading from Contracts. This is blank for Accessories.
LAST MTR READING
The highest meter reading is used from the Serial file. This consists of either the Install Meter Reading, Meter Reading Last Service Call, Last PM Meter Reading, or Last Meter Reading from Contracts. This is blank for Accessories.
MACHINE COST
This is taken from the Serial file.
COMM COST
This stands for Commission Cost taken from the Serial file.