I'm happy to pass back this feedback to the required team on your behalf. However, could you provide us with an example of one of the transactions that are appearing in the negative section on that report. This way we can pass on a working example of that situation occurring with the transaction that is causing that situation.
Hi Steven_M
I would love to supply details as requested but there is no specific transactions that make up the negative balances. When I look at an aged receivables reports none of the balances agree to the report at all. The only one that is close (and probably close enough) is the total. I am running more tests but it is difficult on client files where there are many debtors. I do have a feeling it has something to do with customer deposits (which this client has a lot of). Customer deposits has proven problematic in the past. The real problem here, from my understanding, is the API does not give access to Accounts Receivable balances like we see in the Accounts Receivable Reconciliation Report, they need to be calculated.
If there is no one particular transaction, getting a copy of the Sales Reconciliation report for that specific company business would be what is required for us to raise this with the required team.
