Setup of departments in general ledger

(0) Share

Report

Posted on by Paco Medina

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?

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

Hello Paco,

You need to explore Analytical Accounting in Dynamics GP or Multidimensional Analysis.

Please explore these options.

Thanks much

Sandip

Was this reply helpful? Yes No
Paco Medina 5 on at

Like (0)

Report

Thank you Sandip for your comment. Will definitely check those alternatives.

Was this reply helpful? Yes No
rayokc 15 on at

Like (0)

Report

This community is useless. Can't help much.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Romryan on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Paco Medina 5 on at

Like (0)

Report

Thank you Romryan

That is exactly what I was looking for, as that is exactly hoy SAP does it.

Was this reply helpful? Yes No
StefanieC 434 on at

Like (1)

Report

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. :)

Was this reply helpful? Yes No
Lisa at AonC.com 937 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No