Sage 100

Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

Hello! I am building a php eCommerce system for a client, and they would like to have inventory and product data synced from Sage 100 ERP 2016 to the eCommerce store. They were previously using MAS90 when we had first looked into it, but between that…

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…

First of all, this is for Sage 100 ERP (5.00.2.0) and SQL Server 2008 R2 I've been scratching my head. I have a simple code that is triggered at post-write in SO_SalesOrderHeader, i.e. a user hitting "Accept" in Order Entry window to execute. The…

Once every 1-2 weeks or so I have to get in after hours to rebuild sort files, in our old business system a similar process was scheduled to run each night. Does anyone out there have a script or other method that would allow for scheduling a rebuild…