Forum Discussion

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

Cloud API 2025.11 incomplete retrieval of sales invoices entered in advance

We provide reporting services to a high-volume client in the food industry, providing meals to elderly clients. To manage the Christmas shutdown, orders are placed by (or on behalf of) these clients ...
  • Mike_James's avatar
    Mike_James
    3 months ago

    After further research I have concluded that providing x date or date range retrieves the data for exactly that date range. Use of OrderBy when using Top/Skip avoids all the other issues. This should be made clear in the API documentation for those like me who have not learned this lesson already.

Mike_James's avatar
Mike_James
Ultimate Cover User
3 months ago

This query was submitted to the API support team, and their answers (so far) are:

  • The theory about the invoice date being treated as entered date is not correct, so this can be ignored.
  • When top/skip are used, OrderBy MUST also be used, eg OrderBy Date asc, UID asc. (My note: the API documentation does not state this). The sequence of parameters should be filter, orderby, top, skip.
    My comment: we rely on the URL per the NextPageLink value. Will this include OrderBy if it appears in the original URL?
  • Querying a local file goes through a very different process with "more stable/consistent ordering characteristics".
  • "MYOB has previously stated that datetime values in Filter clauses are treated as UTC". (My comment: have not seen this as such. Therefore (I assume) to extract an invoice dated "2026-01-16T00:00:00", the filter value would need to be "2026-01-15T23:00:00" from NZ, ie local time less 13 hours.

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.