Browse By Tags

  • Creating AR Aging in Sage Intelligence Sage 100 Advanced

    We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…

  • Sage 50 US Intelligence Reporting V2020 - Employee SSN

    I have several custom reports created that pull in employee SSN. After installing 2020, the values returned for employee SSN are scrambled. I am assuming this data is now encrypted... but not sure. Tech support is no help. None of the agents even have…

  • SQL Password Prompts in -some- custom reports and intermittently Sage Inteligence

    Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…

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

  • Projects - Intelligence Reporting

    I want to be able to print a report of all the projects that have outstanding balance - basically an A/R report for projects. Is this something that can be done with the Intelligence Reporting software?

*Community Hub is the new name for Sage City