Program Description
This program can be found on the Inventory Reports Stocking and Analysis menu (INV-4-2-12). The report provides a total inventory value for all warehouses 1 through 9999. By offering the ability to print warehouse 1 and all other warehouses in one report, it replaces combining the report calculations of Inventory Valuation WH 1 and Inventory Valuation 2-N to get a total inventory value per product class. Note: The Inventory Valuation Wh1-N does not provide a total warehouse inventory total unless only one warehouse is selected.
The report is a perpetual inventory report. The quantities and values are always what they are at the time the report is printed. The transaction date has no effect. The items are printed in product class order. Within each product class, the items are printed in item number order. A total inventory value is provided per item and product class. A total value per warehouse is also included. There is a detail and summary version. A specific or range of products classes and warehouses can be entered. Parts only, everything but parts, and all items can be selected. Depending upon the input, non-serialized items are valued either at average or last cost.
The actual serial numbers are printed for serial numbered items. Permanently placed machines are not included, whereas, custody and rental contract machines are included. The actual Serial File (SERIALD) cost is used to calculate the value. Average and last are not used for serial numbered items. If a serial numbered item has serial numbers in inventory, the item is included on the report, regardless of the quantity on hand or non-stock indicator.
Rev 15 Changes
When run in detail for an invalid Product Class range, the report would print the next valid Product Class in the report heading. This has been corrected. Also, the heading will now display the range of Product Class range entered by the operator.
Rev 14 Changes
In Revision 13, two prompts were added to this report. They were the ability to print non-stock items with a quantity on hand and the ability to print dead-stock items with a quantity on hand. If these questions were answered Y for yes, these type of items would only print if the on hand quantity was greater than zero. There is now the ability to print these type of items if the on hand is not equal to zero. This means that if there is a negative on hand quantity, they can be included on the report. The prompts were changed from a Yes/No prompt to the following choices:
1 print non-stock and dead-stock items with a quantity on hand greater than zero
2 print non-stock and dead-stock items with a quantity on hand not equal to zero or
3 not print non-stock or dead-stock items
Example:
Rev 13 Changes
Internal program changes were made to prevent the Arithmetic stop at line 1255. The report total needed quad math to handle large numbers.
Prior to Revision 13, the report had the prompt Include Non-Stock Items With Quantity On Hand (Y/N). If this prompt was set to Y, the report included items that had a non-stock indicator equal to Y (for non-stock) or D (for dead stock) if the item had an on-hand quantity greater than 0. This has been changed to only work for non-stock items. An additional prompt has been added: Include Dead Stock Items With Quantity On Hand (Y/N). If this new prompt is set to Y, an item set to D for dead stock will print as long as there is a quantity on hand. The non-stock indicator is either from the Item File (ITEM) if the warehouse is equal to 1, or the Item Warehouse File (ITEMWHD) if the warehouse is not equal to 1.
