Cost Variance Report

Use the Cost Variance Report to analyze the cost variance of items, using standard to average, actual to standard, and actual to average history for the current period costs.

The following calculations are used in the report:

Method	Cost Variance Calculations
LIFO-FIFO	Unit Cost * Quantity on Hand
Standard/Average	Standard Cost * Quantity on Hand - Average Cost * Quantity on Hand
LIFO-FIFO/Standard	(LIFO - FIFO) - (Standard Cost * Quantity on Hand)
LIFO-FIFO/Average	(LIFO - FIFO) - (Average Cost * Quantity on Hand)

 

1. Use the Data Filter to select the range of filtering options or leave the filter blank to include all available data.
2. Determine how to sort the report by selecting a sorting criterion from the Sort By section.
3. Select the Lot Detail check box, if applicable, to include lot detail in the report.
4. Select the Additional Description check box, if applicable, to include the additional description in the report.
5. Select Reporting or Base for the unit of measure from the Unit of Measure field. 

   Select	To
   Reporting	Get the quantities printed on the report in the unit of measure you selected as the reporting unit of measure on the Unit Defaults tab in the Item setup.
   Base	Get the quantities printed on the report in the base unit of measure set up for the items.

6. Click a command button to  

Click	To
Print	Process the report.
Output	Output the report as a PDF.
Send	Save the report as a PDF and attach it to an email using your default mail program.
Preview	View a preview of the report.
Reset	Set all fields to their default values.