• 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…
  • Sage 300 2024 Encountered Error Code: 5 during FR Financial Statements Printing

    Hi, Did anyone encountered the same error code when print Financial Statements in Sage 300 2024? After clicked OK button, the report still works fine. Why is there an error code shown after click Preview button? Client is using Microsoft Excel…
  • 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?
  • SQL Login failed error in Crystal Reports

    We just upgraded a client to Sage 300 2023 on their existing server. After the upgrade, printing their customized PO form prompts to enter SQL name and password. Even when I enter the correct credentials, it fails with "login failed" message. I thought…
  • 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…
  • Sage Intelligence Reporting - Need currency conversion rate in Sales Master Report

    I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…
  • 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.
  • How to change the report format?

    Hi We are using Sage 2017 version, Please advise how to change the report format. All report comes with the name who left our company. Our sage cannot be opened via web browser (becouse of no cloud version?) and ther are no "setting" botton on my…
  • 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:
  • PO not coming over to receive and automatically closing after partial receive.

    Hi guys, I am having an issue where my PO's are not coming over in Receipt entry as well as POs are being closed after being partially received Any suggestions as what could be causing this and/or how to resolve this issue?
  • 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…
  • 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.