Small and medium business | Business Central, N...

problem in 'gt' filter while get invoices from business central API

(1) Share

Report

Posted on by Community member

Hello Experts,

It's been 3 days where I am facing one issue in API URL while using /gt/ filter when my invoice records started greater than 99999 invoice number.

https:/api.businesscentral.dynamics.com/v2.0/Production/api/v1.0/companies(86402545-a58c-eb11-8ce5-0022489a59b2)/salesInvoices?$filter=number gt '102630'

Only one invoice 102631 is created after 102630 but when I executed a URL I got old invoice lists which was not even grated than 102630.

Does anyone know what's the problem here?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Mohamed Amine Mahmoudi 26,767 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

try to remove the quotes on number value

number gt 102630

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Community member 76 on at

Like (1)

Report
Copy link

Link copied!

Hi @Mohamed Amine Mahmoudi,

still, it's not working.

@Experts, kindly revert me if anyone know the solution.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,376 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps.

My Test endpoint:

https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox234/api/v2.0/companies(5c0ad51d-41bc-ee11-907c-6045bdacdef8)/salesInvoices?$filter=number gt '102198'

Thanks.

ZHU

Was this reply helpful? Yes No
Community member 76 on at

Like (0)

Report
Copy link

Link copied!

Hello YUN ZHU,

I tried to use tenant id in API URL same as you provide below but still it's not working in my case.

and its strange that 'gt' filet only not working with this customer account but we have other customer accounts where it's working properly.

Do you think is it happened because of some changes has been done in BC by that customer?

Was this reply helpful? Yes No