...
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Trans Date | The Date of the Transaction. | This field is Read Only and Cannot be Modified Changed from here. |
| Inv No | The Invoice Number. | This field is Read Only and Cannot be Modified Changed from here. |
| Order No | The Order Reference. | This field is Read Only and Cannot be Modified Changed from here. |
| Rep Name | The Name of the Sales Rep. | This field is Read Only and Cannot be Modified Changed from here. |
| Account No | The Code for the Account. | This field is Read Only and Cannot be Modified Changed from here. |
| Account Name | The Name of the Account. | This field is Read Only and Cannot be Modified Changed from here. |
| Location | The Location of the Stock. | This field is Read Only and Cannot be Modified Changed from here. |
| Product Code | The Code for the Product. | This field is Read Only and Cannot be Modified Changed from here. |
| Product Description | The Description of the above Product. | This field is Read Only and Cannot be Modified Changed from here. |
| Cases | The Quantity of Cases. | This field is Read Only and Cannot be Modified Changed from here. |
| @x Litres | The Quantity of Litres. | This field is Read Only and Cannot be Modified Changed from here. |
| Sales Value | The Value of the Sales. | This field is Read Only and Cannot be Modified Changed from here. |
| Cost Value | The Cost Value. | This field is Read Only and Cannot be Modified Changed from here. |
| Duty | The Duty Cost. | This field is Read Only and Cannot be Modified Changed from here. |
| CCT | The CCT Cost. | This field is Read Only and Cannot be Modified Changed from here. |
| RH&D | The RH&D Cost. | This field is Read Only and Cannot be Modified Changed from here. |
| Rent | The Rent Cost. | This field is Read Only and Cannot be Modified Changed from here. |
| Shipping | The Shipping Cost. | This field is Read Only and Cannot be Modified Changed from here. |
| Total Cost | The Total Cost. | This field is Read Only and Cannot be Modified Changed from here. |
| Margin | The Margin. | This field is Read Only and Cannot be Modified Changed from here. |
| Delivery Cost | The Delivery Cost. | This field is Read Only and Cannot be Modified Changed from here. |
| Net Margin | The Net Margin. | This field is Read Only and Cannot be Modified Changed from here. |
| GP% | The GP % Percentage. | This field is Read Only and Cannot be Modified 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.
...