ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> GL-O Out of Balance Report empty
http://www.istechforum.com/YaBB.pl?num=1281369604

Message started by MBG on 08/09/10 at 09:00:03

Title: GL-O Out of Balance Report empty
Post by MBG on 08/09/10 at 09:00:03

GL-O tells me that "The last 324 transactions are causing the file to be out of balance..." I click "No", then click the Out of Bal Report button at the batch selection screen (the RP credits are $1,300 and change over the debits on this screen). The problem is the GL Out of Balance Report shows no detail, only the report title, date range and column headings.

Paul

Title: Re: GL-O Out of Balance Report empty
Post by Lynn_Pantic on 08/09/10 at 09:27:15

Try just printing the RP Batch and see if you can identify the problem.

Title: Re: GL-O Out of Balance Report empty
Post by MBG on 08/09/10 at 09:30:51

That did it. Thanks, Lynn.

Title: Re: GL-O Out of Balance Report empty
Post by MBG on 08/09/10 at 11:07:01

This out of balance condition was caused by an invoice which should have had six debits and one credit. Only one debit showed up in the batch. In trying to correct the batch, I somehow created two additional batches, so I ended up with three out of balance batches. Using F4 in GL-P, I deleted ALL the debits, leaving only the credit.
Here's the out of balance report as it looks right now:
08/09/10 11:22 AM GL OUT OF BALANCE REPORT

From Date: 00/00/00 Thru Date: 00/00/00

Trans Dt Cus/Vnd Cd Invoice # Description T GL Account Dept G/L Description Debit Amount Credit Amount
-------- ---------- ---------- ------------------------- -- ---------- ---- ------------------------- ------------- -------------
06/30/10 HEATON #26229 RP 2110 3793.49
Net Transaction: 0.00 3793.49

The odd thing is that after this invoice was entered into AP-C, it was selected for payment and paid.

I think I can blow away the remaining credit in GL-P and just enter the invoice again from scratch in AP-C. I may end up with another open payable invoice, but I'll print a check to get it out of payables and then write a GL entry to fix Cash and Accounts Payable.

Any other suggestions?

Paul

Title: Re: GL-O Out of Balance Report empty
Post by Lynn_Pantic on 08/09/10 at 11:56:21

You could create the debits using GL-P and so long as they have the same date and journal type as the credit, you will be able to post even if the Out of Balance Report doesn't group them together.