Welcome, Guest. Please Login.
05/28/25 at 15:15:08
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
GL-O Batch posting out of balance (Read 2970 times)
Tammy
Browser
*


I love YaBB 1G -
SP1!

Posts: 25
GL-O Batch posting out of balance
06/13/05 at 04:56:57
 
GL-O  Batch postings.  
 
I did a GJ, went into GL-O to post and it says there was something out of balance, I posted what I could post that was in balance.  My GJ was posted fine.  
 
When I went in to find what was out of balance, for some reason a portion of the GJ that I just posted is there, out of balance.  
 
Is anyone else having problems with the batch postings????
 
Help !!
 
  Tammy
Chem-Pak, Inc.
Back to top
 
 

Thanks,

Tammy
Email   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: GL-O Batch posting out of balance
Reply #1 - 06/13/05 at 06:24:08
 
If you verified that your entire journal entry posted correctly, and what is remaining in GL-O is duplicate unbalanced info, then use GL-P to add to the GJ batch, adding the affected GL accounts with an offsetting debit (or credit) as applicable to zero out the remaining transactions.
 
I have only experienced unbalanced batch transactions when record locks occur; usually it is WO or RP journals when the stockroom is receiving material or issuing material to work orders. I use the above method to correct the GL after our IS tech verifies that all other DBA files were updated properly.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
mtopich
Browser
*


I love YaBB 1G -
SP1!

Posts: 20
Re: GL-O Batch posting out of balance
Reply #2 - 06/15/05 at 10:02:54
 
I have never had this problems until the last couple of weeks. We updated our software to the IS Tech 5/17/05 version and I have since had two occassions where postings to the GL have been out of balance.  Is it possible that the latest update caused a problem in this regard ?
Back to top
 
 
  IP Logged
mtopich
Browser
*


I love YaBB 1G -
SP1!

Posts: 20
Re: GL-O Batch posting out of balance
Reply #3 - 06/15/05 at 10:22:44
 
Following up on my earlier comment, I currently have a balance sheet that is out of balance.   All batches are posted so if I use GL-P to add a transaction to correct the imbalance, I will get an out of balance error on the new batch. I seem to recall there is a utility in SM-UT -A to allow a one-sided entry to the General Ledger.  Is there such a utility ?
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-O Batch posting out of balance
Reply #4 - 06/15/05 at 11:36:07
 
First, make sure your GL Detail transactions are in fact out of balance by looking at a trial balance rather than a balance sheet.  If the trial balance is OK, then you may need to run UT-K-D to recalculate the monthly subtotals and/or look at the formatting of the balance sheet itself and the GL Account setup to be sure all accounts are the correct type and there are no gaps in the from/through ranges.
 
If the detail is also out of balance, the utility you are looking for us EDITGL.  After adding an entry, you will need to run UT-K-D on the affected account.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Tammy
Browser
*


I love YaBB 1G -
SP1!

Posts: 25
Re: GL-O Batch posting out of balance
Reply #5 - 06/16/05 at 05:33:11
 
We just did our update too, Lynn do you think it has something to do with the update??
 
 
It happened again to me this morning.
Back to top
 
 

Thanks,

Tammy
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-O Batch posting out of balance
Reply #6 - 06/16/05 at 12:51:10
 
We haven't changed anything in GL-O in a long time so I don't think it is from the update.  What kind of transactions are off?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
mtopich
Browser
*


I love YaBB 1G -
SP1!

Posts: 20
Re: GL-O Batch posting out of balance
Reply #7 - 06/17/05 at 04:16:26
 
I have checked our trial balance and it is also out of balance. I have had transactions in both May and June that caused out of balance postings.  I have not identified the specific transaction in May but in June the out of balance is an RP type transaction.   I think that when we posted an invoice the RBNI account was debited but the A/P was not credited. For some reason the G/L posting did not detect the out of balance situation allowed the transactions to post.
Back to top
 
 
  IP Logged
mtopich
Browser
*


I love YaBB 1G -
SP1!

Posts: 20
Re: GL-O Batch posting out of balance
Reply #8 - 06/17/05 at 04:35:40
 
I was mistaken on the source of our out of balance.  The transaction that caused the problem in June was a receiving transaction.  The liability in RBNI posted but the posting of material value to inventory did not occur.
Back to top
 
 
  IP Logged
Tammy
Browser
*


I love YaBB 1G -
SP1!

Posts: 25
Re: GL-O Batch posting out of balance
Reply #9 - 06/17/05 at 04:40:26
 
Lynn, I can email you my GJ and my posting that was way out of balance.  It was just a GJ entry.
Back to top
 
 

Thanks,

Tammy
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: GL-O Batch posting out of balance
Reply #10 - 06/17/05 at 06:00:10
 
We recently had an instance where two receipts were processed and posted in (rapid?) order and the entries posted incorrectly to the GL.  The first transaction posted correctly but in the second transaction, the first total ($891) was posted to the RNI account as a credit, and the second correct total was posted to inventory ($32) as a debit.  We had to go edit GL transactions and correct the credit amount to RNI.  I haven't written about this because we have no idea what happened and it had never happened before or since.  One of those DBA bleeps!  We were on the february update at the time.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
dorner
Browser
*


I love YaBB 1G -
SP1!

Posts: 48
Re: GL-O Batch posting out of balance
Reply #11 - 06/20/05 at 05:18:31
 
We just updated to the 5/17/05 version and on our first post on this version we have a GL-O Out of Balance message. We are out of balance $701.00.  I have been able to isolate the error.    The sales portion of an invoice is duplicated.  Here is what it looks like:
 
Cr - Sales                                     701.00
Dr - Cost of goods Sold    896.04
Cr - Inventory                               896.04
Dr - Accounts Rec              701.00
Cr - Sales                                      701.00
 
Yes, we lost money on this order but that is another story.   The sales part of the transaction seems to have post twice.  Anyone have any idea how to fix this?
 
Mike
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-O Batch posting out of balance
Reply #12 - 06/20/05 at 05:41:36
 
Use GL-P and delete the extra transaction so you can post.  Do a lookup, find the transaction, pull it into the entry screen, then F4 to post it.
 
Were there any error messages or anything unusual about the posting of the invoice in question?  If there were a fundamental program bug, then every invoice posting would have this problem and that is obviously not the case.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
dorner
Browser
*


I love YaBB 1G -
SP1!

Posts: 48
Re: GL-O Batch posting out of balance
Reply #13 - 06/20/05 at 08:34:14
 
The person posting said she did get the "A record was not found in FILELOC for the file ISARCHG.B-2... " error message when she posted the invoices she just printed but after clicking OK DBA let her continue on so she thought everything was fine.  That is the only thing she remembers that was out of the ordinary.
 
Mike
Back to top
 
 
  IP Logged
mtopich
Browser
*


I love YaBB 1G -
SP1!

Posts: 20
Re: GL-O Batch posting out of balance
Reply #14 - 06/27/05 at 04:16:54
 
I have correct our out of balance by running the EDITGL utility and now must run UT-K-D recaldulate chart of accounts. If possible I would like to recalculate from our 2005 starting balances. Is there a way to start at 12/31/04 ?
Back to top
 
 
  IP Logged
Pages: 1 2 
Send Topic Print