• How to use sage intelligence reporting with optional fields?

    I want to spool sage intelligence report using optional fields that I created on General ledger instead of using General ledger account or General ledger account segments on sage 300. /resized-image/__size/640x480/__key/communityserver-discussions-components…
  • Wanted, Crystal Report Designer - Sage 300 ERP 2023 web Uis

    Hello everyone, I need a crystal report programmer to assist with designing a AR customer statement with following output: 1. Opening balance on account at every point in time the report is printed ie yearly or monthly, 2. outstanding invoices unpaid…
  • 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.
  • Welcome to the Sage Data & Analytics for Sage 300 forum

    Welcome to the Sage Data & Analytics (SD&A) for Sage 300 Sage City forum! SD&A is a cloud-based business intelligence solution that can be integrated with Sage 300 to equip users with on-the-go access to their data. In this forum you can ask & answer…
  • 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…
  • Row Edit Query

    I am creating a customized report on sage 300C webscreens intelligence reporting. After selecting a set of rows, when i edit a row it couldn't be save or proceed further. So i have to close the report.
  • Sage 300 Intelligence Reporting module :- Run-time error '13':Type Mismatch

    We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…
  • Sage Intelligence Intermediate Reporting class coming soon

    Are you ready to start using Sage Intelligence Reporting to create your own reports? The next Intermediate course is scheduled for May 17. Click here for more information. It is recommended that you view the Beginner Anytime Learning topic first.
  • Show Optional Field Data to Report

    FormerMember
    FormerMember
    I've set a few criteria in optional field in Order Entry module, user will insert their data to each of the created optional field, now how can i show Optional Field data which have a few lines to reporting? It should showing all Order Confirmation although…
  • Sage 300 Intelligence Reporting: Report Utility

    Get immediate access to a library of additional reports As your business evolves and grows, so too do your reporting needs. We understand that it’s not always realistic to wait for the next Sage Intelligence update to get your hands on the reports that…
  • 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…
  • Not a valid Crystal Report

    After upgrading to Version 14.1, some of our systems will not print Crystal Reports. When attempting to print we get the following error message. We have attempted to perform the suggested Resolution on KB 55371 with no results. Anyone have any ideas…
  • Financial Reporting (Installation v5.4a)

    Hello, I am trying to install Financial Reporting for one of our users but am unable to locate the steps to do so. Can someone help me get this installed? Thanks -J
  • Intelligence Reporter

    I have attached a screen shot of my Report Manager UI. I am on Sage 300 2014 PU 3. The panels on the screen are mixed up. Has anyone seen this behaviour? Thanks
  • Re: Partial Information not show

    Hello. I am writing a BS report based on prior one column(current BS) template. I add 3 columns to insert last year balance, Variance and % of Variance. after i am done, i audit the template by using PR View. Audit did not inform any error, However the…
  • Sage 300 ERP 2014 Intelligence Reporting - Resources

    Download the Sage 300 ERP 2014 Intelligence Reporting Kick off document. http://www.alchemex.org/FTPBICommunity/Kick_off_with_Sage_300_ERP_Intelligence_Reporting.pdf