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?

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

  • Creating a custom report incorporating Customer Maintenance and Item Maintenance info

    Hello, I am trying to create a custom report that would show customer details relating to items sold. I am looking to include: Customer Name and associated purchase history of a given item #, item description, standard cost, standard price,…

*Community Hub is the new name for Sage City