Program Description
This program can be found on the Inventory Reports Stocking and Analysis Reports (INV-4-2-11). This report provides total inventory value and on hand quantities for Warehouses 2 through 9999. This is a perpetual inventory report. The quantities and values are always consistent with the time the report is printed. The transaction date has no effect. The items are printed in warehouse, product class, and then item number order. A total inventory value is provided per product class. A total value per warehouse is also included. Specific or range of products classes and warehouses can be entered. Parts only, everything but parts, and all items can be selected. Depending on entries made by the user, non-serialized items are valued either at average or last cost. The actual serial numbers are printed for serial numbered items. No permanently placed machines are ever included. Custody and Rental contract machines are included. The actual Serial File 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. There is an option to include only items with a quantity on hand or all items. This only applies to non-serialized items. Items with a negative quantity on hand and are stock items are included on a report that is run for items with a quantity on hand only. The reason for this is to allow identification of stock items with negative quantities. Unless they are printed, they can not be found and corrected. An option to include non-stock or dead stock items if the quantity on hand is greater than 0 is available. Non-stock or dead stock non-serialized items are never included if the quantity on hand is less than 1. An option to calculate an extended value on items with a negative quantity is also available. The ideal situation is that the ending inventory values on the valuation report match the General Ledger. This only occurs after all entries have been posted to the General Ledger and all Inventory and Billing transactions and adjustments have been made. Often the Inventory Valuation Reports are run with the AR/Billing End Of Month Procedures.
Rev 15 Changes
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:
Results:
Rev 13 Changes
Internal program changes were made to prevent the No Available Records stop at line 7785. The temporary index was created larger.
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 stored in the Item Warehouse file (ITEMWHD).
Results
