Sage 100

Hello, I have a bunch of custom scripts that get triggered Post-Write on different tables, for example, sales order, item, alias, etc. Only one script would not trigger, and I can't find why. The script should trigger Post-Write on the table IM_ItemWarehouse…

Hello, We have a custom-defined script that triggers Post-Write on the table CI_Item. This script then reads the field 'ItemCode' of that table. We also want to extend this by triggering this script with other tables. I am seeking a way to retrieve…

Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…

I'm pulling data from across several Sage companies into a postgreq db to do some reporting on sales trends. What is the difference between ar_invoice_header (psuedo) and ar_invoice_header_history? ..and if you can tell me, at what point do they move…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

It appears that the process that is used to synchronize the workstation synchronization is no longer an app that can be run to update components after product updates are installed. Instead a vb script is run from a temporary folder. The problem is…

There are many duplicate, no longer used, incorrect, etc part numbers in our system. We need to get rid of these errors, the problem is that some of them have "history" from years ago (2015, 2016) and are parts we no longer use. The system will not allow…

We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…

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…

My internet connection was interrupted while updating my workstation (a laptop) to the latest version. It was updated in the server by our IT guy. Now, my laptop sage keeps saying "workstation synchronization is currently in process" when I try to open…

We created a UDF and used it for a few days and then decided to delete it. The deleted UDF still shows in one company's AR_InvoiceHistoryHeader table; however, the UDF does not show up as a field in any other company. What's the best way to delete…

I drilled into the LOCK folder for my company code to see what was listed. I see 65 items in the folder, some of which are dated today and some that are many months old (and many in between). Is there any type of housekeeping that needs to be done on…

Hello! Is it possible to retrieve the sales order header with its details together in one HTTP GET request, like this URL below? http://localhost/SData/MasApp/MasContract/ABC/SO_SalesOrderHeader?include=SO_SalesOrderDetail When I tried the URL above…

Hello everyone! 2 years ago my company built a very powerful implementation of e-commerce store that integrated with Sage 100 ERP via both Sage e-Business Web Services and SData. As I said after that 2 years gone. Now I am interested are those technologies…

I am new to dealing with Sage, and out of 25 users, one user keeps getting the same warning message over and over again. I have read through the many posts and I have not found any with the same problem. I have uninstalled and re-installed Sage to try…

Error occurs on any report after upgrading to 2013 from 4.4 on 64 bit workstations This occurs only on 64 bit WS and with is related to some new permission issues on server2012 where the drivers don't get written to the registry unless you run wksetup…