Announcements
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?
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.
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. :)
Thank you Romryan
That is exactly what I was looking for, as that is exactly hoy SAP does it.
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.
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?
This community is useless. Can't help much.
Thank you Sandip for your comment. Will definitely check those alternatives.
Hello Paco,
You need to explore Analytical Accounting in Dynamics GP or Multidimensional Analysis.
Please explore these options.
Thanks much
Sandip
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156