• AR Aging Reports in BI are Cutting Off by Doc Date, Possible by Posting Date?

    I have a client wanting to use the free BI reports provided by Sage called the Customer Aged Trial Balance S300-SQL(C4-0-5) or the Detailed AR Aged Trial Balance S300-SQL(C133-0-4) Unfortunately, both aging reports cut off by Doc Date and for…
  • 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…
  • Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ?

    Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ? We are trying to get information from Microsoft Excel data to be use in the integration of ODBC Driver SQL Server of Sage Accpac…
  • Sage 300 2014 Intelligence Report getting an sa login failure

    Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.
  • Post OE SH Invoice

    Dear all i wrote a macro in order entry module the macro doing order entry and ship all when post the OE transaction in Macro its make OE, invoice and shipment automatically but the problem sometimes its make order entry only i must restart the server…
  • RE: recommended report writer for Sage 300

    Hi there. To follow on from Ettienne, Sage Intelligence for 300 includes a number of out-the-box financial and operational reports and provides the ability to design reports, with options for beginner users through to advanced users, in the familiar…
  • How do you produce effective, multi-currency financial statements?

    How do you produce effective, multi-currency financial statements?