Forum Discussion

chillr's avatar
5 years ago

API - filter Purchase & Sales Items by Job Number

Hi there,

 

What would the odata filter be to retrieve purchases and sales items/amounts for a given job number?

 

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: L/Job/Number eq '20B2094')"