Dear @lubos, the actual implementation of Custom Report doesn’t permit to confront Accrual Basis numbers Vs Cash Basis numbers since the Basis is set at the head of the report.
How about moving it at line level in order to give the flexibility to confront this kind of data in the same report?
Just the first example it comes to my mind. I create a list of invoices grouped by customers and other custom fields. I would like to show the amount of the invoices on accrual basis (the standard I have to use for my accounting) with an additional column of the paid amount (amount on cash basis).
Well, this information is contained within accrual-basis general ledger but this would require pivoting.
Basically, you want Amount posted to accounts receivable be pivoted by whether it was posted by Sales Invoice transaction or not. If it was posted by sales invoice transaction, then it’s invoice total. If it wasn’t posted by sales invoice transaction, then it’s a payment against the invoice.
I don’t need them as two different columns. They can also be in different lines so it’s not a matter of Pivoting. The problem is the level at which we can select if it is accrural or cash basis. Now it is at report level. It should be at line level.
It will look kind of ugly but the idea is that general ledger transactions posted to accounts receivable are grouped by sales invoice and then by SalesInvoiceAsTransaction
They both contain sales invoice object but SalesInvoiceAsTransaction will be empty if the transaction is not sales invoice. For example, receipt transaction can credit sales invoice so Sales Invoice will not be empty but SalesInvoiceAsTransaction will be empty because receipt is not sales invoice. It’s not very intuitive so this will likely change.