Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


This Report works on the Report End Date you have set.

Image Removed
Image Added

 


This is a Report of your Stock and any Movements on it, up to the Date you have set for Report End Date.

If there have been multiple Movements for a Product, within the Period, you will see multiple records for the same Product.


Results Section:-

Image Removed
Image Added


Field Name

Description

Field Limits and Notes

Warehouse

The Warehouse for the Stock.

This field Cannot be Changed from here.

Group Code

The Product Group Code.

This field Cannot be Changed from here.

Product Group

The Product Group Description.

This field Cannot be Changed from here.

Product

The Code for the Product.

This field Cannot be Changed from here.

Description

The Product Description.

This field Cannot be Changed from here.

Bottles/Case

The Number of Bottles in a Case.

This field Cannot be Changed from here.

Rotation

The Rotation Number for the Stock.

This field Cannot be Changed from here.

Opening Stock

The Amount of Stock Landed on the Product/Rotation.

This field Cannot be Changed from here.

Closing Balance

The Amount of Stock Held at the Report End Date.

This field Cannot be Changed from here.

Case Price

The Price Per Case for the Stock.

This field Cannot be Changed from here.

Movement Type

The Type of Movement if any against this Stock.

This field Cannot be Changed from here.

Movement Date

The Date of any Movement of the Stock.

This field Cannot be Changed from here.

Account

The Customer Code against any of the Stock Movement.

This field Cannot be Changed from here.

Reference

The Invoice Number if one has been generated.

This field Cannot be Changed from here.

OrderNo

The Order Reference is the Stock Movement is in relation to an Order.

This field Cannot be Changed from here.

Total Singles

The Total converted Singles Moved.

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

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.

Rotation Notes

Any 

Rotation Notes 

Rotation Notes will be displayed here

This field Cannot be Changed from here.

Rotation Warehouse Notes

Any Rotation Notes added by the Warehouse will be displayed here.

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 Image ModifiedCSV Image Modifiedor PDF Image Modifiedformat by clicking on the buttons at the bottom of the screen which will email the results. 

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