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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

API: SalesInvoice missing records

(0) ShareShare
ReportReport
Posted on by 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?

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    101,995 Super User 2026 Season 1 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
    65 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
    65 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,028 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,366 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,175 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans