When posting to /salesOrders with payload {"customerNumber": "1010117"}, I get an error:
Internal_InvalidTableRelation","message":"The field Sell-to Customer No. of table Sales Order Entity Buffer contains a value (1010117) that cannot be found in the related table (Customer)
But I can fetch the customer with:
/customers?$filter=number eq '1010117'
Similar error occurs when attempting to create the Order with customerId. However, a sales order can be manually created for the customer via the UI.
What could be the reasons for this error?