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 |
