Chart of account G/L numbering issues .

(0) Share

Report

Posted on by Aslamjmk

229

I am facing problem to configure Chart of accounts to client given number serious.
Example: I have a chart of account in given number serious by client

After Upload the COA in Business Central it will sort different

All responses (4)

Answers (2)

Aslamjmk 229 on at

Like (0)

Report

RE: Chart of account G/L numbering issues .

Thanks
Verified answer

YUN ZHU 82,927 Super User 2025 Season 1 on at

Like (0)

Report

RE: Chart of account G/L numbering issues .

Hi, as mentioned by the above experts, there is no problem with the ordering of the system, Similar to the file name in windows, it is sorted according to the first number first, and then so on.

If you want to solve this problem, it is recommended to use the No. 2 field (Or add a new field), and enter the order you want in this field, such as 0,1,2,3. Then make a small customization and sort according to No. 2 in OnOpenPage (Page) Trigger.

Hope this will help.

Thanks.
Verified answer

Teddy Herryanto (Th... 13,637 Moderator on at

Like (0)

Report

RE: Chart of account G/L numbering issues .

You need to have the same number of digits, otherwise it will not sort out nicely. BC sort code by text, not number.
Suggested answer

Community Member on at

Like (0)

Report

RE: Chart of account G/L numbering issues .

Hello,

In your pic it does not show any COA with 5 digits. BC will sort COA's in numeric order so the 2nd pic is sorting correctly.

Thanks,

Steve