Welcome, Guest. Please Login.
05/13/25 at 09:22:51
News:
Home Help Search Login


Pages: 1
Send Topic Print
Edit GL Batches ISTS 06/13/05 (Read 912 times)
deburr
Senior Member
****




Posts: 487
Gender: male
Edit GL Batches ISTS 06/13/05
03/17/06 at 06:32:11
 
I have a future date GL batch that I am trying to delete using Edit GL Batches. It is behaving very badly!! It is toggling between deleting and creating entries when I get to the last entry to delete. Very weird. I have gone from starting with the two entries that need deleting to 8 new ones and back down to one again. Can never get rid of the last one. Same thing happens on different work stations, and classic or evo.
 
Running update 01/12/06
on XP work stations
 
Thanks
 
Steve
Back to top
 
 

Thanks,

Steve Cyr
Deburring House Inc.
EVOERP
Version 2018.2
PSQL 12

Email   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Edit GL Batches ISTS 06/13/05
Reply #1 - 03/17/06 at 07:16:38
 
If it were just a bad date why not just edit the date. If you wanted to get rid of it all together you could just enter e reversing entry with the same date, this would also have an audit trail.  
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: Edit GL Batches ISTS 06/13/05
Reply #2 - 03/17/06 at 07:40:32
 
It is difficult to edit a date using edit gl batches.  The best way I have found is to use maintain database and edit the dates directly in BKGLTEMP (not sure of file name).
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Edit GL Batches ISTS 06/13/05
Reply #3 - 03/17/06 at 08:06:34
 
The behavior in GL-P is there for a reason.  It is creating its own reversing entries to maintain the integrity of the Business Status screen (GL-R).  It only does that for postings to accounts such as AP, AR and Cash that are used by the Business Status and you really shouldn't be editing them in GL-P anyhow because the underlying subledger reports will be off.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
deburr
Senior Member
****




Posts: 487
Gender: male
Re: Edit GL Batches ISTS 06/13/05
Reply #4 - 03/20/06 at 10:34:51
 
Lynn,
 
The first thing I did was to create reversing entries so the underlying subledger balances would be correct. Then I did a new transaction with a correct date so it would post when posting gl batches. Then I hoped to delete the offsetting transactions that will not post for another 9 months just to get rid of them. At one time this could be done, but appearently this is no longer the case. I suppose I must put those items that did delete back in the BKGLTEMP file?
Back to top
 
 

Thanks,

Steve Cyr
Deburring House Inc.
EVOERP
Version 2018.2
PSQL 12

Email   IP Logged
deburr
Senior Member
****




Posts: 487
Gender: male
Re: Edit GL Batches ISTS 06/13/05
Reply #5 - 03/20/06 at 11:50:24
 
Lynn,
 
So I can fix what I did, I need to understand a few things. In the Enter General Journal Transactions program, the "problem" future transaction was a cash disbursements type. Although it will not post to the GL, it did show up in the checking accounts reconciliation. Where else would it show up that may have an effect on my problem? I have a record of the records I did delete in the edit GL batches program. Can I and should I put those back through that program or some other way?
 
Thanks,
Steve
Back to top
 
 

Thanks,

Steve Cyr
Deburring House Inc.
EVOERP
Version 2018.2
PSQL 12

Email   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Edit GL Batches ISTS 06/13/05
Reply #6 - 03/20/06 at 12:08:09
 
If you deleted them, you will need to enter them again to get your cash and expense entries to the GL. You will need to use MDB to clear the reconcile entry. BKGLCHK BKGL_CHK_FLG and put a Y or delete the record. I don't think any other files would be affected.
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
deburr
Senior Member
****




Posts: 487
Gender: male
Re: Edit GL Batches ISTS 06/13/05
Reply #7 - 03/22/06 at 09:12:55
 
Thanks John.
 
Steve
Back to top
 
 

Thanks,

Steve Cyr
Deburring House Inc.
EVOERP
Version 2018.2
PSQL 12

Email   IP Logged
Pages: 1
Send Topic Print