Sage 100 ERP Software: How to Run Credit Memo Reports in MAS 90
Sage 100 ERP Software Question and Answer on How to Run a Credit Memo Report As a certified and experienced Sage 100 ERP software consultant, I get...
2 min read
Sage 100 Consultant Question: What are Sage Intelligence Reporting Installation Requirements?
Mike, we recently purchased Sage Intelligence Reporting and also upgraded our Sage 100 version 2015. We have Excel 2010; will Sage Intelligence work or does it require Excel 2013.
Sage 100 Consultant Answer:
Being a Sage Certified Consultant for over 25 years we have come across this issue several times. The answer is Sage Intelligence will work with Excel 2010, but during the Excel 2010 installation it will not install all the required Visual Basic Studio Tools. Excel 2013 will, so it might just be easier and more effective to just install Excel 2013.
Below are listed the requirements for Sage 100 for this installation:
- Sage Intelligence must be installed as the Network Administrator
- Excel must be installed and activated prior to the Sage Intelligence installation
- Excel must be closed during installation of Sage Intelligence (also check that there are no remaining EXCEL.EXE processes listed in the Windows Task Manager-Processes tab)
- Windows User Account Control must be turned off during installation (requires a reboot after turning off U.A.C.)
Windows
- Microsoft V.S.T.O. (Visual Studio Tools for Office) runtime 2010 must be installed
- Microsoft V.S.T.O. runtime 3.0 must be installed
Permissions
All Sage Intelligence users must have Full Control level permissions to the following areas:
- MAS90 parent directory (as is also normally required for Sage 100/MAS90)
- The Sage Intelligence Report Repository (displayed at the Report Manager login screen and originally set during Sage Intelligence setup)
- All folders that begin with 'BI' and located in C:\Program Files(x86 if on 64bit Windows)\Common Files\
- As with all permissions, if a group policy or domain is in place, those settings must reflect the above requirements
Report Repository
- Must be set as a UNC path on a shared network drive (cannot browse through a Mapped drive to select location either)Excel
- Make sure you are running a compatible version of Excel (Office 365 is not compatible; 64-bit versions of Excel are compatible with Sage 100 2014 and newer only)
- V.B.A. components must be installed in Excel (run a repair/change install of Excel from Control Panel
Written by Mike Renner Sage 100 consultant: Partner of WAC Consulting and Owner at Computer Accounting Services, an Acumatica and Sage 100 ERP software consultant and support provider based in Indio, CA.
Mike Renner is an expert on ERP and fund accounting and supports Abila Fund Accounting, Sage 100 ERP, and Acumatica with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage.
Specialties:
Sage 100 ERP (formally Sage MAS90/200), Acumatica ERP, Abila MIP Fund Accounting, Abila Grant Management, QuickBooks.
Tags: MAS 90, MAS 200, Sage 100 ERP, SAAS, Acumatica ERP, Accounting Systems, ERP Systems, ERP Consultant.
ERP Consultant Tip: HOW TO UPGRADE 4.xx to Sage 100 ERP 2014
As an ERP consultant who supports Sage 100 ERP clients, we get questions that we often share in our blogs when they are relevant to others. Today we...
Sage 100 Consultant Tip of the Day: Purchase Order Receipt of Invoice
Sage 100 Consultant Question: Hi Mike, We own Sage 100 (formerly Sage MAS90 and MAS 200) and we just added the Purchase Order and Inventory...