web
You’re offline. This is a read only version of the page.
close
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 / Small and medium business | Business Central, N... / API: SalesInvoice miss...
Small and medium business | Business Central, N...
Suggested Answer

API: SalesInvoice missing records

(0) ShareShare
ReportReport
Posted on by JMGCORNATOR 10

Hi,

i am trying to fetch posted sales invoices through the endpoint /salesInvoices&expand=salesInvoiceLines.

In BC i have verificed 16 posted invoices, however, when performing the call, I only receive 10 records. It is always the same records.

if I set filter on document number to one of the 6 documents that I do not receive, the API will return nothing. I get no erro message.

Is there any requirements for a sales invoice to appear in the API?

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,548 Super User 2025 Season 2 on at

    Hi, Are there any filters in the endpoint?

    I just tested it, and it doesn't seem to be a problem.

    My test endpoint:

    api.businesscentral.dynamics.com/.../salesInvoices

    pastedimage1648778755821v1.png

    I also checked the standard code of these two API pages, and it doesn't seem to have any conditional filters.

    pastedimage1648778841076v2.png

    pastedimage1648778851922v3.png

    But there is one thing to note, the table used by salesInvoices is table 5475 "Sales Invoice Entity Aggregate". You can open it directly in the browser to see if the data inside is only 10 records.

    pastedimage1648778978636v4.png

    pastedimage1648778990926v5.png

    pastedimage1648778999572v6.png

    Hope this will help.

    Thanks.

    ZHU

  • proceed-it-solutions Profile Picture
    proceed-it-solutions 55 on at

    Hi,

    I have the same issue that there are sales invoices missing on fetching /salesInvoices.

    The missing posted invoices are also not present in the table "Sales Invoice Entity Aggregate".

    Any idea how can it still be achieved?

    Thanks.

    Jeffrey

  • Suggested answer
    proceed-it-solutions Profile Picture
    proceed-it-solutions 55 on at

    Hi,

    I have found the solution to fix the missing records

    Go to the 'API Setup' and run the action 'Integrate APIs', thats all

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans