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


Pages: 1 2 
Send Topic Print
GL-P duplicates trans after edit 6/13/05 update (Read 3008 times)
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 #15 - 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.
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 #16 - 10/10/07 at 11:39:45
 
Quote from kevind on 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

 
Oh... I thought that you still could even if you used btrieve. Sad 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.
Back to top
 
 

Collin
K & K Manufacturing, Inc

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


Accountant

Posts: 377
Re: GL-P duplicates trans after edit 6/13/05 updat
Reply #17 - 10/11/07 at 07:38:34
 
Quote from 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.

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.


 
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.
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 #18 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1 2 
Send Topic Print