AR Balance by GL Report - errors in GL reporting

Question

Our system use two GL accounts for incoming payments: 120-Accounts Receivable and 260-Customer Deposits. When I run the AR Balance by GL Account report, some prepayments are reported under the 260 account even though they have posted to our ledger under 120. That means the report doesn’t match our trial balance. Has anyone else experienced this? Is there a cause and is there a correction? Thank you.

An example follows.

The AR Balance by GL Account report, showing the prepayment listed under GL 260:

The AR Register for the highlighted transaction, showing the transaction posted to GL 120:

icon

Best answer by jessicaASA 7 June 2023, 21:48

View original

jessicaASA · Accepted Answer

Hi @bjeter78- We wereable to solve it. The short answer is that payments need to be released before invoices.The cause: during our automated processes where our website orders sync with and import into Acumatica, our digital orders are automatically invoiced. Those invoices were being released before the prepayments were released.The solution: we added an automation schedule for the Release AR Documents action and tied that into our other automations. Here is how the schedules run now:An automated schedule grabs datafrom our website and brings it into the sync.An automated schedule grabs datafrom the sync and brings it into Acumatica.An automated schedule creates invoices for digital orders. The invoices are inBalanced status.An automated schedule for Release AR Documents runs. This releases everything that would normally be on that screen.An automated schedule releases invoices.We added step 4 to our automation schedule and it has worked like a charm!

bjeter78 · Answer

Did you ever find out why this was happening? I have a client with thesame issue.

AR Balance by GL Report - errors in GL reporting

2 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded