Skip to content

x Want to ask a question or reply? Click here to join the group.
  • State Not Answered
  • Replies 3 replies
  • Subscribers 99 subscribers
  • Views 1144 views
  • Users 0 members are here
Browse Forums
Announcements
390
topics
258
replies
Databases and Operating Systems
606
topics
2k
replies
Financials Suite
739
topics
2k
replies
General Discussion
2k
topics
9k
replies
Operational Suite
460
topics
1k
replies
Reporting and Analytics
481
topics
1k
replies
Reports, Macros, Customizations and Developers
609
topics
2k
replies
Sage CRM for Sage 300
101
topics
269
replies

Sage Intelligence - GL Transactions Including Open Balance S300SQL (C166-0-1) not working

Hullois2013
Posted By

Hi,

I just downloaded a SAI report using the Report utility named : GL Transactions Incl OpenBalance S300SQL(C166-0-1).

When I try to run it either at my client site or any of my Sage VM using SAI Viewer or Manager, I always get the same error: "[Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "PLUSBAL.HCAMOUNT" could not be bound."

I do have the Connector license but I'm not sure what to change to get it to work. Anyone has an idea on what to do exactly to fix it ?

Thanks,

Parents
  • 0

    This report runs fine in my SI 8.0 environment without a connector license. Sounds like your SQL may have an issue. Try to look for this message in Google and see if you can find more on this message. No one else has contacted Sage for this error as I cannot find this error listed in our knowledgebase.

  • 0 in reply to JerryL

    Hi Jerry, 

    Thanks for taking the time to answer.  I also tried it with the latest 8.0 and exact same error on a different VM and SQL Server 2022.

    After some digging, the error in related to some multi-currency stuff. When you ran your test, did you ran it against a Multi-Currency Company? I'm running it against a single currency company with a functional currency CAD.

Reply
  • 0 in reply to JerryL

    Hi Jerry, 

    Thanks for taking the time to answer.  I also tried it with the latest 8.0 and exact same error on a different VM and SQL Server 2022.

    After some digging, the error in related to some multi-currency stuff. When you ran your test, did you ran it against a Multi-Currency Company? I'm running it against a single currency company with a functional currency CAD.

Children

*Community Hub is the new name for Sage City