Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This Report works on the Report End Date you have set

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 multiple Movementson a Product within the Period you will see multiple records for the same Product.

Results Section:-

Field NameDescriptionField Limits and Notes
WarehouseThe Warehouse for the StockThis field is Read Only and Cannot be Modified from here
Group CodeThe Product Group CodeThis field is Read Only and Cannot be Modified from here
Product GroupThe Product Group DescriptionThis field is Read Only and Cannot be Modified from here
ProductThe Code for the ProductThis field is Read Only and Cannot be Modified from here
DescriptionThe Product DescriptionThis field is Read Only and Cannot be Modified from here
Bottles/CaseThe Number of Bottles in a CaseThis field is Read Only and Cannot be Modified from here
RotationThe Rotation Number for the StockThis field is Read Only and Cannot be Modified from here
Opening StockThe Amount of Stock Landed on the Product/RotationThis field is Read Only and Cannot be Modified from here
Closing BalanceThe Amount of Stock Held at the Report End DateThis field is Read Only and Cannot be Modified from here
Case PriceThe Price Per Case for the StockThis field is Read Only and Cannot be Modified from here
Movement TypeThe Type of Movement if any against this StockThis field is Read Only and Cannot be Modified from here
Movement DateThe Date of any Movement of the StockThis field is Read Only and Cannot be Modified from here
AccountThe Customer Code against any of the Stock MovementThis field is Read Only and Cannot be Modified from here
ReferenceThe Invoice Number if one has been generatedThis field is Read Only and Cannot be Modified from here
OrderNoThe Order Reference is the Stock Movement is in relation to an OrderThis field is Read Only and Cannot be Modified from here
Total SinglesThe Total converted Singles MovedThis field is Read Only and Cannot be Modified from here
Product CostDepending on the Movement Type, this will either show the Stock Product Cost, or the Stock Product Cost, plus any other CostsThis field is Read Only and Cannot be Modified from here
Insurance CostAny Insurance Cost associated with the Stock MovementThis field is Read Only and Cannot be Modified from here
Freight CostAny Freight Cost associated with the Stock MovementThis field is Read Only and Cannot be Modified from here
Excise DutyAny Excise Duty associated with the Stock MovementThis field is Read Only and Cannot be Modified from here
Customs DutyAny Customs Duty associated with the Stock MovementThis field is Read Only and Cannot be Modified from here
RH&DAny Receipt, Handling and Despatch Costs associated with the Stock MovementThis field is Read Only and Cannot be Modified from here
RentAny Rent Charge for the StockThis field is Read Only and Cannot be Modified from here
DeliveryAny Delivery CostsThis field is Read Only and Cannot be Modified from here
Is Consignment Stock?Whether this was Consignment StockThis field is Read Only and Cannot be Modified 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. 

  • No labels