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.

Video Demonstration

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: 

  • Additions
  • Changes
  • Merges
  • Discontinued
  • 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:

  • Bonus
  • Expired
  • Dead Stock
  • Lost Stock
  • Theft
  • Count Adjustment
  • Other 

4. Click Okay to run the report.

The Category Audit Report is displayed.

Report Columns

The Category Audit Report will display following columns related to the event.

Column

Detail

DateDate of change.

Time

Time of change.

Id 

The Minfos Station Id.

User

User that made the change, e.g. BR1.

Source

The process /operation that made the change, e.g. MNPN update, Disp Upd, Price Manager.

MNPN

The Minfos National Product Number.

Prod no.

Product Number.

Description

Product Description.

MPThis detail is only displayed when a Product Audit Report is run.

SOH

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.

Change Type

The type of change that was made, e.g. Retail Price, PDE, SOH change.

Previous Details

What the value (e.g. Retail Price) was before it changed.

Changed Details

What the value resulting from the change.