Inventory Transaction History

This report augments Rental Inventory Value Report and the Sales Inventory Value Report by using the By Date option, to determine the correct product quantities on hand as of a prior date.

The history report shows in detail how the prior quantity on hand was reconstructed for all locations or for a specific location.
Using Warehouse Receipts, Detailed Revenue History (SOLD) and current Invoices, Manufacturing, and manual inventory adjustments, and Inventory Transfers, all activity is listed by date in order to show the correct starting and ending quantities.

The report lists the Start Quantity, the Transaction Date, Transaction Quantity, End Quantity, Transaction Description, Operator, and any Document # for the transaction.

The prompts include:

PRODUCT TYPE

Select one of the following product types:

• Select Rentals to generate the quantity change audit report for all or selected rental products.
• Select Sales to generate the quantity change audit report for all or selected sales parts.

FROM PRODUCT #

Leave this field blank to include all products, or type in a beginning product number, or select one from the Inventory Search window.

TO PRODUCT #

Leave this field blank to include all products, or type in an ending product number.

CLASS, "ALL" OR "SEL"

This filter respects the selected Product Type above.

• Type ALL to include all products from all rental or sale classes based on the selected Product Type.
• To generate the list for a single Product Class, enter the class or select it from the Product Class Search window.
• Type SEL to select a range of Product Classes to include in the list as outlined in Select Product Class List.

GROUP, "ALL" OR "SEL"

This filter respects the selected Product Type above.

• Type ALL to include all products from all Groups based on the selected Product Type.
• To generate the list for a single Group, enter the group or select it from the Group Search window.
• Type SEL to select a range of Groups to include in the list as outlined in Select Group List.

FROM DATE

Leave this field blank to start at the "beginning of time", or enter a start date to narrow the period of the output.

TO DATE

Accept today's date for the ending date, or enter a preferred ending date for the report.

ALL LOCATIONS

Check this box to print changes for all locations.

Uncheck this box to view the quantity changes at a single location.

LOCATION

Enter the specific location for the report or select one from the drop-down list.
Because this is an audit utility this is not limited to the operator's restricted divisional views.

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.

NEW PAGE PER PRODUCT

Check this box to start a new page for each new product on the Report output.
This prompt does not apply to the Excel output option.

Uncheck this box to continue printing all products without separating by page.

Finished?

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