Importing Data - BC - Chart of Accounts

(0) Share

Report

Posted on by Matt Smith - Cha Ltd

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:

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

All responses (5)

Answers (1)

Community Member on at

Like (0)

Report

RE: Importing Data - BC - Chart of Accounts

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.

Hope this helps.

Thank you,

Steve
Community Member on at

Like (0)

Report

RE: Importing Data - BC - Chart of Accounts

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...
Linda Lilburne 5 on at

Like (0)

Report

RE: Importing Data - BC - Chart of Accounts

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

Matt Smith - Cha Ltd 65 on at

Like (0)

Report

RE: Importing Data - BC - Chart of Accounts

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.
Suggested answer

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

Like (0)

Report

RE: Importing Data - BC - Chart of Accounts

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.