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
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
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
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
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
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
Hi Matt,
Why do you need those data?
What do you try to achieve at the end of the day?
Best regards,
Ludwig
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,316 Most Valuable Professional
nmaenpaa 101,156