Sage 100

2019 Advanced - Sales order history detail has extended into a second partition and MS Access now gets the message "Cannot open Database" when trying to link or import the table. It may not be a database that your application recognizes, or the file…

Is there a way to restrict access to standard report settings while allowing employees access to custom settings? We recently upgraded to 2018 and use the Job Cost Module. The Job transaction detail report is something we use frequently but since we upgraded…

I'm trying to set my scripts to be able to search the tracking number when they click the hyperlink, but for some reason I don't get the value I get the name of the UDF, but not what I put in there. Anyone has idea how to do it? please help ' Create…

I'm doing a Pass Through Query using Microsoft Access, the SQL statement below works fast and fine. Is there a way to request the date parameters from the user in the WHERE statement each time the query is run instead of the parameters being hard coded…

I am trying to create a Crystal Report that unites the data from SO_InvoiceHeader + SO_InvoiceDetail to AR_InvoiceHistoryHeader + AR_InvoiceHistoryDetail. I believe the best way is to use a Union Query in Access and so I have created 1 Query for each…