Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello,
After I run a job it shows that all the inserts and updates were failed. Almost all the error message (which I could see in 'Transaction Errors') say that 'Input string was not in a correct format'.
I want to know how can I get to know…
Hello,
I am working on some query and part of the query needs me to select all the records from AR_CustomerSalesHistory table with FiscalYear equivalent to current year. I have tried these and some other combinations:
SELECT * FROM AR_CustomerSalesHistory…
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…
Looking at any views in Explorer for our main company works fine. However, in our test company (which should be a recent copy of our main company), when you click on any view, the screen shows no details and when you close the window, you receive Providex…