Browse By Tags

  • 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…
  • Where is the Sage Intelligence workstation setup install registry key?

    There was a scenario that the client didn't uninstall Sage Intelligence workstation setup before their old server was already offline with the new server in place. When the client tried to uninstall Sage Intelligence workstation setup, the program was…
  • AR Aging Reports in BI are Cutting Off by Doc Date, Possible by Posting Date?

    I have a client wanting to use the free BI reports provided by Sage called the Customer Aged Trial Balance S300-SQL(C4-0-5) or the Detailed AR Aged Trial Balance S300-SQL(C133-0-4) Unfortunately, both aging reports cut off by Doc Date and for…
  • 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:
  • Sage 300 I Sage 300 Intelligence Training I October-December 2019 Training Schedule

    New to Sage Intelligence? Or want to take your reporting to the next level? We have the right Sage Intelligence Reporting course for you. Sage Intelligence: Beginner Sage Intelligence: Intermediate Sage Intelligence…
  • New to Sage Intelligence? Or want to take your reporting to the next level?

    Sage Intelligence: Beginner Sage Intelligence: Intermediate Sage Intelligence: Advanced Sage Intelligence: Financials Ready to get started with Sage Intelligence? This Anytime Learning package will…
  • Sage 300 2017 Business Intelligence - Missing Accounts Tool

    I'm having an issue when running the missing accounts tool. On one report I've built, the tool will only show missing balance sheet accounts even though I know for certain there are missing income statement accounts. I even went so far as to build one…
  • 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…
  • Check out our Sage 300 training summer promotion and save 20%

    You already own great business software, but are you truly taking advantage of all it has to offer? Make a splash with your productivity this summer by enrolling in our Sage 300 Training, now available at a special 20% discount Financials…
  • 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?
  • Sage Intelligence Report - Sales by Ship-to State

    I need to total my Sage Intelligence Report by the state of the ship-to address. What table(s) do I need to link to Sales Master 3-0 data container.
  • Sage 300 ERP: What's New - January 2015

    Welcome to 2015! You are looking at the second blog in the What’s New series, and this is your place to find important enhancements, new releases and updates for Sage 300 ERP. Let’s make this an awesome year for staying on top of all things Sage 300 ERP…