In the second column, I want to show the invoice/receipt # (field TransactionName) but I am unable to select the field without first selecting field Transaction. Is this because TransactionName is a sub field?
I wish to remove the info marked in red and keep the Inv #. Basically, there is no need to show whether the transaction is a Payment or Receipt, mainly because the amount is shown as either purchase or sale in the amounts columns. So the Transaction Name is what’s required.
I also noticed that under Account, the result is showing as GST payable for all items. The result should be as per GST Free list where it prints the account name. I actually wish to add the account code to the name, say for example “6-1295 Social Functions” instead of just “Social Functions”. is this possible? Thank you.
Regarding the GST Payable items, the below is an example where there are GST 10% and GST free items under the same entry.
The GST 10% are being listed as “GST Payable” in the Account column whereas the GST Free are listed correctly as “Social Functions”. Shouldn’t both be listed as “Social Functions”?
You are not understanding how Manager works (or doubled-entry accounting, for that matter). When you apply a tax code to a line item on a transaction form, more than one ledger entry occurs. A payment, for example, will result in three entries: (1) a credit to the bank or cash account, (2) a debit to an expense account, and (3) a debit to the tax liability account. Depending on how your custom report is defined, you could see all three postings in the custom report from a single line item.
I cannot tell what the transaction is you posted the screen shot from, because you did not include the entire screen. It looks like it might be an expense claim. But, if so, your software is out of date and should be updated. Assuming it is an expense claim, you have highlighted a posting to the GST payable account from your first line item and a posting to the Social Functions account from your second line item.
Grouping tends to obscure custom report entries. You should make sure your report is showing what you want before applying grouping. The individual entries are then more obvious.
The GST Free tax code does not post a ledger entry. It is essentially informational on the finished invoice. So no entry shows for that on the custom report.
@lonzu_65 you are trying to access information that comes from more than one transaction form and that is in at least four different accounts. That is, you want a report that shows information that may be in account “Dinner Dance Ticket Sales”, or in “Social Functions”, or in Permits & Licence fees", or in “Social Function Ticket Sales”. However, the Where filter does not have “or” logic: see the guide Create custom reports. To get the report you want you will have to invert the process and eliminate accounts you do not want.
Uncheck Group by, and delete all the lines under the Where filter. Update the report and note all the accounts that you do not want shown. Then add a Where line for each unwanted account. As an example you do not need the GST payable account so add:
and for the other tax code you set the account as GST payable.
