I need to add 500 or more GL accounts and Description using SQL UPDATE statement. Which tables and columns need to be updated?
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.
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.
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?
*Community Hub is the new name for Sage City