Finance | Project Operations, Human Resources, ...

How to upload Chart of Accounts from Excel

(0) Share

Report

Posted on by Ankit_Finance

137

Hii,

I have prepared a company chart of accounts in excel. I want to upload my chart of accounts directly into D365 without any manual entry. What is the process to upload my chart of accounts to D365?

Also Is there any specific template for this purpose?

Thanks

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Ankit_Finance,

You can use Main account data entity available in Data management to upload the chart of accounts.

You can use below template for this purpose. Once this is filled; go to Data management and click on Import. Select the job name, file type and then select the file you want to upload.

MAIN-ACCOUNT.xlsx

Otherwise you can first download the same template by clicking on Export. You will get 'download' option. Once the template is downloaded, fill the data and then upload it by using the process as explained above.

Alternatively, you can use Open in excel option available in the "Main accounts" form. Once the excel is generated; fill the data and upload it.

Kindly check and update us.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

John Ray Patajo 837 on at

Like (0)

Report

There is an issue when uploading Main Accounts from clean slate.

What you can do is create 1 Main Account first manually in F&O before doing the export and import in Data management or Open in Excel as mentioned by Sourav.

Was this reply helpful? Yes No
SouravDam 11,730 on at

Like (0)

Report

Hello John Ray Patajo,

This sounds odd! Which version you are using?

I just recently uploaded COA in 10.0.9 PU33 and got no error while uploading chart of accounts in clean UAT environment by using data management.

Appreciate if you kindly highlight the error you got.

Best regards,
Sourav Dam

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Ankit_Finance,

Have you gone through the suggestions made on this thread? Could you kindly update us and let us know if any challenge left?

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Ankit Finance,

Do you want to upload the main accounts only or also mapped account categories and other related elements such as company specific findim settings?

Depending on the answer to those questions, the upload process might be slightly different.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

It's simple 2 entities

Char of accounts to to get the COA and then main accounts to get accounts under it

could simple export from demo data and import updated one in your env.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Ankit_Finance,

Kindly go through the suggestions made in this thread and provide us an update.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Ankit_Finance 137 on at

Like (0)

Report

Sorry for the late reply, due to lockdown unable to go through system. System is showing this error while uploading the file.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Ankit_Finance,

Please try by exporting the main account template from data management; fill the data and then upload it. See if this time it works or not.

Also, appreciate if you kindly extend the yellow notification bar to see the complete error message!

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Ankit_Finance 137 on at

Like (0)

Report

Dear Mr Saurav,

Thanks alot for your efforts in trying to solve the problem, I think there is a problem in the server, which not allowing data import and export. I have sent the case to our consultant, hope they will resolve that.

Was this reply helpful? Yes No