• Sage 300 2024 - FR Web Screens

    Hi, I have just set the Sage 300 2024 up and using SAMINC we are testing new features for suitability for a client upgrade. When testing I am getting errors when running via the FR Web, the FR on the desktop however is working fine. Sage 300 2024…
  • AP vendor transaction report preview

    How can I filter AP vendor transaction report to get actual result with GL transaction report.
  • How can I configure/place custom reports for web screen?

    I have several custom reports (crystal reports). Now I want these reports to be also accessible via web screen. Which directory should I put my reports?
  • What is the proper report to use to view orders invoiced but not shipped?

    What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help! Thanks in advance.
  • Sage 300 Intelligence reporting

    When using Sage 300 webscreens, is there a way to run Intelligence reporting with installing Sage 300 desktop version.
  • Period 13 and Period 14 in Sage Business Intelligence

    Hello everyone, I need to report Period 13 and the adjustment period (Period 14) on a financial report in Sage Business Intelligence from Sage 300 GL. Is that possible? Any Advice would be greatly appreciated Dana
  • Log or Audit Trail of Recently Run Sage Intelligence Reports - Tracking report usage

    Hello, I have a client with over 160 customized Sage Intelligence reports. They know that some of these reports have not been used by their 200+ users in a long time. Their IT staff is looking to streamline which reports will need testing as they move…
  • error occurred when attempting to retired lookup data: SQLState=08001 not possible to connect to database

    i receive this error when I run out a report from BI viewer and select the tilde to lookup and select the years to be included in the report. Troubleshooting so far: - works from another workstation in the same building can not see any thing different…
  • Is there a way to run a report from Sage 300 that shows ALL unique vendor numbers and transactions for a given period at the G/L level across all entities?

    Report might look like this: Fiscal year: Fiscal period: Due date: Vendor Number: Order no: BS GL code (Header): Expense GL (line): Transaction currency: Gross amount: Tax amount: Net amount:
  • Consolidated Designer

    I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…
  • Designer License Required in Standard Templates

    Hi All, We have the designer license in place (shows YES in the license manager) yet standard reports fail to generate data and appears as "Designer License Required" instead. Sage 300 2018 PU1 Screenshots attached. Any issue with our licenses?
  • Office 2016 and Business Intelligence reports

    Good morning So i have been using the Excel 2016 for a few months..maybe a year, to run my Business Intelligence Reports. I am now unable to run anymore reports as i keep getting an error in excel. The excel keeps disabling the BI Tools add-in and…
  • BI Reporting Manager Error

    Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…
  • Cashflow Statements

    Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.