Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Setting up new COA for our business in Dynamic 365 Business Central

Posted on by 10

I am trying to set up a new COA to help me consolidate several exsiting businesses into a single plate form in Business central.  I have created a mapping tool that I want to use to help me set up my COA.  But the GL coding containes  several fields.  ie..  XX.XXXXX.XX.XXX      first field is my legal entity company XX    second field is my traditional GL string  10001 xxxxx,  third field is XX  my location string (in 99 different locations), and final string XXX  is the services or products we will offer

Can I set up a COA in business central that will accompicate this string?   XX.XXXXX.XX.XXX

thanks for your advice

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,738 Super User 2024 Season 2 on at
    RE: Setting up new COA for our business in Dynamic 365 Business Central

    Typically in Business Central rather than using a segmented G/L Account numbering structure you would use dimensions. In your case each string would be a different dimension (legal entity, location, services or products would all be dimensions) and only the traditional G/L string is used as the G/L account number 10001.

    More info: learn.microsoft.com/.../

  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,234 Super User 2024 Season 1 on at
    RE: Setting up new COA for our business in Dynamic 365 Business Central

    As far as I can understand the XX.XX.XXXX coding will be the value in the "No" column of your BC COA. You can follow these recommendations:

    1. Make it numeric, not alphanumeric. BC allows you to have a alphanumeric value however it'll be a hard time for you to sort your accounts in ascending/descending if they are alphanumeric

    2. I'd suggest get rid of the period (dots) between XX.XX.XXXX and form a number XXXXXX up straight. It will be so much easier for you while you're doing reporting out of COA. Plus you can accommodate some other characters in place of these dots, remember the limit of this field is 20 characters. I understand if you say it will be hard to read, but trust me, it's just a matter of a couple of days for you to get used to it. If you type in 201010 or 20.10.10 in a search it will bring up 201010 only so in essence you're still using the same numbers w/o period (dots) in between. You know the first 2 digits represent legal entity, second field represents GL String, etc. which should be enough. Business Central stores your COA per company, meaning Company A's COA is not visible in Company B

    As a suggestion we often give to our customers: if you want to check if a certain practice of coding/describing your G/L accounts is suitable in BC, have a look at your BC database's Cronus Company. It is a demo company packaged by MS to give you a look and feel of how to operate BC. Have a look at that COA and compare it with yours. Apart from additional accounts (which your company may need) get rid of anything which does not match (Example: Cronus also follows coding of GL, without the dots in between)

    Also, I would request you to consider Dimensions in BC. It may save you a lot of work to segment your codes, see if it helps

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans