Adding new GL Accounts

Question

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

Lynn C · Answer

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.

Sage HRMS

Adding new GL Accounts

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING