Welcome, Guest. Please Login.
05/07/24 at 13:10:00
News:
Home Help Search Login


Pages: 1
Send Topic Print
Need Help! Changing G/L Codes (Read 763 times)
Mike@TEK
Browser
*


I love YaBB 1G -
SP1!

Posts: 24
Need Help! Changing G/L Codes
12/11/03 at 13:19:37
 
We need to correct our chart of accounts (change 350-some account codes from four digits to a nine-digit code) by the end of the month, no questions asked.  Key questions:
 
1) AM-H Change G/L Account Codes will make the change only if the new account code is already entered into DBA.  We see two choices.  Either enter the 350 new accounts in through AM-C Enter General Ledger Accounts or try to import the 350 accounts in through DE-G Import Chart of Accounts.  Using the DE-G should be much quicker.  My question is then: can we import JUST the 350 new accounts through DE-G, leaving intact in the chart of accounts the existing account codes?  Or will DE-G force us to import all new AND existing accounts (which could adversely affect the general ledger operation)?
 
2) If we can import, can we import the new codes in with the additional 4-digit department code, or do those codes need to be added through AM-D?
 
3) Once the new codes are in, are properly changing account codes as simple as using AM-H and changing the default settings in AD-A?  That is to say, what do we need to look out for?  We would like the G/L codes to change for 2001 and 2002 G/L activity, change in all open PO, work order, inventory, sales order, A/R and A/P activity as well as closed work orders, sales orders and POs  (we have not archived any of our DBA files into the DBA historical files).  Or will this process evolve into a massive hand-edit in the G/L data files?
 
Thanks!
Mike
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Need Help! Changing G/L Codes
Reply #1 - 12/11/03 at 16:23:23
 
Mike to the best of my knowledge here are answers to your questions:
 
1) When you import, the exisiting file WILL be wiped out. The import function is, unfortunately, not an 'append' function, it is a 'replace' function. You MAY be able to use the same trick that Lynn has described in previous postings for how to accomplish an append type of situation with the inventory master. Do a search on that in this forum.
 
2) I assume you mean Profit and Loss centre type of depatment codes. If so, you 1st need to set up the departments and then you can put in the GL extensions.
 
3) Yes, just use AM-H. It will change the codes throught the file structure. Make certain NO ONE is in the system for the entire period you are doing that. And if you have quite a bit of data, it WILL take a while to run. You may need an entire weekend of longer days to accomplish this.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Need Help! Changing G/L Codes
Reply #2 - 12/11/03 at 21:54:50
 
1.  Actually, Lorne is mistaken.  If you import the Accounts, it will append to the existing file.  It will only replace existing account numbers.
 
2.  Yes, you can import the new codes with the departments
 
3.  Yes, so long as you do both steps.  Change the existing data to transfer to the new account and change the defaults so subsequent postingd also go to the new account.
 
 
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Need Help! Changing G/L Codes
Reply #3 - 12/12/03 at 07:47:18
 
As to #1.....
 
Well, even I can be wrong occasionally.... Wink
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Pages: 1
Send Topic Print