• 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…
  • MAS 90 Providex to SQL Conversion / Archive Reporting purposes

    FormerMember
    FormerMember
    Hello, I am completely new to this. I am a SQL DBA and I have been asked to take our OLD MAS90 system convert the data to SQL and write reports to allow accounting people to find data from our old system. We currently use MS Dynamics NAV. We switched…
  • What's the latest build of SQL Server that you're safely using with Sage 100 Premium?

    Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…
  • Datetime fields ALL no longer allow nulls

    We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…