Browse By Tags

  • Get the Table's name that triggered a Post-Write Event

    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…
  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…
  • Record does not exist in CU_OrderQuoteTracking_bus

    Hello All, I notice a client is getting this error all the time in their Sage 100 CRM Activity log. "Record 0001 does not exist in CU_OrderQuoteTracking_bus", anyone ever see this before? They seem to be having an issue with the orders/quotes in Sage…
  • Sage 100 Workstation Synchronization

    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…
  • Accessing Sage 100c from Java code

    Is it possible to access Sage 100c data from a Java program? Is there a JDBC driver available to connect and get data from Sage 100c?
  • Sy_ActivityLog not showing CompanyCode field.

    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…
  • How to save order with credit card payment data via SData?

    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…
  • internet interruption while updating a workstation. Now it says "workstation synchronization is currently in process". Sage doesn't open.

    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…
  • Hi has anyone set up a hot swap for Sage 100 ?

    I have been asked to setup a Hot swap for my Sage 100 ERP. Has anyone accomplished this ?