307 Stock Audit Trail

This Report works on both Start and End Dates, so please ensure you have set the Dates correctly under set Report Dates. 

This Report will show you Stock Movements of your Products/Rotations between the Dates set in Report Dates.

NB This report can only be run for one Product Code at a time. When you select the Report, a message, requesting that you enter a Product Code, will appear. Click on OK.

Open

As shown in the screenshot above, click on the Filter button in the top right hand corner; enter a Product Code in the box and click on Apply.

If there have multiple Movements on a Rotation within the Period you will see multiple records for the Product/Rotation. 

Refresh

Close

Warehouse

The Warehouse for the Stock.

This field Cannot be Changed from here.

Group Code

The Code for the Group the Product belongs to.

This field Cannot be Changed from here.

Product Group

The Description of the Group the Product belongs to.

This field Cannot be Changed from here.

Product Code

The Code for the Product.

This field Cannot be Changed from here.

Description

The Product Description.

This field Cannot be Changed from here.

Singles per Unit

The Number of Singles in a Case.

This field Cannot be Changed from here.

Rotation

The Rotation Number.

This field Cannot be Changed from here.

Opening Stock

The Amount of Stock at the Beginning of the Report Period.

This field Cannot be Changed from here.

Closing Balance

The Amount of Stock at the End of the Report Period.

This field Cannot be Changed from here.

Case Price

The Stock Product Cost.

This field Cannot be Changed from here.

Movement Type

The Type of Movement that has been Processed on this Stock.

This field Cannot be Changed from here.

Movement Date

The Date of the Movement.

This field Cannot be Changed from here.

Account

The Customer Code associated with the Movement.

This field Cannot be Changed from here.

Reference

The Invoice Number if an Invoice has been produced.

This field Cannot be Changed from here.

Order No

The Order Reference related to the Movement.

This field Cannot be Changed from here.

Total Singles

The Number of Singles Moved - a negative figure shows Movements Out.

This field Cannot be Changed from here.

Product Cost

Depending on the Movement Type, this will either show the Stock Product Cost, or the Stock Product Cost, plus any other Cost.

This field Cannot be Changed from here.

Insurance Cost

Any Insurance Cost associated with the Stock Movement.

This field Cannot be Changed from here.

Freight Cost

Any Freight Cost associated with the Stock Movement.

This field Cannot be Changed from here.

Excise Duty

Any Excise Duty associated with the Stock Movement.

This field Cannot be Changed from here.

Customs Duty

Any Customs Duty associated with the Stock Movement.

This field Cannot be Changed from here.

RH&D

Any Receipt, Handling and Despatch Costs associated with the Stock Movement.

This field Cannot be Changed from here.

Rent

Any Rent Charge for the Stock.

This field Cannot be Changed from here.

Delivery

Any Delivery Costs.

This field Cannot be Changed from here.

Is Consignment Stock

Whether this was Consignment Stock.

This field Cannot be Changed from here.

Once the results of the Report are retrieved you can filter on 1 or multiple fields to only show some records as per any search criteria you enter.

• Once you have the records on screen that you wish to see, you can if required extract the information in an XML , CSV or PDF format by clicking on the buttons at the bottom of the screen which will email the results. 

• Click the button to refresh the report and make sure you are looking at the latest date