Rental Inventory Report

Action: RP_RINVLIST

This report prints a list of the rental inventory items. It can display the ID/Serial number of tracked items and the total average cost of the quantities currently designated as rental. It is useful to see the amount of rental inventory entered and to check the accuracy of the data.

This report prints a inventory value. This value is Quantity on Hand * Average Unit cost. This is why it is important to maintain accurate quantity on hand counts and to enter invoice costs as new stock is received. Average unit cost is calculated from the SCW Receive form and displayed on the Inventory Detail form

The report has listing options. The totals will be handled differently depending on the option chosen.

Option 1. All rental inventory The Average Unit Cost (AUC) is listed separately for each serial number. When the AUC is printed for the style/size, it is actually the average of all the AUC's listed for every style/size. Also, the AUC listed on the item type sub-total is the average of all the AUC's for the item type. The Qty shown is the total number of serial numbers listed (since each serial number represents one tracked item)

Option 2. Only tracked items (that have serial numbers) If check 'Print only tracked items & serial #s'. 'Suppress items not available for rental?' must be checked when the criteria 'Print only tracked items & serial #s' is checked for the quantities and value to agree with the quantity reported when the report is run for Option 1 above. The Quantity available for rental used for Option 1 is the total number of serials that are currently available for rental, so if the option is not checked, the report will include serial numbers not available for rental, making the total qty higher.

Criteria

Item Type...Enter the Item Type to limit the report to. Leave blank for all.

Styles... Enter the rental Style codes to limit the report to. Multiple styles may be selected by separating each with a comma.

Status...Enter a rental inventory Status to limit the report to. Leave blank for all.

Limit to items where QOH is more than 0?... This option when checked will only include rental inventory items where the quantity on hand is greater than zero (0).

Print serial # details? (checkbox)...Checked, the report will list rental inventory of tracked Item Types and show individual item info..

Only include items available for rental? (checkbox)...Checked, the report will only list tracked rental inventory that has it's Currently Available? checkbox checked on the inventory rental sizes view serial number form (making it counted in the availability count for that style & size). In other words only showed Tracked inventory marked available to rent.