• 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?
  • Sage 300 business intelligence reporting trees

    We have created a report using the trees - which works Now we have another scenaria with organic and non organic stores - the problem here is organic can consist of dept 11, 22,23,30 etc Non organic 12,18,32,etc How can I drag all the trees into…
  • Intelligence Consilidated fiscal year parameter options missing a year

    For consolidated financials, how does the pop up box to choose the year determine which years to pull? We have a consolidated report that runs about 10 companies. One of those companies is currently in fiscal year 2024, where as the rest are calendar…
  • 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.
  • Creating date "buckets"

    I am looking to create some buckets of dates in Sage intelligence. I am very new to Sage Intelligence, so please help me understand. I started by creating a view in SQL (I was planning on creating a view for each bucket and then combining the views…
  • 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.
  • 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:
  • How do I get table AROBLJO into a Container in Intelligence?

  • Error Number :[ 52]

    Hi All, I recently upgrade Sage 300 to Version 2018. However, the Business which works before the upgrade is now a giving this error. Any ideas on how to resolve. Let me know.
  • 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…
  • Cashflow Statements

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

    I just attempted a Sales Report and received a warning about exceeding the 65K row limit. I am using Excel 2013 so that is not a limit from Excel. Is there something I need to do to get around this limitation?
  • 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…