How to get balaned invoice via REST API?

Hi,

I’m using the REST API to retrieve data from our Acumatica instance. So far, things worked fine, but now I have the issue that the Invoice endpoint does not return invoices with a status of “Balanced”.

For example:

Invoice VR00000520 has status Open

Invoice VR00000521 has status Balanced

When I do the following GET request..

/entity/Default/24.200.001/Invoice?$filter=ReferenceNbr eq 'VR00000520'

..I get a proper response with the invoice data.

However, when I do the following GET request..

/entity/Default/24.200.001/Invoice?$filter=ReferenceNbr eq 'VR00000521'

..I get an empty response.

I tried to query the Invoices endpoint only by status. This works for the Open status, such as:

/entity/Default/24.200.001/Invoice?$filter=Status eq 'Open'

..but it does not work for the Balanced status (the response is empty), such as:

/entity/Default/24.200.001/Invoice?$filter=Status eq 'Balanced'

What do I need to do to access also the invoices with status “Balanced”?

Thank you

Mathias