Program Description
This program can be found on the Inventory Reports Stocking and Analysis Reports (INV-4-2-10). The report provides the total inventory value and on hand quantity for items in Warehouse #1. No other warehouses are included. This 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 then item number order. Specific product class numbers or a range of products classes 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. Serial numbers are printed for serial numbered items. Permanently placed machines are not included, but 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 not 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 will only occur 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 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:
Rev 13 Changes
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 file (ITEM).
Results
