D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Importing Project Vendor Invoices

  • 1.  Importing Project Vendor Invoices

    TOP CONTRIBUTOR
    Posted 9 days ago
    Edited by Christopher Ho Yee 9 days ago
    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
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Importing Project Vendor Invoices

    Posted 8 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Importing Project Vendor Invoices

    TOP CONTRIBUTOR
    Posted 8 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: Importing Project Vendor Invoices

    Posted 7 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: Importing Project Vendor Invoices

    TOP CONTRIBUTOR
    Posted 7 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: Importing Project Vendor Invoices

    TOP CONTRIBUTOR
    Posted 7 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


  • 7.  RE: Importing Project Vendor Invoices

    TOP CONTRIBUTOR
    Posted 7 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role