Announcements
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?
Hi,
I have found the solution to fix the missing records
Go to the 'API Setup' and run the action 'Integrate APIs', thats all
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
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
I also checked the standard code of these two API pages, and it doesn't seem to have any conditional filters.
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.
Hope this will help.
Thanks.
ZHU
#1
Sohail Ahmed
1,452
#2
YUN ZHU
1,313
Super User 2025 Season 1
#3
Gerardo RenterÃa Ga...
1,083
Most Valuable Professional
Share
Report
All responses (
Answers (
