API - filter Purchase & Sales Items by Job Number

Question

Hi there,&nbsp;What would the odata filter be to retrieve purchases and sales items/amounts for a given job number?&nbsp;If tried the following which returns what I'm after but with the addition of sale items for other jobs that are recorded on the same sales invoice."http://localhost:8080/accountright/3b48ceac-b683-42bc-9593-07ec153a4bc6/Sale/Invoice/Service/?`$filter=Lines/any(L:&nbsp;L/Job/Number&nbsp;eq&nbsp;'20B2094')"

powermyobbi · Accepted Answer

chillr&nbsp;&nbsp;This might help you&nbsp;&nbsp;https://myobapi.tumblr.com/post/114000660909/digging-into-odata-myobapi&nbsp;cheersGarry

Forum Discussion

API - filter Purchase & Sales Items by Job Number

1 Reply

Looking for something else?

Related content

Additional Filter Reports

Duplicate Purchase order number

Purchase order number on invoice

Customer Purchase Order Number & Docket Numbers

Managing Job and purchase order numbers

Duplicate invoice and purchase numbers

Purchase Orders - Turn Off Automatic Numbering

Change serial number