How to imort General Journal which accout type is Project.

(1) Share

Report

Posted on by Jacky Qian

460

Hi All:

I wanted to import general journal which contains a project accout by using Data management. I select the entity General Journal . The excel file was created as followings , as well the file was uploaded.

But the result tell me, The account type selected (Project ) is not supported.

How to resolve this issue ? Do you have any suggestions?

Thanks

I have the same question (0)

All responses (13)

Answers (4)

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Copy link

Link copied!

Hi Jacky?

Are you able to enter journals with Project as the account type from D365 UI?

Was this reply helpful? Yes No
Verified answer

vinitgoyal2005 6,332 on at

Like (1)

Report
Copy link

Link copied!

Hi Jacky,

Have you tried using Open in excel feature and import records using Excel?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,

In GL journals you can record project expenses only.

Rather than doing that in a GL journal, which would require an adjustment, use the default project expense journal template, which can import those data out of the box.

Best regards,

Ludwig

Was this reply helpful? Yes No
Jacky Qian 460 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your reply.

Yes, I'm sure I can type a journal with Project as the accout type from D365 UI.

In fact , the following data are these which I had typed and I exported . But I failed to import into D365 these data which I had exported.It's confusing.

Was this reply helpful? Yes No
Jacky Qian 460 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your reply.

I tried that. But it seemed that Open in excel does not support import journals with dimensions. But my Ledger needs to import dimensions.

Was this reply helpful? Yes No
Jacky Qian 460 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your reply.

You means the solution is using the default project expense journal template. But I don't konw how to get the project expense journal template. Could you provide the template for me or give me more detailed information.

Best regards.

Jacky

Was this reply helpful? Yes No
Jacky Qian 460 on at

Like (1)

Report
Copy link

Link copied!

Hi

I searched the functionality and found the Project expense journal in Open In Excel . I think this is what you had said .

Let me try.

Thanks

Was this reply helpful? Yes No
Verified answer

vinitgoyal2005 6,332 on at

Like (1)

Report
Copy link

Link copied!

Hi Jacky,

Good if you use Project expense journal. But 'Open in Excel' does support the Financial dimensions. you just need to update the Template. look at blog: community.dynamics.com/.../add-financial-dimensions-in-excel-template-in-microsoft-dynamics-365-finance-and-operations-apps You may also need to setup FDs to be used in template using form 'Financial dimension configuration for integrating applications' in D 365FO

Was this reply helpful? Yes No
Jacky Qian 460 on at

Like (0)

Report
Copy link

Link copied!

Hi Vinit：

Thanks a lot for your reply.

I will try as the blog.

Best regards.

Was this reply helpful? Yes No
Jacky Qian 460 on at

Like (0)

Report
Copy link

Link copied!

Hi Vinit, All :

I have do something as the description of the blog. But I can't found any fields which is about account dimension in Project expense journal lines table.

Do you have any suggestion ?

Best regards !

Was this reply helpful? Yes No