Erp.BO.SalesOrderService/OrderMscs service (Using Swagger) returns 0 records when I’ve only specified $top to be 10. I’d expect to get things back that are in the OrderMsc table (of which there are many).
Erp.BO.MiscShipSvc/MiscShips is stranger. While most of the data I get from the REST service matches what I’m seeing in the test EPICOR environment, this service returns a record where PAckNum eq 10000 but no records where PackNum eq 186556. However in the SQL Server:
SELECT TOP 10 * FROM [Epicor10TST].[Erp].[ShipMisc] where PackNum = 186556
– works, but no data in REST interface
SELECT TOP 10 * FROM [Epicor10TST].[Erp].[ShipMisc] where PackNum = 10000
– doesn’t work, but has data in REST interface
Are there bad or missing Views? What am I missing?