Welcome, Guest. Please Login.
06/04/25 at 19:23:19
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
GL-P duplicates trans after edit 6/13/05 update (Read 3004 times)
lmk223a
Senior Member
****


Accountant

Posts: 377
GL-P duplicates trans after edit 6/13/05 update
06/23/05 at 04:47:42
 
We just updated to 6/13/05 update this morning and found that everytime a transaction is edited in GL-P, EVO duplicates that transaction.
 
For example, I edited the description of an inventory adjustment transaction IN_C in the "OTHER" batch, from "adjustment to stock" to "withdrawn by engineering" to the inventory account 1220.  After I selected "UPDATE" after editing the desription of this transaction, two duplicate records were created, a debit to 1220  and a credit to 1220 that still read "adustment to stock", in addition to the record I edited that reads "withdrawn by engineering."
 
Since I edited four transactions, EVO created 8 additional records. Everytime a transaction is edited, it created a debit and credit record for the same account in the "OTHER" batch.
 
I used F4 to delete these system created duplicate transactions - but would appreciate a "FIX" as soon as possible.
 
PLEASE ADVISE as this is a process I do daily.
 
Back to top
 
 

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


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #1 - 06/23/05 at 05:09:38
 
This was something that was necessary to maintain accurate perpetual balances in GL-R.  Once you get this first batch posted, it will be a rare occurrence.  The extra records are all in balance and are used to maintain the correct perpetual balance in the Business Status program.  The original transaction that updated the Business Status balance needs to be reversed and the corrected entry reposted.
 
In addition, if your item classes and defaults are set up correctly, GL-P shouldn't be a daily process, it should only be needed on rare occasions.  Why do you need to be editing transactions daily?
Back to top
 
 

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


Accountant

Posts: 377
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #2 - 06/23/05 at 05:49:14
 
Since EVO codes all IN-C inventory adjustments to COST OF GOODS SOLD gl account and tags them all with the descripton "adjustment to stock", we have a need to change the gl account number and transaction descriptions when IN_C adjustments are not related to cost of goods sold.  
 
I.E. material withdrawn by engineering is charged to GL for Engineering expense.  Scrapped and not found inventory adjustments are charged to inventory shrinkage GL, not cost of goods sold.  We try to keep the Cost of Goods Sold GL to only reflect the inventory costs related to the inventory items that ship via sales invoices.
Back to top
 
 

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


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #3 - 06/23/05 at 06:05:12
 
You could have better tracking and eliminate the editing if you set up a few Status I (Indirect) work orders pointing to the appropriate GL Accounts and use WO-G and issue materials to those work orders rather than IN-C.
Back to top
 
 

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


Accountant

Posts: 377
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #4 - 06/23/05 at 06:13:46
 
GL-P also duplicates records when the effective date is changed!
 
When backing out work order issued material from a prior accounting period, we use AM-A to reset the calendar date to the date of the transaction which needs to be backed out.  Then EVO will allow the work order issue to be backed.  Then I go to GL-P and EDIT  the transaction date from a previous accounting period to the current accounting period and reset AM-A to the current accounting period.
 
With the 6/13 upate, GL-P shows the transaction for the current accounting period, June, but again has duplicated  transaction records to show the prior period (APRIL) date as well as the current period date.
 
I.E. April 11 - credit 1230 WIP  $100
     April 11 - debit 1230 WIP $100
     April 11  -debit 1220 raw material $100
     April 11 - credit 1220 raw material $100
     June 22 - credit 1230 WIP $100  
     June 22 - debit  1220 raw material $100
 
I now have 6 transactions, instead of just 2.
Back to top
 
 

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


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #5 - 06/23/05 at 06:39:52
 
Let it happen and get this one batch posted.  Once THIS batch is posted, you will never again get the duplication on inventory or Work Order related entries.  In fact if you don't ever click the REFRESH button in GL-R but instead let daily GL-O posting refresh the GL-R balances, then you will never get it again on anything.
 
If you do use the Refresh butotn in GL-R, then if you then need to edit entries hitting AP, AR, or Cash, you may see the duplicates but, as I said, they will always cancel each other out.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cluniefan
Ex Member



Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #6 - 07/11/05 at 12:56:59
 
We used to be able to go into GL-P to fix things that got thrown into the 9999-0 account,  It was a simple fix, where you just had to correct the account number.
 
We currently try to fix it, but it won't keep the fix, it still throws the errors into 9999-0 and won't update.  This is only since the last update.
 
Any answers as to how to get this fixed.  I can't post in the GJ, because it's showing a clearing error in my WO's, but we can't fix them in EVO-ERP or regular classic DBA.
 
Back to top
 
 
  IP Logged
stl3370
Member
**


I love YaBB 1G -
SP1!

Posts: 80
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #7 - 07/12/05 at 05:32:54
 
We have had the same problem.  I've been using maintain database on BKGLTEMP to correct account numbers until the issue is fixed.
 
Sean
Leybold Optics
Back to top
 
 
WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #8 - 10/09/07 at 13:44:31
 
Is anyone else have this problem with the 9/27/07 update.
(see 6/13/2005) update
 
 I try to modify thru GL-P.  
It appears it is working, but nothing happens and the wrong Xactions are duplicated.
 
I have to go to maintain database to fix thru GLTemp
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #9 - 10/09/07 at 14:11:34
 
What exactly are you trying to do?  Certain transactions relating to AR, AP or cash have reversing entries automatically made so that the business status balances are updated.  But you should not generally be editing those transactions in GL-P anyway because the agings and check register will not be updated with the edits.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #10 - 10/09/07 at 14:17:08
 
If an invoice gets a wrong date (usually because someone dated the Packing slip) wrong, then I go to GL-P and change the dates on both sides of the Xactions.
 
But now (since the update)  it appears to change the date, but when I go into GL-O it has not, and has actually created a duplicate Xaction with the wrong date.
 
This is almost exactly what happened with the 2005 update, but it did create a new Xaction, but kept the old Xaction.
 
I am wondering if this could be part of Lynn Kissingers GL-O problem?
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #11 - 10/09/07 at 19:16:17
 
If an invoice date is wrong, changing it in GL-P is NOT a good idea because the Aging, inventory, and various other data do not get changed.  Better to void using the incorrect date and reinvoice using the correct date.
Back to top
 
 

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


Ghost of the code

Posts: 375
Gender: male
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #12 - 10/10/07 at 05:35:17
 
You know... PervasiveSQL even supports triggers. Wink
Back to top
 
 

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #13 - 10/10/07 at 07:53:14
 
Quote from kkmfg on 10/10/07 at 05:35:17:
You know... PervasiveSQL even supports triggers. Wink

 
Unfortunately, only on Bound Databases (i.e. databases with no Btrieve Access)    cry
 
Let the Btrieve Bashing begin!   Grin
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #14 - 10/10/07 at 08:55:31
 
that may be true Lynn,  But I like to use it for other stuff too.  
 
* *  A N D * *   if  Every entry is duplicated  (not justing changing invoice dates)  ...
then what purpose does GL-P serve?  and why did you fix it in the past?
 
So what is GL-P for? ?  ?    and can anyone use it right now, and actually get a modified entry.....can anyone use it right now and not get duplicated entries?
 
I could before this last update.
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1 2 
Send Topic Print