Hi All,
I want to get only the specific invoice by DocumentNumber in Sage.CA.SBS.ERP.Sage300.AP.WebApi.Models.Invoice, but failed.
I try to use the $Filter field => DocumentNumber eq 'IN00000000000000000031' but I just got error
Hi All,
I want to get only the specific invoice by DocumentNumber in Sage.CA.SBS.ERP.Sage300.AP.WebApi.Models.Invoice, but failed.
I try to use the $Filter field => DocumentNumber eq 'IN00000000000000000031' but I just got error
You can't. The issue is that the filter will work on the entity which is the batch. DocumentNumber is a field on the invoice. I have tried doing subqueries, and the OData protocol seems to support it but I have not found a way to query Sage based on a field in a sub-entity.
Noted. Then I will have to read all the invoices and filter it myself.
*Community Hub is the new name for Sage City