This Report uses the Start Date as set in Report Dates.
This Report provides information on the Detailed Margin for each Invoice within Vision Commerce.
The Transaction Date in these Reports is the Invoice or Movement Date - the Date the Transaction actually occurs.
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Refresh | ||
| Close |
Results Section:-
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Trans Date | The Date of the Transaction | This field is Read Only and Cannot be Modified from here |
| Inv No | The Invoice Number | This field is Read Only and Cannot be Modified from here |
| Order No | The Order Reference | 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 |
| Account No | The Code for the Account | 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 |
| 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 |
| Cases | The Quantity of Cases | This field is Read Only and Cannot be Modified from here |
| @x Litres | The Quantity of Litres | This field is Read Only and Cannot be Modified from here |
| Sales Value | The Value of the Sales | 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 |
| Delivery Cost | The Delivery Cost | This field is Read Only and Cannot be Modified from here |
| Net Margin | The Net 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
, CSV
or PDF 
format by clicking on the buttons at the bottom of the screen which will email the results.