Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Christopher Ho Yee]

Hello Community,

We’re investigating importing Intercompany Project related expenses as a pending Vendor Invoice as this allows us to leverage the existing intercompany functionality. 

However, when testing the DMF it appears that the associated vendor invoice line data entity lacks any of the project related fields (i.e. Project ID, activity, resource, etc.)

Is there another way to import this type of transaction or do we need to modify the data entity to include the Project related fields?

We do recognize that this could be one via expense management. However, this is not a practical option for this business scenario.

We are on Version 10.0.4, PU 28.

Thanks,

——————————
Christopher Ho Yee
Altius Consulting
Richmond BC
——————————

[Marlene Baldwin]

Hi Christopher,

The AP Invoice Journal has an option to select “Project” as your Offset Account Type and then select a Project ID as the Offset Account. Have you tried importing invoices with those settings?

——————————
Marlene Baldwin
Sr Consultant
Stoneridge Software
Fargo
——————————
——————————————-

[Christopher Ho Yee]

Hi Marlene,

Thanks for replying. Yes, we did attempt this approach, but this is disallowed. Assuming this is due to the pending deprecation of multiple transactions within one voucher functionality – https://docs.microsoft.com/en-us/dynamics365/finance/general-ledger/one-voucher.

——————————
Christopher Ho Yee
Altius Consulting
Richmond BC
——————————
——————————————-

[Chantal Golding]

Hi Chris,

Our developer had to do a major custom with the intercompany function in order to allow project invoice intercompany transactions to be possible. We were told that this does not exist out-of-box by our integrator. We have been using this customisation since May 2018 and it works well. If you would like to discuss further you can e-mail me. We are also currently on V10.0.4 PU28.

——————————
Chantal Golding
PSP Investments
Montreal QC
——————————
——————————————-

[Zvika Rimalt]

I believe it was never possible to a “vendor invoice journal”, inter-company, into a project. 

It has not stopped as part of the recent “one voucher” change.

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-

[Zvika Rimalt]

I understand correctly that you are trying to use “Vendor Invoices” (and not AP invoice journal) for the intercompany transactions?

If so, did you verify this is working when entering it through the regular UI? Maybe the DMF template misses those files since this is not available through manual data entry?

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-

[Christopher Ho Yee]

Hi Zvika,

Yes, that is correct. We are investigating using the Vendor invoice functionality as you can charge projects (and in this specific instance Intercompany projects).

It would also lay the groundwork for future A/P automation as I believe vendor invoice uploads via DMF is Microsoft’s prescribed approach.

Related project fields can be entered on the Vendor invoice. However, aside from Project ID, the other required fields for our configuration don’t appear in the data entity.

So, that leads me to question whether:

1. there is another method that I am unaware of
2. modification of the data entity is the way to go
3. no-one uploads vendor invoices with projects (whether intercompany or not).

Appreciate any insight.

——————————
Christopher Ho Yee
Altius Consulting
Richmond BC
——————————
——————————————-