web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Importing Data - BC - ...
Small and medium business | Business Central, N...
Answered

Importing Data - BC - Chart of Accounts

(0) ShareShare
ReportReport
Posted on by Matt Smith - Cha Ltd 65

Hi All,

Hope everyone is well.

I'm using the data migration tool to import GL accounts into BC. It imports the GL codes required, but doesn't seem to import the account categories correctly.

I am using the standard data template you can download from BC as below:

pastedimage1586884890878v2.png

When the data has finished importing, the account category is left blank, even though I have specified the category to be used.

Can anyone suggest where I might be going wrong?

Regards,

Matt

I have the same question (0)
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,302 Super User 2026 Season 1 on at

    Did you also import Account Subcategory Entry No. ?

    If Account Subcategory is filled in, it will overwrite the account category based on the sub category - account category.

  • Verified answer
    Matt Smith - Cha Ltd Profile Picture
    Matt Smith - Cha Ltd 65 on at

    Hi Teddy, thanks for the reply. I managed to get this working by adding the category code, rather than the text value. You can hover over the menu title (tooltip) to see the numeric values that are assigned to each category.

  • Linda Lilburne Profile Picture
    Linda Lilburne 5 on at

    Where do I see what the Account Subcategory Entry No. is please? I can't see any number on the GL Account Category list.

  • Community Member Profile Picture
    Community Member on at

    Hi Linda, I'm facing the same issue, have you found the Account sub category ID, i'm not able to find it anywhere, please advise...

  • Community Member Profile Picture
    Community Member on at

    Good Day All,

    When you setup your G/L Account Categories you are building the over Entry number structure. You can see this when opening the Page G/L Account Categories. See my screen shot below. I highlighted the 4 row, or Entry No. 4. Given Entry 4 rolls up to Parent Row 2, No. 2, Current Assets. The Entry No. fields are not visible on the Page but you can either run a Configuration Package Export to see the field or while highlighting a row, press CTRL-ALT-F1.

    pastedimage1608329555456v1.png

    Hope this helps.

    Thank you,

    Steve

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,005 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,148 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans