web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Get invoices from Open Vendor invoices tab via rest request

(0) ShareShare
ReportReport
Posted on by 130

Hi ,

My issue is to get invoices from tab named "Open Vendor Invoices" via rest request

 pastedimage1638476233806v1.png

Previously, I used such GET request : 

usnconeboxax1aos.cloud.onebox.dynamics.com/.../VendorInvoiceHeaders eq 'Ptah' and InvoiceNumber eq '00000223'

But, it was revealed that such request returns invoices only from "Pending Vendor Invoices"

pastedimage1638476454383v2.png

What I should use in request in order to extract Invoices from "Open Vendor Invoices" tab ?

Kindest Regards,

Zaliscky Ivan

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    303,730 Super User 2026 Season 1 on at

    Hi Zaliscky,

    Out of the box, there is no standard data entity for this purpose. You would need to create a new data entity. Either start from the vendor invoices or vendor transactions. The transactions do have information about the settlement details to know if it is an open invoice or not.

  • Dynamics Questions Profile Picture
    130 on at

    Hi André Arnaud de Calavon,

    Thank you for the quick response.

    I need to clarify some moments :

    You mentioned :

    "The transactions do have information about the settlement details to know if it is an open invoice or not".

    In my case it is not important to know the status of the invoice, I just need to check if this invoice is present in Dynamics. My issue was caused by situation when client has inputted the invoice, but our application did not find this invoice, after that it was revealed that we worked only with pending invoices.

    Is it possible to extract all Invoices from dynamics ?

  • André Arnaud de Calavon Profile Picture
    303,730 Super User 2026 Season 1 on at

    Hi Dynamics Questions,

    It is possible if you develop an own entity. As the status is not important, you can choose to start from the vendor invoices or the transactions.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 616

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 460 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 331 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans