Browse By Tags

  • Accounting and financial statements

    If you're looking for an easy introduction to Accounting and Financial statements, take a look at the following set of videos provided by Khan Academy: www.khanacademy.org/.../accounting-and-financial-stateme Then if you'd like to see how this is…
  • Accounting and financial statements

    If you're looking for an easy introduction to Accounting and Financial statements, take a look at the following set of videos provided by Khan Academy: www.khanacademy.org/.../accounting-and-financial-stateme Then if you'd like to see how this is…
  • Accounting and financial statements

    If you're looking for an easy introduction to Accounting and Financial statements, take a look at the following set of videos provided by Khan Academy: www.khanacademy.org/.../accounting-and-financial-stateme Then if you'd like to see how this is…
  • GL Trial Balance and AP Aged Payables report totals do not match

    Hi. I am having a problem getting my GL balance and my AP Aged Payables report totals to match. No matter what combination I enter, due date, document date, period end date; they will not equal. I searched for help on this board with related questions…
  • Workstation "locked" while SI reports run

    A client has 84 companies in their Sage 100 Standard system, which was recently upgraded from v4.50 to v2016. The upgrade was installed on a new Server 2012 and workstations are new Windows 10 units, all exceeding current SPM specs. In Sage Intelligence…
  • Error 462 while attempting to run Sage Intelligence Reports (in Sage 100c 2016)

    I have a client experiencing some errors I have never seen... They are heavy Sage Intelligence users. We just upgraded to Sage 100c 2016 a few weeks ago and since then their Sage Intelligence has been more error prone than I would like... Here is…
  • Connectors

    HI There, When I was at Sage Summit I was told that I could find a list of Table Connectors on Sage City, does anyone know where to find this report? I'm trying to find what connectors match up so that I can run an A/P report with some general ledger…
  • Free five-part video series on reporting: Gearing Up with Sally

    Learn about report creation and how to visualize your data better with this FREE, five-part video series. In Starting Out with Sally , you discovered how to make sense of the numbers behind your business, as Sally led you through practical ways to improve…
  • Free five-part video series on reporting: Gearing Up with Sally

    Learn about report creation and how to visualize your data better with this FREE, five-part video series. In Starting Out with Sally , you discovered how to make sense of the numbers behind your business, as Sally led you through practical ways to improve…
  • Is there a way to include a Date Object in a pass through query in Access....

    Hello All, Below is my pass through query. This is how I extract data from MAS and upload to Axiom to do my P/L reporting. This works flawlessly. The unfortunately part of this query is that I have to open each query and change start & end dates.…
  • RE: Sage MAS 500 - Desktop Enterprise Edition

    Hi Julie. If you're going to be using Sage Intelligence for your reporting then here are some links you can look at: www.sageintelligence.com www.sageintelligence.com/sage-intelligence-tips-tricks www.youtube.com/.../SageIntelligence www.sageintelligencecommunity…
  • Renovo vs Intelligence Reporting/Report Writer

    Sage 100 2014 - Server 2008 I am finally finding acceptance in letting go of Frx. I had to go through all the steps of grief. LOL. I have used FRx since the 90s. But it's time to move on, obviously. I have watched both Youtube presentations of Renovo…
  • GL Trial balance

    Hi, Is there a way to print the GL trial balance as at a particular date in Sage 6.0.
  • Identify the real cost of a FIFO item

    We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…
  • RE: recommended report writer for Sage 300

    Hi there. To follow on from Ettienne, Sage Intelligence for 300 includes a number of out-the-box financial and operational reports and provides the ability to design reports, with options for beginner users through to advanced users, in the familiar…
  • Unbalanced journal in ledger currency ..!!

    Hi All, We are facing one critical issue "Unbalanced journal in ledger currency" in journal entry. for balancing the journals we ran the journal re synchronization and balance re synchronization but the difference is still appear in journals. …
  • Still looking for an FRx replacement? Register for session BUS-563 at Sage Summit

    FRx reports can be efficiently converted to Sage 100 ERP Intelligence Reporting using the powerful functionality of the Sage Intelligence Report Designer. Sage Intelligence Product Specialist, Sandra Smith, will show you how to simply export existing…
  • Server Upgrade for MAS90 and MAS Intelligence

    We plan to upgrade the server for MAS90 before year end and move to the latest version of SAGE, would the MAS Intelligence reports carry over, or is there a new reporting package? The IT department has informed me that FRx will not be available on the…
  • Error Printing range of Invoices (Data is not selected for report printing)

    I do not want to use the option "Print the option already printed" I know for sure that there should be a way to print in range without selecting that option. Thank you for your help.
  • Pulling meaningful sales data that matches my GL

    I'm trying to pull sales data that can be sliced and diced by customer, SKU, date, sales rep, etc. but ties exactly to the GL. So far, the reports I can get using Microsoft Query all have great data, but it won't tie to the GL. There has to be a simple…
  • Noob question on reporting options (formerly on FRx)

    Since the update to Sage 100 2013, staff are asking for FRx migrated reports. How and if that's possible remain a mystery to me. I've installed and licensed our 1 user Intelligence reporting and referred them to learning the product. Is there anything…
  • Getting the Most from Sage Intelligence Reporting

    "When creating Executive Dashboards for financial reporting, how can I get the information I need from Sage Intelligence Reporting or BI queries" was a hot topic from the Sage City Live networking event at Sage Summit 2013. How are you using Sage Intelligence…
  • How do you produce effective, multi-currency financial statements?

    How do you produce effective, multi-currency financial statements?
  • Where can I find information about getting started with Sage Intelligence?

    Somebody at the Sage City Live event at Sage Summit this year asked "Where can I find information about getting started with Sage Intelligence?". Well, firstly, it depends on what product you need information for. The Learning Services team responsible…