But there are several problems:
- This only shows income from sales invoices.
- Amounts are tax inclusive, whereas amounts in the built-in Profit and Loss Statement report that I’m cross-checking against are tax exclusive.
Some background: We are allowed to trade in ZWL and USD. Profit and loss are calculated in our base currency (ZWL), but taxes are to be paid in both currencies according to the proportion of income generated from each. So, I have the built-in Profit and Loss Statement report that I can use for the assessment of profit and loss, but this doesn’t show the currency break-down, which is where this custom report comes in.
You can see in my report definition above I have included both
Amount. This allows me to see the amount in the currency of the transaction, and also the base currency equivalent amount.
So, attempting to solve problem number 1 above I tried:
SalesInvoiceAsTransactionand replacing it with
Payment or Receipt
is empty(after seeing payments and receipts appearing). This then means that credit notes and journal entries are included. But it’s still not a complete picture of income, and the totals don’t match the sum of Inventory - sales and Sales from the built-in Profit and Loss Statement report.
- using Where …
General Ledger Account
is checkedand multiple exclusions to try to get rid of anything that isn’t income.
But this shows everything in ZWL, with no USD amounts, and the total doesn’t match the income total in the Profit and Loss Statement report.
Attempting to solve problem number 2 above, I tried adding various tax-related fields to see if I could get the amounts exclusive of tax:
But in the resulting report, the
Tax Amount, and
TaxComponent columns are empty, and the
TaxExclusiveSalesAmount column shows the total tax-inclusive amount for the transactions (with a minus sign in front).
So, I’m very confused, and would welcome any guidance towards creating the report I want, if it’s possible.