OK gentlemen the thing that has help a lot is the use of “IsAccountsReceivable” I get the GST exclusive result which is great. The last step in the custom report is to suppress the line items and display only the Subtotal. Let me show you using a query on one invoice only, for example invoice 7613.
The Invoice 7613:
The Query:
The report result:
Ideally I would like to achieve a subtotal amount per invoice (Without line items).
The Total GST inclusive amounts can be easily achieved and perfectly with one value per invoice but I am not able to do that for Subtotal in other words the excluding GST amount for each invoice.
I am sure someone has already done this and would appreciate the guidance.
Here is an old request met with a “No” so with the changes in custom reports maybe it has been implemented?