Web Services Filter Returns First Record in Table

chrisgrill3

I have run into this a few times and have not found a solution. Sometimes when accessing data exposed as a web service and filtering the records, the first record in the table is returned even though it does not match the filter. When this happens it is the only record returned as well. It does not always happen, in fact most of the time the correct Sales Header for example is returned. But sometimes NAV does not like the filter or something and instead of not returning anything, it returns the first Sales Header in the table. Anyone else experience this?

kine

Check, that you are not filtering on calculated fields. Webservices doesn'tlike it... ;-)