Reports Menu -> Inventory -> Inventory Value Reports -> Rental Inventory Value Report
This program can be used to generate the inventory value report
for rental items.
The report can sort the rental inventory by Product Class Number
and within each Product Class the products are listed in product
number order, or the rental inventory can just be sorted by product
number regardless of class.
A summary by Class can also be generated without printing all the
product details.
Note: Any Rental items not flagged as Inventory in Rental Inventory will be omitted.
This report lists the current inventory value, unless the option to Print By Date is selected.
This Date option reconstructs the value based on the
Inventory quantity as of the selected date, by using the
Inventory Adjustment records, Additions, Acquisition Date,
Warehouse Receipts, Depreciation, and the Detailed Revenue History
(Sales History INSH).
The total value in a Print By Date report will not
necessarily be accurate because the calculation always uses the
current average cost in the product file, and the average
cost has possibly been changed since this date, as it is updated
each time a product is purchased and receipted.
Note: For bulk items, all serial numbers from the Asset tags are
listed, but only the most recent Acquisition Date is printed.
Costs for Bulk items are not date adjusted.
The prompts to generate the report are:
Leave this field blank to include all rental classes, or enter the desired starting Product Class for the reporting range, or select one from the Product Class Search window.
Note: When balancing the Inventory Value from this report to the General Ledger, use the Product Class filter and include all classes that post to the same GL account assigned in the Rental Product Classes for Inventory.
Leave this field blank to include all rental products, or enter the desired starting product for the reporting range, or select one from the Product Search window.
Check this box to include the details for each product in the
selection range, including the Leasing Vendor and the first
License # on the spreadsheet output.
This box is automatically checked with the "Select By" is for
'Product'.
Check this box to calculate the inventory value according to the quantities as of a prior date, and with the current cost.
Note: The utility Inventory Transaction History can be used to run an audit on rental product history.
Uncheck this box in order to select a single location.
This generates reports by location, printing one location at a
time.
Note: The location selection respects the Divisional Restricted Views assigned to the operator.
Check this box to start a new page for each new Product Class
with a sub-total for each Product Class.
If the Excel option was selected for the output, then the
information for each class will be on a separate tab on the
spreadsheet.
Uncheck this box to continue printing all Product Classes together with a sub-total for each Product Class.
Note: Because they do not affect inventory, any received (INWR)
quantities for re-rentals or for services through associated parts
that were ordered using the P.O./Contract link feature, are not
reflected in this report.
Refer to Contract/Purchase Order Link
Overview for details on this processing.
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |