I just joined a company that has Microsoft Dynamics GP. In my previous employer they had SAP. In SAP the department does not have to be enbedded in the account number, it is a field separate from the account number that is populated with each P&L transaction being assigned to a department. From what I have been told, in GP the department must be one of the segments of the account number structure. That results in many more accounts to be created. The chart of account in this company has thousands of lines, where in my former employer was much simpler.
Is my understanding correct?
Hello Paco,
You need to explore Analytical Accounting in Dynamics GP or Multidimensional Analysis.
Please explore these options.
Thanks much
Sandip
Thank you Sandip for your comment. Will definitely check those alternatives.
This community is useless. Can't help much.
Just exactly what are you looking for? Yes, in GP your CoA is built with segments. So if you have multiple companies you have two choices. Set up each company separately with its own CoA or setup one company where one of the segments represents the company. So in your case it is departments. How does SAP handle reporting across departments? If you have 100 departments, do you have to click boxes a hundred times to include them all? Every ERP solutions has its own way of doing things. Since storage space is irrelevant here, what is the issue with having so many accounts?
Departments or any code such as branches is equal to Analytical Accounting in GP. This is separate from chart of accounts. What you do is to set up all accounts from your chart of accounts that need to be analyzed when capturing your transactions. GP will prompt you to put the respective departments during transaction processing and any transactions without the departments won't be posted.
Thank you Romryan
That is exactly what I was looking for, as that is exactly hoy SAP does it.
Keep in mind that you will find a lot of thing that is different between the two softwares. I usually advise people to give it some time to get used to GP before changing things. There are maybe things in GP that you like better than SAP also. :)
Analytical Accounting (AA) is not a "flip a switch" option. You'll need to understand the impact on the system and evaluate your reporting/inquiry needs as part of the design/implementation. Check with your GP partner to see if they have recommendations/advice.
While you are working on your AA re-design, GP has tools, like Mass Modify window, help copy from one department to another and lookup customizations to find an account by a segment.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,177
André Arnaud de Cal... 860 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
