Finance | Project Operations, Human Resources, ...

Expense report booking from d365 fno

(0) Share

Report

Posted on by gauravvirdi

Hi,

I am using D365 Project Operations Non-Stocked integrated version with D365 FnO. I am booking expense from expense management in d365 fno and the amount is integrated with D365 Project OPerations. But the Financial entry in FnO is going as:

Project Operation Integration Account Dr. (It should be the expense account linked with Expense category but it went to Project operation integration account)

Account Payables Cr.

Need assistance on the same.

Regards

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

MarkB45 755 on at

Like (1)

Report

Hi Guaravvirdi,

The initial F&O posting of the expense report hits the integration account as it passes into the CE side. Once it is in CE it is then taken back into F&O through the staging table to be posted through the projects module using the project integration journal where it picks up the correct ledger account for the expense category. The below diagram shows the flow of data:

In F&O terms it is doing the below postings:

Expense Report:

Dr Integration account specified in PMA Parameters

Cr Employee AP account

Expense posted as actual in CE and imported into F&O Actuals staging table

Project Integration journal

Cr Integration account

Dr Project Category ledger account (Posting type "Project - Cost")

You might want to check the "Project Integration journal" menu item for the related integration journal if you can't see the expense transaction against the project in F&O.

Hope this helps to clarify.

KR

Mark

Was this reply helpful? Yes No
gauravvirdi 96 on at

Like (0)

Report

Hi Mark,

Thankyou for your reply.

There was some problem in the "Import from Staging table" batch due to which entries were not coming integration journal. My one problem is solved that the financial accounting is correct and it exactly as you have mentioned.

But the another issue which i see is, the expense entries didnot post the "Unbilled sales" in project operations due to which i am not able to bill it to customer whereas it was chargeable in nature. Only Cost type entry is posted. Any suggestions here.

Regards

Gaurav Virdi

Was this reply helpful? Yes No
MarkB45 755 on at

Like (0)

Report

Hi Gaurav,

That issue could be done to a few things:

Is the line property against the transaction showing under CE Actuals chargeable if not it won't have created the un-billed and you will need to figure out where it has inherited the line property from and amend.

Also check your sales price lists

Was this reply helpful? Yes No
apa 8,284 Moderator on at

Like (3)

Report

Also check that you have an order (Project Contract) set up in CE with a T&M order line and include expense flag set to yes.

Was this reply helpful? Yes No
gauravvirdi 96 on at

Like (0)

Report

Hi Anti,

Thankyou for your response.

After couple of attempts, I found why the expense report is not posting properly. At the project contract line level, if I select “Selected project tasks only” in Include task field than it is not creating revenue line for expense generated through expense management module from FnO. I have highlighted the field in the below screen shot for reference.

I guess it's a bug, but not sure. I will confirm the same with Microsoft as well.

Was this reply helpful? Yes No
gauravvirdi 96 on at

Like (1)

Report

Hi Mark,

Thankyou for your response.

After couple of attempts, I found why the expense report is not posting properly. At the project contract line level, if I select “Selected project tasks only” in Include task field than it is not creating revenue line for expense generated through expense management module from FnO. I have highlighted the field in the below screen shot for reference.

I guess it's a bug, but not sure. I will confirm the same with Microsoft as well.

Was this reply helpful? Yes No
Suggested answer

MarkB45 755 on at

Like (1)

Report

Hi Guarav,

Take a look at the below Doc for more information around that functionality.

docs.microsoft.com/.../mapping-projects-tasks-contract-line-sales

KR

Mark

Please mark my answer as verified if you found it helpful. This way the community can see there is a valid answer to the thread's topic

Was this reply helpful? Yes No