This Report works on Report Start and End Dates.
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Refresh | ||
| Close |
This Report shows you an overview of your overall Sales in Vision Commerce.
Only Invoices which are posted through to Sage will be included, and therefore zero value Invoices in Vision Commerce will be excluded.
Results Section:-
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Trans Date | The Transaction Date of the Order | This field is Read Only and Cannot be Modified from here |
| Doc No | The Document Reference of the Order | This field is Read Only and Cannot be Modified from here |
| Order No | The Order Reference of the Order | 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 |
| Customer County Code | The County Code for the Customer | This field is Read Only and Cannot be Modified from here |
| Customer Country | The Country for the Customer | This field is Read Only and Cannot be Modified from here |
| Cust Analysis Code 1 | The 1st Customer Analysis Code | This field is Read Only and Cannot be Modified from here |
| Customer Analysis Name 1 | The Name of the Analysis Code above | This field is Read Only and Cannot be Modified from here |
| Cust Analysis Code 2 | The 2nd Customer Analysis Code | This field is Read Only and Cannot be Modified from here |
| Customer Analysis Name 2 | The Name of the Analysis Code above | This field is Read Only and Cannot be Modified from here |
| Cust Analysis Code 3 | The 3rd Customer Analysis Code | This field is Read Only and Cannot be Modified from here |
| Customer Analysis Name 3 | The Name of the Analysis Code above | This field is Read Only and Cannot be Modified from here |
| Cust Analysis Code 4 | The 4th Customer Analysis Code | This field is Read Only and Cannot be Modified from here |
| Customer Analysis Name 4 | The Name of the Analysis Code above | This field is Read Only and Cannot be Modified from here |
| Cust Analysis Code 5 | The 5th Customer Analysis Code | This field is Read Only and Cannot be Modified from here |
| Customer Analysis Name 5 | The Name of the Analysis Code above | This field is Read Only and Cannot be Modified from here |
| Cust Analysis Code 6 | The 6th Customer Analysis Code | This field is Read Only and Cannot be Modified from here |
| Customer Analysis Name 6 | The Name of the Analysis Code above | This field is Read Only and Cannot be Modified from here |
| Cust Analysis Code 7 | The 7th Customer Analysis Code | This field is Read Only and Cannot be Modified from here |
| Customer Analysis Name 7 | The Name of the Analysis Code above | This field is Read Only and Cannot be Modified from here |
| Group Account | The Group Account Code | This field is Read Only and Cannot be Modified from here |
| Group Name | The Name of the Group | This field is Read Only and Cannot be Modified from here |
| Account No | The Code for the Customer | This field is Read Only and Cannot be Modified from here |
| Account Name | The Name of the Customer | This field is Read Only and Cannot be Modified from here |
| Supplier | The Code of the Supplier | This field is Read Only and Cannot be Modified from here |
| Supplier Name | The Name of the above Supplier | This field is Read Only and Cannot be Modified from here |
| Producer | The Code of the Producer | This field is Read Only and Cannot be Modified from here |
| Producer Name | The Name of the above Producer | This field is Read Only and Cannot be Modified from here |
| Country Code | The Product Country Code | This field is Read Only and Cannot be Modified from here |
| Country of Origin | The Country Name | This field is Read Only and Cannot be Modified from here |
| Region Code | The Code for the Product Region | This field is Read Only and Cannot be Modified from here |
| Region Name | The Name for the above Region | This field is Read Only and Cannot be Modified from here |
| EP Campaign | The Campaign if this is an En Primeur (EP) Order | This field is Read Only and Cannot be Modified from here |
| Is Duty Paid | If this is a Duty Paid Order | 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 of 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 of the Product Group | This field is Read Only and Cannot be Modified from here |
| Prod Analysis Code 1 | The 1st Product Analysis Code | This field is Read Only and Cannot be Modified from here |
| Prod Analysis Name 1 | The Name of the above Analysis Code | This field is Read Only and Cannot be Modified from here |
| Prod Analysis Code 2 | The 2nd Product Analysis Code | This field is Read Only and Cannot be Modified from here |
| Prod Analysis Name 2 | The Name of the above Analysis Code | This field is Read Only and Cannot be Modified from here |
| Prod Analysis Code 3 | The 3rd Product Analysis Code | This field is Read Only and Cannot be Modified from here |
| Prod Analysis Name 3 | The Name of the above Analysis Code | This field is Read Only and Cannot be Modified from here |
| Promotion | The Promotion for this Order if there was one | This field is Read Only and Cannot be Modified from here |
| Location | The Location of the Stock | 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 | This field is Read Only and Cannot be Modified from here |
| Vintage | The Vintage of the above Product | This field is Read Only and Cannot be Modified from here |
| Singles | The Number of Singles on the Order | This field is Read Only and Cannot be Modified from here |
| Actual Cases | The Number of Actual Cases on the Order | This field is Read Only and Cannot be Modified from here |
| Cases | The Number of Cases on the Order | This field is Read Only and Cannot be Modified from here |
| @xlitres | The Litreage Total on the Order | This field is Read Only and Cannot be Modified from here |
| Sales Value | The Value of the Order | This field is Read Only and Cannot be Modified from here |
| Cost Value | The Cost Value of the Order | This field is Read Only and Cannot be Modified from here |
| Duty | The Duty Cost for the Order | This field is Read Only and Cannot be Modified from here |
| CCT | The CCT Cost for the Order | This field is Read Only and Cannot be Modified from here |
| Rent | The Cost of the Rent | This field is Read Only and Cannot be Modified from here |
| RH&D | The RH&D Costs | This field is Read Only and Cannot be Modified from here |
| Shipping | The Freight and Insurance Costs | This field is Read Only and Cannot be Modified from here |
| Delivery | Any Delivery Costs | This field is Read Only and Cannot be Modified from here |
| Rep Group | The Sales Rep Group | This field is Read Only and Cannot be Modified from here |
| Division | The Division | 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 for the above Outlet | This field is Read Only and Cannot be Modified from here |
| Outlet Group | The Group Code for the Outlet | This field is Read Only and Cannot be Modified from here |
| Total Cost | The Total of all Costs | This field is Read Only and Cannot be Modified from here |
| Margin | The Margin on this Order | 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 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.
This field is Read Only and Cannot be Modified from here