Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Vendor invoice line - ...
Finance forum

Vendor invoice line - accessing data on posted vendor invoices

Posted on by Microsoft Employee

Hi Community,

I am trying to access data within the Dynamics 365 - Finance & Operations system regarding Vendor invoices.

The data that i need (primarily the invoice list description, Header Reference, Purchase Order, Purchase Line Number, Receive Now, Unit price) is included within the data entity 'Vendor invoice line'.

This data entity however only appears to show documents in draft status. I am unable to find an appropriate data entity (or multiple entities if cross checking is required) for posted vendor invoices. 

Can anyone point me in the right direction of where i could find this data ?

Thanks,
Matt

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor invoice line - accessing data on posted vendor invoices

    Hi Beth,

    Unfortunately not - we are currently working with our consultants as part of a project to make more data avaliable and to be able to access this data via custom reporting.

    Cheers,

    Matt

  • Beth Zapadka Profile Picture
    Beth Zapadka 190 on at
    RE: Vendor invoice line - accessing data on posted vendor invoices

    Hi Matt,

    I just wanted to follow up to see if you found a solution as we're experiencing the same issues with obtaining more-detailed spend reporting out of the system. Like you, I like the vendor invoice line entity and wish it was available for posted invoices instead of just pending.

    Thanks,

    Beth

  • Talita Profile Picture
    Talita 5 on at
    RE: Vendor invoice line - accessing data on posted vendor invoices

    Hi Ludwig,

    What do you mean exactly with 'electronic reporting'?

    We are struggling to identify the right data entities in D365FO for exports, and tie them together to create tables which we can use for reporting.

    Is this an issue you often come across at customers?

    Many thanks in advance.

    Kind regards

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor invoice line - accessing data on posted vendor invoices

    Hello Matt,

    Many thanks for this update.

    As Eugen mentioned, there is no straightforward solution available here.

    Except using the data entities, you can try using the financial reporter, which can create GL data based reports.

    Yet, I do not know whether this will be sufficient because the financial reporter can only make use of accounts and findims.

    Another alternative might be electronic reports that you can design yourself.

    Yet, designing them is not something that can be done easily and usually takes a while.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor invoice line - accessing data on posted vendor invoices

    Hi Ludwig,

    What i am trying to achieve is to provide data to my business cost centre owners on the detailed breakdown of spend to date, outside of the D365 system.

    Currently i am able to provide them with a general ledger download (which for vendor invoice postings shows the detail "supplier/vendor invoice".

    Using other data entities i have been able to match these 'Vendor invoice' postings to obtain the invoice header description, supplier ID & supplier name. In some cases this doesn't give the required level of detail of what the invoice relates to.

    What i'd like to be able to provide is supplementary information on the 'supplier invoice posting' with reference to the purchase order and the invoice line description details and amounts.

    I'd also like to be able to run some data outside of the system showing base Purchase order line values, less supplier invoices to calculate the remaining purchase order line value (i know the system has some capability for this but not to the level i'd want) (i.e. I've used the open purchase order line report or the invoice history and matching details report - however neither of these  give me the dimension details which are integral to how my business operates.

    Cheers,

    Matt

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor invoice line - accessing data on posted vendor invoices

    Hi Matt,

    Why do you need those data?

    What do you try to achieve at the end of the day?

    Best regards,

    Ludwig

  • Suggested answer
    Eugen Glasow Profile Picture
    Eugen Glasow 6,353 on at
    RE: Vendor invoice line - accessing data on posted vendor invoices

    This is a kind of an evergreen question. You have bad luck: there is no entity for VendInvoiceTrans. You'd need to program it by yourself.

    See also community.dynamics.com/.../919031

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... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,316 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans