Browse By Tags

  • Multiple Folders pointing to single SQL database

    Hi I have a customer with a v12 installation with multiple folders (SEED, PILOT, X3). Every folder is somehow pointed to the PILOT data. I have checked SQL, and the normal SEED data is present,. If I add record in any folder, it is reflected in all…
  • Sage 100 Premium 2020 SQL Server Transactional Replication for Reporting

    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…
  • Call WS

    Hi! I'm trying to call an web service using Visual Basic in a spreadsheet but it returns me an error: xsi:type="xsd:int">0</traceRequestSize></technicalInfos></runReturn></wss:runResponse><multiRef id="id0" soapenc:root="0" soapenv:encodingStyle=…
  • How do I use crystal reports for sage to connect with sage Premium 100 so I can create my own reports?

    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…
  • 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…
  • 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 ?
  • Why using ADO DB connection is much slower if run directly by MAS?

    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…