Welcome, Guest. Please Login.
05/19/24 at 07:29:27
News:
Home Help Search Login


Pages: 1
Send Topic Print
Consolidating GL DEtail (Read 674 times)
cathyh
Active Member
*****


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

Posts: 1213
Gender: female
Consolidating GL DEtail
01/17/04 at 13:43:08
 
I am consolidating GL detail for WO transactions and am wondering if I need to reindex files afterwards and if I do which ones.  Does anyone have a procedure in place to consolidate GL transactions (which types do you consolidate?) periodically (what is your Period?) that they will share with me?  We have been using DBA actively since June 2002 and I am just starting to consolidate.  Thanks!  Smiley
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Consolidating GL DEtail
Reply #1 - 01/18/04 at 09:14:18
 
Reindexing BKGLTRAN after consolidating will regain the disk space used by the consolidated records.  
 
As for what to consilidate and when, I am sure many people have different opinions - just be aware that once consolidated, the detail is gone and can not be recovered except from a backup.  The consolidation replaces all the detail transactions of each account and date range specified with a single net debit and net credit transaction per month per journal type.
Back to top
 
 

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


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

Posts: 1213
Gender: female
Re: Consolidating GL DEtail
Reply #2 - 01/20/04 at 09:33:19
 
Thanks, Lynn, I will reindex that file.  I am only consolidating WO transactions, mainly labor, because there are so many, and so far I have only done 2002.  I am concerned about the fact that the detail disappears in the GL.  Am I correct in assuming that the WO transactions I am consolidating are detailed in the MFG module and can be reproduced there?
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Consolidating GL DEtail
Reply #3 - 01/20/04 at 10:16:01
 
Yes, the JC-C and other JC Labor and overhead reports still contain the transaction level detail.
Back to top
 
 

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