Average Cost Changes Report


Reports Menu -> Inventory -> Average Cost Changes Report

The Cost Change report lists differences in the rental and sales product costs, for a product and date selection range.

The "Detail" report and spreadsheet information is sorted by product number with description and includes date of the cost change, the cause of the change, the quantity at that time, the old and new costs, the Cost Calculation Quantity changes, Tag value changes, and the vendor, or customer, or operator responsible for the change.

The "13 Month" spreadsheet output includes the product number and description with the high and low cost for each of the 13 months, and also the current cost.

Refer to View Average Cost Adjustments for details on the impact of cost changes.
Refer to Cost Calculation Quantity for details on how costs are weighted to provide an accurate average for each sales product.

The prompts are:

FROM PRODUCT#
Leave this field blank to include all products, or enter a starting product for the report range, or select a one from the Inventory Search window.
TO PRODUCT#
Leave this field blank to include all products, or enter an ending product, or select a product from the window.

FROM DATE
When the Detail report type option is selected, accept the default date of the first day of the current month or type in a preferred date start.
This date field is disabled and does not apply when the 13 Month report type option is selected.
TO DATE
When the Detail report type option is selected, accept the default date of the last day of the current month or type in a preferred ending date for the report.
This date field is disabled and does not apply when the 13 Month report type option is selected.

REPORT TYPE
This filter only applies to the spreadsheet output option, as the printed report always generates the Detail output.
For Excel output, select one of the following report formats:
  • Select 13 Month to return the high and low costs over a 13 month period ending as of the month defined in the To Month field below.
  • Select Detail to return the cost changes for the period defined in the From/To Dates fields above.
    This option always applies to the Printed report output.

TO MONTH
This field does not apply and is disabled for the Detail report as the From/To Dates fields are used for the reporting period.

For the 13 Month spreadsheet output, enter the year and month in the YYYYMM format, to use as the final date column in the 13 month period.


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.

Topic Keyword: RSCA10
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)