Purchase versus Costing Method Report
Use this report to view variances between item unit costs (based on the costing method selected in Inventory Module Control), and actual costs, for receipt and AP invoice transactions.
Header Details
- Report process date and time
- From and To dates, entered in the report parameters
- Page number
Line Details
For items and locations in the selected range, these details display:
- Inventory code
- Description
- Unit of measure
- Location
- Transaction date
- Transaction reference
- Batch number
- Transaction quantity
- Actual unit cost
- Total actual cost
- System unit cost (based on inventory costing method in use)
- Total system cost
- Variance value
- Variance %
One line displays for each transaction for an inventory item.
When the report runs, you can specify a variance amount. Only items that have a cost variance which is greater than or equal to the specified value print on the report.
Grand totals display at the end of the report for total actual cost, total unit cost, and total variance.