x Want to participate? Join the group to interact

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

  • Creating an AP aging dashboard in Intelligence Reporting

    I wish to create a AP aging dashboard in the Intelligence Reporting module. The issue is the table "APAGED" is only populated when the A/P aging report is run for all vendors. Hence if the report was run for one vendor that is what you will get when…

  • Sales report

    I am trying to generate a monthly sales report pulling sales, cogs and gross profit. I thought is was all working fine, but now I see that in some cases credit notes for price adjustments are showing a cost adj also in "line cost" field. The information…

*Community Hub is the new name for Sage City