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 Cannot be Changed from here. |
| Doc No | The Document Reference of the Order. | This field Cannot be Changed from here. |
| Order No | The Order Reference of the Order. | This field Cannot be Changed from here. |
| Type of Sale | The Type of Sales Order. | This field Cannot be Changed from here. |
| Customer County Code | The County Code for the Customer. | This field Cannot be Changed from here. |
| Customer Country | The Country for the Customer. | This field Cannot be Changed from here. |
| Cust Analysis Code 1 | The 1st Customer Analysis Code. | This field Cannot be Changed from here. |
| Customer Analysis Name 1 | The Name of the Analysis Code above. | This field Cannot be Changed from here. |
| Cust Analysis Code 2 | The 2nd Customer Analysis Code. | This field Cannot be Changed from here. |
| Customer Analysis Name 2 | The Name of the Analysis Code above. | This field Cannot be Changed from here. |
| Cust Analysis Code 3 | The 3rd Customer Analysis Code. | This field Cannot be Changed from here. |
| Customer Analysis Name 3 | The Name of the Analysis Code above. | This field Cannot be Changed from here. |
| Cust Analysis Code 4 | The 4th Customer Analysis Code. | This field Cannot be Changed from here. |
| Customer Analysis Name 4 | The Name of the Analysis Code above. | This field Cannot be Changed from here. |
| Cust Analysis Code 5 | The 5th Customer Analysis Code. | This field Cannot be Changed from here. |
| Customer Analysis Name 5 | The Name of the Analysis Code above. | This field Cannot be Changed from here. |
| Cust Analysis Code 6 | The 6th Customer Analysis Code. | This field Cannot be Changed from here. |
| Customer Analysis Name 6 | The Name of the Analysis Code above. | This field Cannot be Changed from here. |
| Cust Analysis Code 7 | The 7th Customer Analysis Code. | This field Cannot be Changed from here. |
| Customer Analysis Name 7 | The Name of the Analysis Code above. | This field Cannot be Changed from here. |
| Group Account | The Group Account Code. | This field Cannot be Changed from here. |
| Group Name | The Name of the Group. | This field Cannot be Changed from here. |
| Account No | The Code for the Customer. | This field Cannot be Changed from here. |
| Account Name | The Name of the Customer. | This field Cannot be Changed from here. |
| Supplier | The Code of the Supplier. | This field Cannot be Changed from here. |
| Supplier Name | The Name of the above Supplier. | This field Cannot be Changed from here. |
| Producer | The Code of the Producer. | This field Cannot be Changed from here. |
| Producer Name | The Name of the above Producer. | This field Cannot be Changed from here. |
| Country Code | The Product Country Code. | This field Cannot be Changed from here. |
| Country of Origin | The Country Name. | This field Cannot be Changed from here. |
| Region Code | The Code for the Product Region. | This field Cannot be Changed from here. |
| Region Name | The Name for the above Region. | This field Cannot be Changed from here. |
| EP Campaign | The Campaign if this is an En Primeur (EP) Order. | This field Cannot be Changed from here. |
| Is Duty Paid | If this is a Duty Paid Order. | This field Cannot be Changed from here. |
| Prod Type | The Type of the Product. | This field Cannot be Changed from here. |
| Prod Type Description | The Description of the Product Type. | This field Cannot be Changed from here. |
| Product Group | The Group for the Product. | This field Cannot be Changed from here. |
| Prod Grp Description | The Description of the Product Group. | This field Cannot be Changed from here. |
| Prod Analysis Code 1 | The 1st Product Analysis Code. | This field Cannot be Changed from here. |
| Prod Analysis Name 1 | The Name of the above Analysis Code. | This field Cannot be Changed from here. |
| Prod Analysis Code 2 | The 2nd Product Analysis Code. | This field Cannot be Changed from here. |
| Prod Analysis Name 2 | The Name of the above Analysis Code. | This field Cannot be Changed from here. |
| Prod Analysis Code 3 | The 3rd Product Analysis Code. | This field Cannot be Changed from here. |
| Prod Analysis Name 3 | The Name of the above Analysis Code. | This field Cannot be Changed from here. |
| Promotion | The Promotion for this Order if there was one. | This field Cannot be Changed from here. |
| Location | The Location of the Stock. | This field Cannot be Changed from here. |
| Product Code | The Code for the Product. | This field Cannot be Changed from here. |
| Product Description | The Description of the above Product. | This field Cannot be Changed from here. |
| Vintage | The Vintage of the above Product. | This field Cannot be Changed from here. |
| Singles | The Number of Singles on the Order. | This field Cannot be Changed from here. |
| Actual Cases | The Number of Actual Cases on the Order. | This field Cannot be Changed from here. |
| Cases | The Number of Cases on the Order. | This field Cannot be Changed from here. |
| @xlitres | The Litreage Total on the Order. | This field Cannot be Changed from here. |
| Sales Value | The Value of the Order. | This field Cannot be Changed from here. |
| Cost Value | The Cost Value of the Order. | This field Cannot be Changed from here. |
| Duty | The Duty Cost for the Order. | This field Cannot be Changed from here. |
| CCT | The CCT Cost for the Order. | This field Cannot be Changed from here. |
| Rent | The Cost of the Rent. | This field Cannot be Changed from here. |
| RH&D | The RH&D Costs. | This field Cannot be Changed from here. |
| Shipping | The Freight and Insurance Costs. | This field Cannot be Changed from here. |
| Delivery | Any Delivery Costs. | This field Cannot be Changed from here. |
| Rep Group | The Sales Rep Group. | This field Cannot be Changed from here. |
| Division | The Division. | This field Cannot be Changed from here. |
| Outlet Code | The Code for the Outlet. | This field Cannot be Changed from here. |
| Outlet Name | The Name for the above Outlet. | This field Cannot be Changed from here. |
| Outlet Group | The Group Code for the Outlet. | This field Cannot be Changed from here. |
| Total Cost | The Total of all Costs. | This field Cannot be Changed from here. |
| Margin | The Margin on this Order. | This field Cannot be Changed from here. |
| GP% | The GP Percentage %. | 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 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