x Want to participate? Join the group to interact

  • Why isn't TRIM() working?

  • Creating date "buckets"

    I am looking to create some buckets of dates in Sage intelligence. I am very new to Sage Intelligence, so please help me understand. I started by creating a view in SQL (I was planning on creating a view for each bucket and then combining the views…

  • SQL Expression to query Optional Field value from APIBDO Table

    Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…

  • SQL Query for Vendor Balances

    Hi, I am trying to get Accounts Payable / AP Transactions Report/ Aged Payable (summary) report from SQL query. I have done something and get report with query below, but there are minor differencies which realized that those differencies are becouse…

*Community Hub is the new name for Sage City