• 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?
 

Alex Blasenheim

Well Known 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?
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.
 

Mike Mackinnon

Well Known Member
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

VIP 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