513 EP Stock Allocation By Customer



This Report works on Report Start and End Dates.

This Report will show you a breakdown of your En Primeur (EP) Stock Allocation By Customer. 




Field Name

Description

Field Limits and Notes

Field Name

Description

Field Limits and Notes

Refresh





Close







Results Section:-

Results Section:-




Field Name

Description

Field Limits and Notes

Field Name

Description

Field Limits and Notes

Account

The Code for the Customer.

This field Cannot be Changed from here.

Account Name

The Name for the Customer.

This field Cannot be Changed from here.

Order No

The Sales Order Reference for the Order.

This field Cannot be Changed from here.

Qty On Order

The Amount of Singles Ordered for this Product on this Order.

This field Cannot be Changed from here.

Campaign

The En Primeur (EP) Campaign of this Order.

This field Cannot be Changed from here.

Product Code

The Code of the Product Outstanding.

This field Cannot be Changed from here.

Product Description

The Description of the Product.

This field Cannot be Changed from here.

Physical Stock

The Quantity in Singles actually in Stock of this Product.

This field Cannot be Changed from here.

Total EP Order Qty

The Quantity in Singles Outstanding in Total on En Primeur (EP) Orders.

This field Cannot be Changed from here.

EP Order Qty Yet To Be Received

The Quantity in Singles of any En Primeur (EP) Orders Not Yet Received.

This field Cannot be Changed from here.

Balance of Stock Available For Sale

The Quantity in Singles of any Stock still Available For Sale.

This field Cannot be Changed from here.

Date Stock Landed

The Date the Stock was Landed.

This field Cannot be Changed from here.

Warehouse Name

The Name of the Warehouse where the Stock is held.

This field Cannot be Changed from here.

Warehouse Code

The Code of the Warehouse where the Stock is held.

This field Cannot be Changed from here.

Sales Price Per Unit

The Sales Price Per Unit.

This field Cannot be Changed from here.

Purchase Price Per Unit

The Purchase Price Per Unit.

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. 



Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.