Adding new GL Accounts

SUGGESTED

I need to add 500 or more GL accounts  and Description using SQL UPDATE statement.  Which tables and columns need to be updated?

  • 0
    SUGGESTED

    In Setup > (Codes) Payroll > (General Ledger) Accounts, you have the ability to import G/L information.  The import file type can be Excel, csv, xml and more.  To see which tables are affected with adding a G/L account, I would suggest running a SQL trace with an account is created manually from within the software.  It is recommended to use the import feature rather than going into the back end of the software (SQL) and creating accounts.

  • 0 in reply to Lynn C

    Great. Thank you.

    So I am going to use an excel file and only need to enter new GL Account numbers and description of the each account. What should I name the 2 columns in the excel spreadsheet so that import process will except it?