Re: Calling all GL Experts -- SYSTEM21

   <FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"    size=2>
   John

   Hi, No expert but:&   nbsp;Do you wish to change all of your history to refl 
  ect the new chart? If you do then you will probably    need to write some 
software to go through the GL chart   , VAT and transaction files (User defined 
views as well    if in use) and re map the account code (you will als   o have 
to define mapping rules). You will then have    to change feeder ledger 
details. If you use AFI / repo   rt writer then this will also need changed for 
the new    chart.

   Best time for anything like    this is the quietest time of the year for you 
at a    month close so you can be sure of the cutover integrit   y.

   Easiest option is to copy your o   ld GL company to a history company 'xx' 
create the new    chart  and and use an opening balance journal t   o startup. 
This does not give instant access to history    but avoids many of the 
migration issues. Feeder ledgers    etc will still need changing though
   I w   ould not switch off extension codes but no need to use    them.

   Have done this both ways. Co   mplex re-mapping to retain history was hard. 
We fell    fowl of 13 period years and poor integrity. Pre req    would be to 
rebuild your GL from the start to make    sure it is square before doing 
anything else.
   &nbs= p;
   If you can, go for the opening balance journa   l and put the history into 
another company code (SQL w   ill do it).

   Good Luck
   &nb= sp;
   Cheers
   Derek
   Office: 01324 677200
   Mobile: 077= 14 012264
   <FONT color=#990099>-----system21-bounce   s@xxxxxxxxxxxx wrote: -----

   <blockquote style="PADDI   NG-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 
5px; BORDER-LEF   T: #000000 2px solid; MARGIN-RIGHT: 0px">To: 
system21@midrange   .com
   From: John.Mcpherson@xxxxxxxxxxxxxxxx
   Sent by: system21-b= ounces@xxxxxxxxxxxx
   Date: 18/05/2005 03:45PM
   Subject: [SYSTEM2= 1]   Calling all GL Experts

   <FONT face=monospace    size=2>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 exten   sion 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 h= aveon existing data?
   3. When should we do this?  W   ould it be something that should only be done
   at year    end or can it be done in the middle of the year?<   BR>4. What 
happens if I switch off extension codes anywa   y?  Will this mess
   anything up (even if I do not=  add the extra level)?
   5. Anyone done it and what s   he we watch out for and what would the steps
   be?
   <= BR>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 li= st options,
   visit: <A href="http://lists.midrange.com/mailman/l   istinfo/system21" 
target=blank  >http://lists.midrange.com/mailman   /listinfo/system21
   or email: SYSTEM21-request@xxxxxxxxxxxx
   B   efore posting, please take a moment to review the archiv   es
   at <A href="http://archive.midrange.com/system21"; target=b   lank  
>http://archive.midrange.com/system21.

   __________= ______________________________________________________________
   This e   -mail has been scanned for all viruses by Star. The
   s   ervice is powered by MessageLabs. For more information on    a proactive
   anti-virus service working around the clock,    around the globe, visit:
   <A href="http://www.star.net.uk/";    target=blank  >http://www.star.net.uk
   _______________________= _________________________________________________

   </blockquo= te>
   ________________________________________________________________________<B   
R>
   This e-mail has been scanned for all viruses by Star.    The
   service is powered by MessageLabs. For more information on    a proactive
   anti-virus service working around the clock, around the gl   obe, visit:
   <A  href=http://www.star.net.uk> http://www.star.net.uk
   ________________________________________________________________________<B   
R>