x Want to participate? Join the group to interact

  • Pass through variable "Last full month"

    What is the sql statement needed to get the last full month for a pass-through variable. Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month. As always thanks in advance for your assistance…

  • Sage 100 2019 Sage Intelligence. Company name or code for multi-company reports.

    Sage 100 2019 Sage Intelligence. How do I add company code from the SYO_Company table to my joins? In Crystal we would use "Not Equal" as a join for company name. In SI, Connector, there is only Right Join, Inner, and Outer. How do I get the company name…

  • Payroll Data Missing in Microsoft Query Sage Intelligence 100

    I am pulling from the table used in the PR_EarningsReport but not all fields are being populated in my query. For example, I can get Employee Number but not First and Last Name?

  • Is there a way to pull data from a specific source code, like AP or AR?

    We are looking for a way to separate our YE AJE's. It was suggested to us to use a source code named AJ. We'd like to create a set of financials that shows the unadjusted trial balance, then the AJE's, and then the final balances. So, my question is…

*Community Hub is the new name for Sage City