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
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/.../
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156