Program Description
This program can be found on the Inventory Reports Stocking and Analysis Reports menu (INV-4-2-16). It allows the user to create a report that shows the average days a machine is in inventory. When processing the report, the Serial (SERIALD) data file is accessed and written to. This report only includes placed machines. These are machines that are entered in the Machine Placement program found in Contracts Data Entry (CN-1-1) and Service Data Entry (SD-1-8). The report includes item number, serial numbers, machine description, date received, date placed, and days in inventory. An exception report is created for machines with 0 for date received. This exception report includes item number and serial number.
Rev 14 Changes
This report printed machines that are placed at a customer site. An option was added to print machines that are in inventory only, that are placed only, or all machines. A prompt was added “Print Machines In I’nventory Only, P’laced Only, B’oth, Or E’nd”. If I for only machines in inventory is entered, the range of date placed questions will be skipped. When a machine is placed, the days in inventory is calculated by finding the number of days between the date received and the date placed. If the machine is still in inventory, the days in inventory is calculated by finding the number of days between the date received and the transaction date entered from the menu. The customer number field is also blank if the machine is in inventory.
Example:
Results:
Rev 13 Changes
There is now the ability to enter a specific warehouse number, a range of warehouse numbers, or all warehouse numbers in addition to the other input fields. The warehouse number is taken from the Serial file (SERIALD). Users are also able to enter 0 as a warehouse number.
The following fields on this report are described below:
Enter Beginning Item Number, A'll, Or E'nd
Enter a specific item number or beginning range of item numbers. Enter A for all item numbers. Enter E to end out of the program and return to the previous menu.
Enter Ending Item Number
Enter the ending range of item numbers or press return to accept the default item number from the previous field.
Enter Beginning Warehouse Number, A'll, Or E'nd
Enter a specific warehouse number or beginning range of warehouse numbers. Enter A for all warehouse numbers. Enter E to end out of the program and return to the previous menu.
Enter Ending Warehouse Number
Enter the ending range of warehouse numbers or press return to accept the default warehouse number from the previous field.
Enter Beginning Date Received Or A'll
Enter a specific date received or beginning range of dates received. Enter A for all dates received.
Enter Ending Date Received
Enter the ending range of dates received or press return to accept the default date received from the previous field.
Enter Beginning Date Placed Or A'll
Enter a specific date placed or beginning range of dates placed. Enter A for all dates placed.
Enter Ending Date Placed
Enter the ending range of dates placed or press return to accept the default date placed from the previous field.
Enter Item Types Or 'All
Enter the desired item types or enter A for all item types.
Results
The following results are for all item numbers, serial numbers, warehouses, dates, and item types:
Following is an example of the exception report:
