The Category Audit Report provides detailed information about changes that have occurred against products on specified date. The Category Audit Report allows you the ability to drill down on one particular product, a range of products or a category of products. Historic changes will be stored for up to 24 months.
Step By Step Instructions
From Stock Manager:
1. Click the Reports menu and select 2. Product Reports.
2. Select 6. Category Audit Report.
The Category Audit Report window is displayed.
3. Make the required selections:
a. Sorted By: Select the category required to be reported on.
b. From and To: Left as the default will generate a report for all categories. This can be altered to one category by using the same category code in the From and To fields.
c. Enter the required Starting Date and Ending Date.
d. Select one or more of the following Report Options:
- Edit Quantity: selecting this option will enable the Reason for quantity change group box. These options show the exact nature of the quantity change
Note: The Category Audit Report will display broken pack SOH as a decimal e.g. 1 whole pack and a broken pack with 25 tablets is displayed as 1.25 or 2.25 dependent on your Broken Pack Decreases SOH configuration setting.
e. Select one or more of the following Reasons for quantity change:
- Dead Stock
- Lost Stock
- Count Adjustment
4. Click Okay to run the report.
The Category Audit Report is displayed.
The Category Audit Report will display following columns related to the event.
|Date of change.
Time of change.
The Minfos Station Id.
User that made the change, e.g. BR1.
The process /operation that made the change, e.g. MNPN update, Disp Upd, Price Manager.
The Minfos National Product Number.
|This detail is only displayed when a Product Audit Report is run.
The SOH of the product at the time the report is run. An item with a broken or part pack is displayed as a decimal e.g. 1.25.
The type of change that was made, e.g. Retail Price, PDE, SOH change.
What the value (e.g. Retail Price) was before it changed.
What the value resulting from the change.