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 |
|---|---|---|
| Refresh | ||
| Close |
Results Section:- |
|---|
|
| 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 |
