Sage 100

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

Hello! I am trying to create an order completely with SData and Paya. I have no problems with it when I am trying to create an order with PaymentType = Check. Here is the XML for such example: <entry xmlns:atom=" ">http://www.w3.org/2005/Atom…

I need to link these 2 tables in order to see a report of user roles and related tasks. But there doesn't seem to be a clear link. The SY_RoleSecurity table has key field called TaskKey which ha values of 9 characters, whereas the SY_Tasks table has a…

Hello, Received a notification for a Payroll Update, so I ran the update, but when completed, gives error "File 'PR_PayrollCycle' not found". I did this both on server and client workstation and same result. There is no file permission issues, and…

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

Hello All, My support contract ends 1/29/2015. I don't plan on renewing it unless I really need an important upgrade at some point. Should I upgrade my Sage to 2014 before the end of the month? Are there major benefits to upgrading to 2014? Thanks for…

We just upgraded to Sage 100 ERP from Mas 200 and I got this error this morning. I'm not familiar with it. I've looked through a few areas for help, but haven't found any solution thus far. I'm hopeful that someone has run across this issue before.