The Stock Average Cost Exception Report helps you to find Stock items that vary from the norm average cost.
Introduction
The Stock Average Cost Exception Report helps you to find Stock items where the cost varies too far from the norm average cost and where margins are looking too high or too low. Examples of why this could occur might be due to stock being priced incorrectly or being bought in at one unit of measure and sold in another, or possible timing issues where stock has been received in but the Supplier invoice has not yet been received or processed.
| NOTE: If you manually change the price of a Stock item, or do a Stock Adjustment, then the price will be added. When doing a stock adjustment you have the option to set a new branch average cost, and the new cost will appear on the history tab. |
Stock Average Cost Exception Report
- Go to Stock > Stock Average Cost Exception Report.
- Month end date: Enter the month-end date you want to report for.
- Branch: Select a Branch, or leave blank to report for all Branches.
- Comparison against: Select either Last Purchase Price or Last Month Branch Average Cost.
- Percent Drop: Optionally, enter a percentage drop to report.
- Percent Increase: Optionally, enter a percentage increase to report.
- Report order: Select either Cost Variance, Cost Percent Variance or On Hand Value Variance.
- Click Save defaults to save your selections.
- Click View report or Export report.
Report
The resulting report shows figures for:
-
- Stock Code Cost Variance.
- Cost Var. %.
- Branch Average Cost Last.
- Purchased.
- Transfer In.
- Powerbase.
- Accounting.
- Qty On Hand.
- On Hand.
- This Mth Last Mth Variance.
- PO Avg. Cost.
- Purchase Order Status.
|