JuiceyBrucey wrote:Are all returning the same data.
Nah - just the /Queries/SalesOrderList and Queries/SO_Main are reporting of the same underlying data. Queries/SO_Main is just the SO_Main table, /Queries/SalesOrderList joins in a few other tables (such as DB_Main to get the debtor name).
Queries/SalesQuoteList is giving you quotes - from the QO_Main table - it just looks remarkably similar - and what doesn't help is our quote table has fields like InvoiceId and InvoiceNo, which might trick you into thinking they are sales orders.
Compare the two results:
https://api.jiwa.com.au/Queries/SalesOr ... =InvoiceNohttps://api.jiwa.com.au/Queries/SalesQu ... =InvoiceNoLook closely at the Invoice Id and also the debtor for each - they are different.