× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hello Wendy

(LX Based) In GXR you can see these fields:

N.CampoKey A/D Descrizione                           P.Inz. Bytes Tp Int Dec 
XREVNT       Transaction Number                           5     8  P  15   0
XRJNEN       Journal Entry Number                        36     9  O
XRJSEQ       Unique Sequence Nbr(ITH/GXR)              1098     9  P  16   0

These Fields link all the proper table of the subsystem (G**).

GXR links also RAR/RTX/SIH/SIL/Etc.   

When you clean any GXR, take care of all the other, with proper relations, 
according your needs.

Good luck

Davide


-----Original Message-----
From: bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx 
[mailto:bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx] On Behalf Of 
Bunch, Wendy
Sent: giovedì 15 giugno 2006 16.31
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Cutting down GL records -archiving/purging

We are converting from 6.1.2 to 8.2 -- test conversion took too long.  IT is 
looking at reducing some records so conversion goes faster.

Among other items - they are asking us to reduce our GL files.  Accounting of 
course does not want to give anything up.  Trying to find a middle of the road. 
 I have inquired to SSA.  Basically no tools for archiving CEA in our version, 
but 8.2 does have tools and even the option of purging the detail and leaving 
the balances - so multi-year trends/comparison would still work.  One file is 
much larger than all the rest: GXR - Journal Entry Cross reference.  From what 
I've been able to gather this only comes into play as you continue to drill 
down in Account Inquiry.  Is this true from your experience?  We have most of 
the details to cross reference pulled in with the model lines/detail/analysis 
fields - so we nearly never drill down that far.   Can you think of any impacts 
- good bad or other wise if we were to reduce this one table GXR and leave the 
rest of the Gxx tables alone?

Wendy Bunch
This is an e-mail from Wabash Technologies, Incorporated.
It is confidential to the ordinary user of the above e-mail address.
It may contain copyright and/or legally privileged information.
No other person may read, print, store, copy, forward,
or act in reliance on it or its attachments.  If you received this in error, 
please e-mail to humanresources@xxxxxxxxxxxxxx



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.