Results 1 to 7 of 7

Thread: Update chart accounts in F0901 by SQL

  1. #1

    Update chart accounts in F0901 by SQL

    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?

  2. #2
    Member
    Join Date
    Feb 2002
    Location
    Florida, USA
    Posts
    179
    Quote Originally Posted by gomezc73 View Post
    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.
    JD Edwards E1 and World
    Blasenheim Solutions, LLC
    Technical and functional consultant specializing in Financials

  3. #3
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    180
    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.
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.1.4.4, Application RL 9.0
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 62.0.3202.94

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  4. #4
    Nice information. Thanks for it.

  5. #5
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    701
    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
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

  6. #6
    Have you looked at using P01RS901?
    Dave Schleicher
    LOGIS
    9.2, 9.2.2.2 (Web 9.2.2.3), Windows x64 (2012 R2), SQL 2014, WLS 12.1.3.0.0

  7. #7
    Really great information.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.