Share
Report Can you import a Chart of Accounts from excel to GP?
*This post is locked for comments
You’re offline. This is a read only version of the page.
*This post is locked for comments
Dear Annette
In my opinion, recording a Macro on the Account Maintenance Window is one of the easiest ways. Excel functionality can enhance the Data Entry of the Chart of Accounts. Although, you need to take into consideration several points, such as;
1- In case there are any other windows that will pop up through the Data Entry, they shall be included in the Macro Code. For instance, A new segment will pop up the "Segment Setup window".
2- Divide your Macro into sections (Column for each segment)
3- In case of duplications, consider another Excel sheet containing the "Current Accounts" in order to eliminate any error message while the macro is played.
In case you have the Account Level Security, you can consider another Macro to grant access on the Chart of Accounts.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (