Browse By Tags

  • ALERT: SQL Server PowerShell module

    Important alert: Do not use SQL Server module version 22.x with Sage X3 until further notice. Use SQL Server 21.1.18256 only. PowerShell 7.2+ is a prerequisite for Sage X3, along with the SQL Server module for PowerShell. SQL Server module version 22…
  • How can I find the SQL execution plan for a custom view in SQL Server Management Studio?

    How can I find the SQL execution plan for a custom view in SQL Server Management Studio?

    You may have created some custom views in your Sage X3 system but are finding them slow to execute. The first step in diagnosing poorly performing SQL is often checking the SQL execution plan, but how can you do this with Sage X3 custom views? First…

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

  • Looking to build a report for Sales by GLCode by month

    Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

  • Consolidated billing query with AR_InvoiceHistoryDetail

    We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…

  • non MAS database on MAS server? (Sage 100c SQL)

    Sage 100c 2018 SQL server I want to add a database to my production Sage 100 Server instance. Will this cause any issues with Sage 100? I may also be able to use a linked server, but I'm not familiar with the limitations there, either.

  • Changing a Checkbox to a Selection list

    Checkbox fields are brilliant for letting a user quickly collect certain types of data. But they do have their limitations and you may discover that you want to be able to store answers such as 'Y' (Yes), 'N' (No), 'M' (Maybe) rather than a simple 'check…

*Community Hub is the new name for Sage City