Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Import vendor invoice ...
Finance forum

Import vendor invoice journal with add in excel and account type projet

(0) ShareShare
ReportReport
Posted on by Apix 307

Hi everybody, 

I'm struggling to use the add in excel functionality with a vendor invoice journal and a ledger account type "project". It seems that this kind of account is not supported by the default excel template (see attached picture 1). 

My first question is to know whether or not it is possible to configure a template to use this kind of ledger account to import lines in a vendor invoice journal.

In General Ledger > Journals entries > General journals we can use a template called Project expense journals allowing the use of ledger account type "project" (see attached picture 2)

So my second question is to know if we can use this template to record a vendor invoice. I found out that it is possible to get the invoice number field in the template so we could have everything available to record a vendor invoice. But may be a difference exist between a vendor invoice  journal and general journal that will not allow me to record the first one by the second one. 

Kind regards, 

7774.1.png2541.2.png

Categories:
Project Management
Financial Management
Data Integration
  • Apix Profile Picture
    Apix 307 on at
    RE: Import vendor invoice journal with add in excel and account type projet

    Hi Ludwig,

    I removed some filters in the pending invoice form and i'm now able to see my vendor invoice posted on project.

    Thank you for your help!

    Have a good day,

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Import vendor invoice journal with add in excel and account type projet

    Hi Piccin Aymeric,

    Can you check if you can change the default filters in the open vendor invoice screen to see also the project related invoices?! Maybe a small modification might help here?!

    With the pending vendor invoice form I mean the vendor invoice header and lines that you can enter - and import via Excel. This form is at least from my perspective the most flexible one as you can post PO related invoices, project related invoices and expense related invoices in a single screen. Yet, the handling is different from what you might be used to from journals.

    The last thing about electronic reporting: You can create something similar to what I demonstrated on my blog but you need to use a different entity. If you have not worked with electronic reporting before, I would recommend that you look into the other options first because it will take you a while to make this electronic import functionality work.

    Best regards,

    Ludwig

  • Apix Profile Picture
    Apix 307 on at
    RE: Import vendor invoice journal with add in excel and account type projet

    Hi Ludwig,

    Thank your for your quick reply,

    I tried to use a project expense journal to post a vendor invoice journal. Everything is fine expect that the invoice is not transferred in the open vendor invoice screen.

    By using the pending vendor invoice form, do you mean to create a vendor invoice from scratch in the pending vendor invoice screen and open it with the add in excel?

    I also view your last video about electronic reporting on your blog. Do you think we can use these functionalities to create a template in order to import massive vendor invoice with an ledger account type "project"?

    Kind regards,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Import vendor invoice journal with add in excel and account type projet

    Hi,

    For project related vendor invoices, you have to use the project expense journal if you plan to import the transactions via Excel. The alternative is modifying the data entity used for the vendor invoice journal.

    An alternative is using the pending vendor invoice form where you can add project related data.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,013 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans