Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Setup of departments in general ledger

(0) ShareShare
ReportReport
Posted on by 5

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?

  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    RE: Setup of departments in general ledger

    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.

  • StefanieC Profile Picture
    StefanieC 432 on at
    RE: Setup of departments in general ledger

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

  • Paco Medina Profile Picture
    Paco Medina 5 on at
    RE: Setup of departments in general ledger

    Thank you Romryan

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

  • Suggested answer
    Romryan Profile Picture
    Romryan on at
    RE: Setup of departments in general ledger

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Setup of departments in general ledger

    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?

  • rayokc Profile Picture
    rayokc 15 on at
    RE: Setup of departments in general ledger

    This community is useless. Can't help much.

  • Paco Medina Profile Picture
    Paco Medina 5 on at
    RE: Setup of departments in general ledger

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

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Setup of departments in general ledger

    Hello Paco,

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

    Please explore these options.

    Thanks much

    Sandip

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.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans