The Product Audit Report provides detailed information about changes that have occurred against products for a specified date range.

Video Demonstration


Step by Step Instructions

From Stock Manager:

1. Click the Reports menu, click 2. Product Reports and select 5. Product Audit Report.

Tip: The Product Audit Report can also be accessed from Product Maintenance.

The Product Audit Report window is displayed.

2. Make the required selections:

a. In the Starting Date, enter the date required to be reported on. 

b. In the Ending Date, enter the date required to be reported on.

c. Select one or more of the following Report Options: 

  • Changes
  • Merges
  • Discontinued
  • Additions
  • Deletions
  • Fixed Price Changes
  • 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 Product 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.

d. Select one or more of the following Reasons for quantity change:

  • Bonus
  • Expired
  • Dead Stock
  • Lost Stock
  • Theft
  • Count Adjustment
  • Other
  • Util (Change in SOH made during a utility e.g. changing the broken pack SOH configuration)

3. Click OK to run the report.

The Product Audit Report is displayed.

Report Columns

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

Column

Detail

Date 

Date 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.

MP QtyThe multi-pack quantity for a drug where the Change Type is Fixed Price.

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.