Forum Discussion

Mike_James's avatar
Mike_James
Ultimate Cover User
4 months ago
Solved

Sale/Invoice/Item GET request returns 2 invoices short

In a GET request today, the control count was 404, but only 402 invoice records were received. Repeated with same result.

 

URL: https://arl2.api.myob.com/accountright/<fileID>/Sale/Invoice/Item?$top=400&$filter=Date ge datetime'2025-04-01'

Has anyone had the same experience?

Can MYOB offer an explanation? It's hard to provide accurate sales reports when this happens.

  • Mike_James's avatar
    Mike_James
    4 months ago

    Thanks Doreen_P​ . I've already done that. I posted here to see if any other developers have had this experience, and get their responses. 

    I also exported all the item invoices to a file, extracted the invoice numbers and compared them with a list of invoice numbers taken from the JSON files included in the API response. Since there were 403 in each set, I concluded that no other invoice is missing from the response.

3 Replies

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    4 months ago

    Partial answer. Since I knew one of the missing invoices, I edited it, added a full-stop in the comment field and voila! the invoice appeared in the next JSON response. But the other one??

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    4 months ago

    Thanks Doreen_P​ . I've already done that. I posted here to see if any other developers have had this experience, and get their responses. 

    I also exported all the item invoices to a file, extracted the invoice numbers and compared them with a list of invoice numbers taken from the JSON files included in the API response. Since there were 403 in each set, I concluded that no other invoice is missing from the response.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content