Skip to main content
Solved

How to get balaned invoice via REST API?

  • January 15, 2026
  • 7 replies
  • 43 views
M
Freshman I

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

Best answer by Dmitrii Naumov

​@mathias I think you’ll need to use SalesInvoice entity instead of invoice. Your invoices are probably created from SO module, so they need to be viewed through SO module entities.

    7 replies

    DipakNilkanth
    Pro III
    Forum|alt.badge.img+14

    Hi ​@mathias, 

    I tested the same endpoint by fetching a Balanced invoice, and I’m able to retrieve the record successfully when filtering by both Status and Reference Number.
     

    Fetch through Balanced Status

     

    Fetch through Ref Nbr

    Could you please confirm whether you are able to view this same invoice in the Acumatica UI using the same user account that you are using to authenticate the API request?

     

    Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
      M
      Freshman I
      • mathias
      • Author
      • Freshman I
      • January 15, 2026

      Hi Dipak,

      Thanks for your quick reply, very much appreciated.

      Yes, I can confirm that I can see the invoice in the UI, but cannot retrieve it by REST API.

      UI:

      REST API:

       

      The user that I used to authenticate for the REST request is the same user as in the UI.

      If I change the status of the invoice to “Open” by releasing the invoice, then I can retrieve the invoice via REST API successfully:

      UI - with status changed to Open:

      REST API:

      Is there maybe a server-side configuration that is telling the API to filter invoices with status ‘Balanced’?

      Thank you

      Mathias

      D
      Captain II
      Forum|alt.badge.img+8
      • Django
      • Captain II
      • January 15, 2026

      Can you try including the Type field in your request:

      /entity/Default/24.200.001/Invoice?$filter=Status eq 'Balanced' and Type eq ‘Invoice’

        Dmitrii Naumov
        Acumatica Moderator
        Forum|alt.badge.img+7
        • Dmitrii Naumov
        • Acumatica Moderator
        • Answer
        • January 15, 2026

        ​@mathias I think you’ll need to use SalesInvoice entity instead of invoice. Your invoices are probably created from SO module, so they need to be viewed through SO module entities.

          M
          Freshman I
          • mathias
          • Author
          • Freshman I
          • January 15, 2026

          Can you try including the Type field in your request:

          /entity/Default/24.200.001/Invoice?$filter=Status eq 'Balanced' and Type eq ‘Invoice’

          Thank you Django, this did not work, unfortunately.

            M
            Freshman I
            • mathias
            • Author
            • Freshman I
            • January 15, 2026

            ​@mathias I think you’ll need to use SalesInvoice entity instead of invoice. Your invoices are probably created from SO module, so they need to be viewed through SO module entities.

            Many thanks Dmitrii, this did the trick. Thank you so much, you safed me a lot of time!

              F
              Freshman I
              Forum|alt.badge.img
              • FarhanaM60
              • Freshman I
              • January 20, 2026

              Run this query to see the real REST value:
              GET /entity/Default/24.200.001/Invoice?$filter=ReferenceNbr eq 'VR00000521'&$select=ReferenceNbr,Status
              If still empty → it’s not an AR Invoice record.
               

              To access invoices with status “Balanced”, you need to:

               Use the correct endpoint for that document type (very likely AP Bill, not AR Invoice), OR
               Filter using the actual REST status value, not the UI label “Balanced”.

                Terms & ConditionsCookie settingsAccessibility statement
                About Acumatica ERP system
                Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
                © 2008 — 2024  Acumatica, Inc. All rights reserved