Rental Inventory Value Report

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.

Inventory Value Calculation:

It uses the Average Cost Each from Rental Inventory, multiplied by the Location Quantity to calculate the Total Inventory Value.

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:

UNPOSTED SALES OF RENTALS

To calculate inventory value accurately it is important that any equipment disposals are fully posted and the Fixed Asset Tag information is updated.
A window listing any unposted sales of rental transactions is triggered if there are any currently outstanding disposals, as outlined in Unposted Sales Of Rentals.

SELECT BY

Select one of the following options from the radio group:

• Select 'Product' to select and list all products in a range in product number sequence.
• Select 'Class' to select a range of Rental Product Classes and to list those classes with all products in each class in product number sequence, or to print a summary with just the totals for each Rental Product Class in the range.

FROM PRODUCT CLASS

The class selection fields are only used if the "Select By" is for 'Class'.

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.

TO PRODUCT CLASS

Leave this field blank to include all rental classes, or enter the desired ending Product Class for the range.

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.

FROM PRODUCT #

The product selection fields are only used if the "Select By" is for 'Product'.

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.

TO PRODUCT #

Leave this field blank to include all rental products, or enter the desired ending product for the range.

PRINT PRODUCT DETAIL

Uncheck this box to just print the summary for each Product Class listing the class description and total value.

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'.

PRINT BY DATE

Uncheck this box to print an inventory list using the current costs and current quantities on hand, as stated in Rental Inventory.

Check this box to calculate the inventory value according to the quantities as of a prior date, and with the current cost.

DATE

This field is enabled for the Print By Date option.
Enter the date to use to reconstruct the product quantities, using the Inventory Adjustment records, Additions, Acquisition Date, Warehouse Receipts, Depreciation, and the Detailed Revenue History (Sales History INSH).

Note: The utility Inventory Transaction History can be used to run an audit on rental product history.

ALL LOCATIONS

Check this box to print one total for all locations.
The All Locations option is restricted to only operators with access to ALL divisions as determined by Divisional Restricted Views assigned to the operator.

Uncheck this box in order to select a single location.
This generates reports by location, printing one location at a time.

LOCATION

Enter the specific location for the report or select one from the drop-down list.

Note: The location selection respects the Divisional Restricted Views assigned to the operator.

NEW PAGE PER CLASS

This option is only used if the "Select By" is for 'Class' and the Print Product Detail is checked to print.

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.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click the ACCEPT button to begin printing the report, or CANCEL to abort.

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.