Account format change #3

GP 9
framework length = 14
4 segments 
3-4-4-3
seg 3 natural
current useage
length 11
1-3-4.3
in a test environment
under tools setup acct format made the changes so that 
length = 14 seg1=3 seg2 =4 no change to seg3 or 4
this keeps us within the framework
and saved
ex acct 0-401-5000-399 became 0ss-401s-5000-399 s=space
I then ran the prof tools modifier 
final acct 000-0401-5000-399 with the actindx of 
0-401-5000-399 = to the new acct 000-0401-5000-399
only results that I have an issue with so far is the gl40200
the 2 segments that were changed had both in the table and the new longer 
segments had blank descriptions

if i delete from the table a check links will bring back a table with all 
records but blank descriptions
or I can script an update statements to update the description 

If i use a script if can i delete the old segment values without causing any 
errors or should I leave alone
0
McMillan (17)
5/16/2008 8:31:04 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
334 Views

Similar Articles

[PageSpeed] 14

Hi Mark,

After you ran the PST Account Modifier, did you delete the GL00105 and then 
proceed to run Check Links against the Account Master?

Thanks
Don

"Mark McMillan" wrote:

> GP 9
> framework length = 14
> 4 segments 
> 3-4-4-3
> seg 3 natural
> current useage
> length 11
> 1-3-4.3
> in a test environment
> under tools setup acct format made the changes so that 
> length = 14 seg1=3 seg2 =4 no change to seg3 or 4
> this keeps us within the framework
> and saved
> ex acct 0-401-5000-399 became 0ss-401s-5000-399 s=space
> I then ran the prof tools modifier 
> final acct 000-0401-5000-399 with the actindx of 
> 0-401-5000-399 = to the new acct 000-0401-5000-399
> only results that I have an issue with so far is the gl40200
> the 2 segments that were changed had both in the table and the new longer 
> segments had blank descriptions
> 
> if i delete from the table a check links will bring back a table with all 
> records but blank descriptions
> or I can script an update statements to update the description 
> 
> If i use a script if can i delete the old segment values without causing any 
> errors or should I leave alone
0
don.craig (55)
5/19/2008 8:06:01 PM
i did not delete the gl00105 before running the check links on the acct master

options as i see it 

before making any changes 
query the gl40200 for each company that has records with descriptions
make the changes
delete the gl40200
checklinks
use trhe data above to update the descriptions

or 

just run the checklinks which will leave the gl40200 with records from the 
okl acct format as well as the new format
use a query to update the description and leave both records
once complete delete the records I don't want

option 1 appears to be cleaner
I just want to verify that I am not missing something in my thinking that 
will cause issues later

"Don" wrote:

> Hi Mark,
> 
> After you ran the PST Account Modifier, did you delete the GL00105 and then 
> proceed to run Check Links against the Account Master?
> 
> Thanks
> Don
> 
> "Mark McMillan" wrote:
> 
> > GP 9
> > framework length = 14
> > 4 segments 
> > 3-4-4-3
> > seg 3 natural
> > current useage
> > length 11
> > 1-3-4.3
> > in a test environment
> > under tools setup acct format made the changes so that 
> > length = 14 seg1=3 seg2 =4 no change to seg3 or 4
> > this keeps us within the framework
> > and saved
> > ex acct 0-401-5000-399 became 0ss-401s-5000-399 s=space
> > I then ran the prof tools modifier 
> > final acct 000-0401-5000-399 with the actindx of 
> > 0-401-5000-399 = to the new acct 000-0401-5000-399
> > only results that I have an issue with so far is the gl40200
> > the 2 segments that were changed had both in the table and the new longer 
> > segments had blank descriptions
> > 
> > if i delete from the table a check links will bring back a table with all 
> > records but blank descriptions
> > or I can script an update statements to update the description 
> > 
> > If i use a script if can i delete the old segment values without causing any 
> > errors or should I leave alone
0
McMillan (17)
5/20/2008 4:23:05 PM
Reply:

Similar Artilces: