Re: Calling all GL Experts

Have you thought about using the GL Hierarchy functionality. You could create a 
B/S Hierarchy Ledger - Structure Level 1 & Level 2, and a P/L Hierarchy - 
Structure Level 1 & Level 2. This will represent the new Chart of Account 
Structure.
 
Attach your current Level1/Level5 combinations to the new Hierarchies and then 
report using these structures rather than your current structure. This way you 
can leave all your subsidiary files as is - if you need to report numbers using 
subsidiary files that have GL Account numbers - you can go to FLP075 to obtain 
the Parent/Child relationship and "pick up" the new GL Account number.
 
This solution allows you to leave history alone and create a new structure that 
satisfies the French. There will be some on-going maintenance for new accounts 
but hopefully this should be minimal.
 
Good luck.
 
Phil Rawson
 
-----Original Message-----
From: Lemon, Mike <MLemon@xxxxxxxxxxx>
To: 'System 21 Users' <system21@xxxxxxxxxxxx>
Sent: Wed, 18 May 2005 11:21:20 -0400
Subject: RE: [SYSTEM21] Calling all GL Experts


2. What effect will this have on existing data?

It is my impression that all the old data would need to be converted in
order for it to be useful.  Account balances would need to be split up
(based on user defined views balances I would assume).

Hopefully they aren't doing any changes to the codes in the levels in the
process or this will get messy very quickly.

In an era where companies are working towards common charts of accounts to
simplify reporting and accounting across consolidated entities, this seems
to be a move in the wrong direction.



-----Original Message-----
From: John.Mcpherson@xxxxxxxxxxxxxxxx
[mailto:John.Mcpherson@xxxxxxxxxxxxxxxx] 
Sent: Wednesday, May 18, 2005 10:45 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Calling all GL Experts


OK....Do not ask my why, but we have a request from our French sub to change
their chart of accounts.  They are currently setup with 1 level and 1
extension code level.  They would like to change this to be 2 chart of
account levels and no extension code levels.  My questions are therefore:

1. What is the best way to do this?
2. What effect will this haveon existing data?
3. When should we do this?  Would it be something that should only be done
at year end or can it be done in the middle of the year? 4. What happens if
I switch off extension codes anyway?  Will this mess anything up (even if I
do not add the extra level)? 5. Anyone done it and what she we watch out for
and what would the steps be?

Thanks for all the help.

Cheers,
John

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.