Ideas for Acumatica

Important! Please note that we do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive.
This portal is for product ideas and feedback only. If you need customer service assistance, please contact your Acumatica Support Partner or submit a support case.  You can also get assistance from community resources:  LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal. 

support OR condition in REST API - StockItem

Acumatica REST API - StockItem when used with multiple product id in single request is not working for us.

We tried the request Url$filter=InventoryID eq '000032-000' or InventoryID eq '000042-000'' or InventoryID eq '135780'&$expand=WarehouseDetails

we are getting the error 


    "message": "An error has occurred.",

    "exceptionMessage": "Syntax error at position 85 in 'InventoryID eq '000032-000' or InventoryID eq '000042-000'' or InventoryID eq '135780''.",

    "exceptionType": "Microsoft.Data.OData.ODataException",

    "stackTrace": "   at Microsoft.Data.OData.Query.ExpressionLexer.ValidateToken(ExpressionTokenKind t)\r\n   at Microsoft.Data.OData.Query.UriQueryExpressionParser.ParseFilter(String filter)\r\n   at 


ORData Framework supports OR condition , we suggest Acumatica can support OR condition in StockItem API

  • Guest
  • Jun 25 2019
  • Attach files