Problem upgrading Container General Ledger Transactions S300 SQL(C117-0-1) to Sage Intelligence 8.0

Suggested

Hello,

I have found a problem with upgrading Sage to a version which uses Sage Intelligence 8.0. I went to make a minor change to the container to add the GLJEH table to get the entry description. I started to get errors when running the check/test all expressions. I walked the issue back and took a stock version of the General Ledger -Transactions by Account report, which uses this container, General Ledger Transactions S300 SQL(C117-0-1). I exported it off a v2023 version and imported it onto a v2026. Merely moving the stock report. I then opened the container and without making any changes, I ran the Check/Test All Expressions function and it passed. I opened the container and added a single space to the end of the line

 ON [GLAMF].[ACCTID] =[GLPOST].[ACCTID] AND [GLAMF].[AUDTORG] = [GLPOST].[AUDTORG])

Upon applying my minor change, I ran the Check/Test All Expressions function again and it failed. 

  • 0
    Suggested

    All the supported versions of Sage 300 (2026, 2025, 2024) use Sage Intelligence (Intelligence Reporting) 8.0 and all the standard reports should work fine. I'll let someone who customizes these reports comment on your inquiry. Perhaps you should run the same standard report from 2026 and see if it gives you any issues.