Renaming Chart Of Account

duo1983

Hi anyone there...

I have a situation here where i need to reorganised the whole chart of account for a Live Navision 4.0 SP1 system on SQL.

The system is quite big currently (roughly 30Gb) in just 1 yr time due to the high volume of transactions going thru everyday.

Renaming 1 single account took roughly 40mins.
I have ard 180 Accounts to rename, thus i will need to run the renaming in a batch job.

Wonder if anyone did batch renaming for the GL Accounts before?
Are there any implications or risk (corruption, system hang etc)
Is there any faster way to have the job done as it is very hard to cut off system for too many days.

Hope any kind soul out there can enlighten me with some solutions or is there any program that we can purchase that does batch renaming of GL Accounts. [-o<

ssingla

There are lot of post regarding this on the forum.

Search is your best friend.

ecclectic

i would do it table wise using a code unit and renaming only one subset of each at a time.
better do it starting on a friday evening when nobody using the system and cancelling other scheduled jobs that might interfere.
remember that if u renaming accounts using batch jobs- u'll have to pick up all related tables such as g/l entry, default dimension- if u have dimensions attached to account and all ur setup accounts

ta5

Just my 2 cents:
Be sure you dont face the ffw problem
http://www.mibuso.com/forum/viewtopic.php?t=15001

(Maybe it's a SP2 problem only)

Thomas

kriki

The fasted way to run the global rename is to make a program that scans each table and changes the G/L Account in it and then saves the record.
The negative is that you have some research to do (wich fields are G/L Account Nos) and some programming to do (change the field if it contains a G/L Account No. (e.g. "Purchase Line"."No." can contain G/L Account but also items)].