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,316 Super User 2025 Season 2 on at

Like (1)

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

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

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

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 92,576 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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

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