• 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…
  • customer pricing best practices for many customers

    We have many customers that require we treat their various ship tos as bill to's. So, despite the customer locations having a common owner, the billing and account maintenance of each location must be treated as it's own entity. Since MAS90 (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…