Hello I need some assistance with reporting please.
I have setup a custom report to pull sales data for each service engineer using the General Ledger Transactions. The report works fine but delivers the sales amount values including GST.
- Is there a selection in custom reports section that can present the amounts excluding GST ie. not the total amount on each invoice matching the criteria?
I have an account setup under revenue in the chart of accounts called “Billable Time - Invoiced”. This account collects the dollar value data of the engineer’s labour excluding the GST. I would like to access this data in the custom reports.
- Is this possible to query my “Billable Time - Invoiced” account? (because I do not seem to be able to identify it in the Custom Reports).
- Is it possible to query the “Item” code field in sales invoices? (This may also help me deliver an accurate report).