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?

Parents
  • 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.

Reply
  • 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.

Children