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 Cannot be Changed from here. |
| Inv No | The Invoice Number. | This field Cannot be Changed from here. |
| Order No | The Order Reference. | This field Cannot be Changed from here. |
| Rep Name | The Name of the Sales Rep. | This field Cannot be Changed from here. |
| Account No | The Code for the Account. | This field Cannot be Changed from here. |
| Account Name | The Name of the Account. | 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. |
| Cases | The Quantity of Cases. | This field Cannot be Changed from here. |
| @x Litres | The Quantity of Litres. | This field Cannot be Changed from here. |
| Sales Value | The Value of the Sales. | This field Cannot be Changed from here. |
| Cost Value | The Cost Value. | This field Cannot be Changed from here. |
| Duty | The Duty Cost. | This field Cannot be Changed from here. |
| CCT | The CCT Cost. | This field Cannot be Changed from here. |
| RH&D | The RH&D Cost. | This field Cannot be Changed from here. |
| Rent | The Rent Cost. | This field Cannot be Changed from here. |
| Shipping | The Shipping Cost. | This field Cannot be Changed from here. |
| Total Cost | The Total Cost. | This field Cannot be Changed from here. |
| Margin | The Margin. | This field Cannot be Changed from here. |
| Delivery Cost | The Delivery Cost. | This field Cannot be Changed from here. |
| Net Margin | The Net Margin. | 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 the records on screen that you wish to see, you can if required extract the information in an XML |
