606 Sales Margin



This Report uses the End Date as set in Report Dates.

This Report shows you the Sales Margin for Sales Orders. 



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

Year Start

The Year Start for the Date as set in Report Dates

This field is Read Only and Cannot be Modified from here

Trans Date

The Date of the Transaction

This field is Read Only and Cannot be Modified from here

Type of Sale

The Type of Sales Order

This field is Read Only and Cannot be Modified from here

Is Duty Paid

Whether this is Duty Paid

This field is Read Only and Cannot be Modified from here

Division

The Name of the Division

This field is Read Only and Cannot be Modified from here

Rep Group

The Group of the Sales Rep

This field is Read Only and Cannot be Modified from here

Rep Code

The Code for the Sales Rep

This field is Read Only and Cannot be Modified from here

Rep Name

The Name of the Sales Rep

This field is Read Only and Cannot be Modified from here

Outlet Group

The Group of the Outlet

This field is Read Only and Cannot be Modified from here

Outlet Code

The Code for the Outlet

This field is Read Only and Cannot be Modified from here

Outlet Name

The Name of the Outlet

This field is Read Only and Cannot be Modified from here

Account Name

The Name of the Account

This field is Read Only and Cannot be Modified from here

Supplier Account

The Account Code of the Supplier

This field is Read Only and Cannot be Modified from here

Supplier Name

The Name of the Supplier

This field is Read Only and Cannot be Modified from here

Producer

The Code for the Producer

This field is Read Only and Cannot be Modified from here

Producer Name

The Name of the Producer

This field is Read Only and Cannot be Modified from here

Country code

The Code for the Country

This field is Read Only and Cannot be Modified from here

Country of Origin

The Country of Origin

This field is Read Only and Cannot be Modified from here

Region Code

The Code for the Region

This field is Read Only and Cannot be Modified from here

Region Name

The Name of the above Region Code

This field is Read Only and Cannot be Modified from here

EP Campaign

The Name of the En Primuer (EP) Campaign

This field is Read Only and Cannot be Modified from here

Prod Type

The Type of the Product

This field is Read Only and Cannot be Modified from here

Prod Type Description

The Description for the Product Type

This field is Read Only and Cannot be Modified from here

Product Group

The Group for the Product

This field is Read Only and Cannot be Modified from here

Prod Grp Description

The Description for the above Product Group

This field is Read Only and Cannot be Modified from here

Location

The Location of where the Stock is held

This field is Read Only and Cannot be Modified from here

Product Code

The Code for the Product

This field is Read Only and Cannot be Modified from here

Product Description

The Description of the above Product Code

This field is Read Only and Cannot be Modified from here

Vintage

The Vintage of the Product

This field is Read Only and Cannot be Modified from here

Actual Cases

The Quantity of actual Cases

This field is Read Only and Cannot be Modified from here

Cases

The Quantity of Cases

This field is Read Only and Cannot be Modified from here

@Xlitres

The Quantity of Litres

This field is Read Only and Cannot be Modified from here

Sales Value

The Sales Value

This field is Read Only and Cannot be Modified from here

Cost Value

The Cost Value

This field is Read Only and Cannot be Modified from here

Duty

The Duty Cost

This field is Read Only and Cannot be Modified from here

CCT

The CCT Cost

This field is Read Only and Cannot be Modified from here

RH&D

The RH&D Cost

This field is Read Only and Cannot be Modified from here

Rent

The Rent Cost

This field is Read Only and Cannot be Modified from here

Shipping

The Shipping Cost

This field is Read Only and Cannot be Modified from here

Total Cost

The Total Cost

This field is Read Only and Cannot be Modified from here

Margin

The Margin

This field is Read Only and Cannot be Modified from here

GP%

The GP Percentage %

This 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, CSVor PDFformat 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.