x Want to participate? Join the group to interact

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

  • Tables linking Sales Order Number and Customer Number

    The SO_SalesOrderDetail has just about every field I need except the customer number. What other table can I use to link them and report this field in Sage Intelligence 100? I am using Microsoft Query.

  • UNION Query SAGE 100 (MAS90)

    Does the Connector support UNION Queries for Sage 100 Data? Have a simple UNION that just doesn't seem to work. See sample below: Select JT_Transaction.SalesOrderNo as 'SalesOrderNo' , JT_Transaction.TotalCost+JT_Transaction.TotalLaborCost…

*Community Hub is the new name for Sage City