• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Update chart accounts in F0901 by SQL

gomezc73

Member
Hi, I am new in the forum and i have a problem, my company is requiring to create a lot of chart accounts in the file F0901 and maybe the way to do that is insert them using SQL.

My concern is that in the F0901 there is a field GMAID (AccountID) that is generated automatically, i don't know how i can manage that issue if in SQl this field is empty.

How this identifier field can be generated?

Can somebody help me?
 
Hi, I am new in the forum and i have a problem, my company is requiring to create a lot of chart accounts in the file F0901 and maybe the way to do that is insert them using SQL.

My concern is that in the F0901 there is a field GMAID (AccountID) that is generated automatically, i don't know how i can manage that issue if in SQl this field is empty.

How this identifier field can be generated?

Can somebody help me?
There is an existing and very powerful program that can correctly create massive amounts of accounts based on several different types of options. If you have to use SQL you will need to increment the AID field based on the F0002 next numbers. You REALLY need to know what you are doing. I don’t recommend using SQL, too many possible issues.
 
Are they branch new object accounts or are they accounts that exist in your model chart of accounts??

You can use tools such as "Copy BU Acct" from P0006 to copy the GL accounts to a new business unit, company or type of Business Unit.
You can specify the account level of detail and beginning and ending account numbers for the copy as well.

Maybe you are not doing this but thought I would mention this just in case you are only 'creating' for new company or business unit(s).

PS - I would avoid SQL for this process if possible.
 

Rauf

Member
Hi Gomezc73,

I agree with all the above posts.
Stay away from SQL as much as you can.

For most of the procedures, there are vanilla applications shipped.
So you can go to
P0006 -> Row exit --> Accounts --> Copy BU Acct
 
Top