New GL Accounts for 200 Companies

Question

For FFCRA, we need to add the same 4 new GL Accounts to over 200 different companies. Does anyone have a suggestion on how to "automate" this process? We are using Sage 100 on SQL Server. 
 
 My background is in MS SQL Server database management and development. I am just learning the intricacies of Sage applications. Naturally, I hope there is a way to call a stored procedure or write a few insert statements, but my tracing of the database activity when creating a new account through the Sage 100 interface leads me to believe this may not be a good idea. 
 Is there way to leverage BOI for this? A VI job? 
 Any guidance you can provide is greatly appreciated. Thanks!!

Kevin M · Accepted Answer

VI import job(s), with a batch file to bulk run using the same job(s) for multiple company codes. If you have GL segments, you have to ensure the Main and Sub accounts exist before importing into GL_Account.

Wayne Schulz · Answer

Would something like this help: 
 GLAC G/L Account Copy by Company GLAC G/L Account Copy by Company allows new General Ledger accounts to be copied to other companies during G/L Account Maintenance. There is also an option to update the other company Chart of Accounts when a change is made to an existing account. A new Company Consolidation Maintenance has been added to the Library Master Setup Menu that allows selection of Company Codes for automatic copy of G/L Account additions. There is a checkbox option to allow G/L Account changes to also update other companies. 
 There is also a checkbox option to have a user prompted when an account is added or changed, and the user may change the companies to be updated. 
 NOTE: This enhancement requires that ALL companies have the same Account Structure and Mask.

https://development.dsdinc.com/enhancement/gl-account-copy-by-company-3/

Sage 100

New GL Accounts for 200 Companies

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING