• 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.
  • Fetching Alternate Item in query

    Trying to return the corresponding itemno for a given icitem.altset #. Normally, I'd just write a SQL statement such as: select [icitem].[itemno] from [icitem] where [icitem].[altset] but, alset is an integer, and I can't find a column in icitem…
  • How Can I Export and Import a Container

    I am developing a new Sage Intelligence Report for a client and I had to create a new container. I know how to export and import the report. How do I transfer the required container? TIA
  • 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…
  • 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…
  • New Sally Series

    In a couple of days, we'll be releasing our next installment of the Sally Series, this time focusing on the Connector module and how to define your own data sets for your reports. If you haven't yet checked out the first and second series then why not…
  • Cashflow Statements

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