Sage 100

We are using SQL Linked servers and are receiving the error [ProvideX][ODBC Driver][PVKIO]Invalid segment number in one company (JAN). We are getting this error when doing a Select * From GL_DetailPosting. (Other tables work without error.) We can get…

Hello, I am new to the world of Sage ERP. I have designed this query and it works fine in SQL: SELECT o1.*, ( Select isnull(SUM(D002_DollarsRented)+SUM(DollarsSold),0) FROM openquery(TESTSWRMAS, 'select * from AR_CustomerSalesHistory') o2 WHERE…