|
ISTech Support Forum
http://www.istechforum.com/YaBB.pl Evo-ERP and DBA Classic >> Accounting >> GL-P duplicates trans after edit 6/13/05 update http://www.istechforum.com/YaBB.pl?num=1119530862 Message started by lmk223a on 06/23/05 at 04:47:42 |
|
Title: GL-P duplicates trans after edit 6/13/05 update Post by lmk223a on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Lynn Pantic on 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? |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by lmk223a on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Lynn Pantic on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by lmk223a on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Lynn Pantic on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by cluniefan on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by stl3370 on 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 |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Laura Oliver on 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 |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Lynn_Pantic on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Laura Oliver on 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? |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Lynn_Pantic on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by kkmfg on 10/10/07 at 05:35:17 You know... PervasiveSQL even supports triggers. ;-) |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by kevind on 10/10/07 at 07:53:14 kkmfg wrote:
Unfortunately, only on Bound Databases (i.e. databases with no Btrieve Access) :'( Let the Btrieve Bashing begin! ;D |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Laura Oliver on 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. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Lynn_Pantic on 10/10/07 at 09:24:33 If the transaction being edited is for AR, AP or Cash, the reversing entries are created. Otherwise, they should not be. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by kkmfg on 10/10/07 at 11:39:45 kevind wrote:
Unfortunately, only on Bound Databases (i.e. databases with no Btrieve Access) :'( Let the Btrieve Bashing begin! ;D[/quote] Oh... I thought that you still could even if you used btrieve. :( Well that sucks. Maybe I should try to get some time to work on my PostgreSQL converter again... But if we *could* use triggers then they could be used to keep the various places in sync so that it auto updates all locations when one changes. If you can't have 2nd form normalization then update triggers are the next best thing. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by lmk223a on 10/11/07 at 07:38:34 Laura Oliver wrote:
We have not yet updated, so cannot confirm problem, but this would be a MAJOR headache for me. GL-P is used for editing dates when backing out Work Order Issues in a prior accounting period, and I do not want to affect the prior period financial statements. If I need to back out a transaction from Sept., I reset Period Close date back to Sept., perform the backout entry, then modify the date for the backout entry to October in GL-P and post the entry to October so not to affect September financials as they relate to Work In Process and Inventory. I also use GL-P to change the General Ledger Account for various transaction types that are hardcoded in the programming. For example, IN-C transactions are hardcoded to Cost of Goods Sold. I do not want them there, so I reclass to Inventory Shrinkage GL. (Yes, I did add this to my wish list in Suggestions for Updates on the Forum). Income accounts are hardcoded based on Customer Code, but sometimes we have various income accounts for the same customer that can appear on one invoice, I.E. General Sales, Machine Programming Sales, Engineering Design Sales. GL-P is instrumental in modifying the GL account for these transactions also. Please fix this bug for us bean counters. |
|
Title: Re: GL-P duplicates trans after edit 6/13/05 updat Post by Lynn_Pantic on 10/11/07 at 18:55:27 It is not a "BUG", it is doing what it does for a reason. If you edit work order transaction dates, no extra transactions are created (I just checked). But if you edit a transaction posting to AR, AP or Cash accounts, the program doesn't edit the existing transaction but instead creates a reversing entry of the original entry and then makes a new entry with the edited information. The net effect is the same and it keeps the business status updated. If you are bypassing this and editing the transactions in Maintain Database, it would explain why the Business Status numbers are incorrect. |
|
ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved. |