Sage Accpac Accounting Software Vancouver Blog – Unisoft

Sage Accpac ERP, Microsoft Networking and Accpac Data Repair

Archive for the 'Business Intelligence' Category

Report Designer for Sage Accpac Intelligence NOW AVAILABLE!

Thursday, April 28th, 2011

Yes that is right!  The Sage Accpac Intelligence Report Designer is now available for Sage ERP Accpac V5.6 and will be available for V6.0 tomorrow!  Register for a sneak preview in the blog post before this and contact Scott@Unisoft.net (604) 926-3398 to discuss the Sage Accpac Intelligence promotion.

Sage Accpac Intelligence Report Designer – Available Soon

Monday, April 25th, 2011

The long awaited Report Designer for Sage Accpac Intelligence is almost here. It has an amazing, intuitive, graphical interface that supports drag and drop functionality. Financial reports can quickly and easily be set up to include meaningful aggregated prior, actual, and budget figures, providing invaluable detail for better decision making.

The Report Designer module is ideal for finance directors and managers who want to create highly customized financial statements using an intuitive, graphical interface. Financial reports can quickly and easily be set up to include meaningful aggregated prior, actual, and budget figures, providing invaluable detail for better decision making.

- amazing, intuitive, graphical interface
- drag and drop functionality
- what if analyzer
- supports multi-company consolidations, segmented general ledgers, column reporting
- requires 2007 or higher

The Report Designer allows to refresh newley added accounts into your exisiting layouts at the click of a button. The Report Desginer supports the use of excel, therefor leveraging your existing skills. The ‘What If Anaylzer’ tool supports planning and full costing decisions so you can get proactive instead of reacitve in your business. Click on the picture to see a breif demonstation.

Sage Accpac Intelligence & it’s Community

Friday, January 21st, 2011

Below is the link for the Sage ERP Accpac Intelligence, (SAI), Group on the Business Intelligence Community:

http://community.alchemex.com/group/sageaccpacintelligence

You will be able to download:
• SAI product tips and tricks booklet
• SAI Datasheet
• Everything you need to know about SAI
• SAI preview reports workbook
• SAI Getting Started Guide
• Report Writing Best Practices

There are a number of SAI videos that you can view under the videos section on the community.

Mu – from XKCD

Thursday, December 9th, 2010

As the CoFK approaches 0, productivity goes negative as you pull OTHER people into chair-spinning contests.

Permanent link to this comic: http://xkcd.com/815/

Form xkcd.com, a webcomic of romance, sarcasm, math and language.

Accpac Intelligence Free with V5.6+

Monday, November 29th, 2010

What is included with Accpac Intelligence?

One free Report Manager License that allows the user to run 12 standard reports, author new reports (organize, create and edit), filter and aggregate data based on  based on existing data containers and available fields only.  This license can only connect to one company database at a time.

What limitations apply to the FREE Accpac Intelligence solution that is being bundled as part of Accpac 5.6 release ?

  • Can connect to any number of Sage Accpac ERP companies but only one company at a time.
  • Cannot connect to non Sage Accpac ERP databases (requires the Connector Module)
  • Cannot add additional fields to standard reports that are not already provided by the data containers (requires Connector Module)
  • Cannot perform multi-company consolidations (requires the Connector Module)
  • Cannot create reports off modules and/or fields that are not available in the standard data containers (requires the Connector Module)
  • Cannot schedule reports to run automatically (requires the Connector Module)
  • Cannot import reports created from other Sage Accpac Intelligence installations (requires an additional Report Manager and/or Connector Module)
  • Cannot run OLAP or cube reports (requires the Analysis Module)

Sage Accpac: Quick and Easy Reporting with Indicee

Friday, January 29th, 2010

One of the biggest struggles with Sage Accpac is getting access to the data you need quickly and easily. Indicee, is a web based system that is easy to use and integrates with Sage Accpac to quickly generate important information about your business.

Have a look at this Sage Accpac quick start video to see how it works:

Sage Accpac v5.6 Released

Friday, December 18th, 2009

Increase Productivity. Streamline Operations. Improve Visibility.

The Sage Accpac Version 5.6 release can be summed up by improved performance and productivity enabling you to accomplish more tasks in less time. The highlights of the upgrade:

  • Sage Accpac Intelligence: a new easy to use business intelligence and reporting tool
  • Support for new IT infrastructure including virtualization and Windows 7
  • Enhanced cash flow and integrated customer inquiry tool (originally AR inquiry) 
  • Improved inventory mangement 
  • Bank Reconciliation has been completely redesigned 
  • New functionality in Payroll to descrease penalties and fees 
  • More user requested enhancements submitted via sageaccpac.com/feedback

Sage Accpac V5.5 & V5.6


Sage Accpac Sales Data in Excel Pivot Tables

Monday, September 15th, 2008

Using Excel to retrieve sales information from Sage Accpac is quite simple and powerful.  In both the Order Entry and Inventory Control Modules there is a table that includes sales statistics. ICSTATI is the name of the table that includes the sales details for the inventory module. Essentially this is is a table that includes records per accounting period for the quantity sold, sales amount, return amounts and cost of goods sold.  By importing this table into Excel you can easily create a pivot table/report that shows your net sales (sales – returns) for a range of periods and/or years as shown below.

Sales by Period for 2009/2010

Sales by Period for 2009/2010

Preparing such reports can be accomplished with the help of our consultants, 604-926-3398.

Sage Accpac Third Party Conference (TPAC)

Friday, August 24th, 2007

Unisoft will be attending the Sage Accpac third party conference or formally Third Party Advantage Conference (TPAC) from August 26th to 28th.  TPAC is a conference showcasing thrid party products that work with Sage Accpac ERP. The conference was founded in 2003 after the AOC, the old Third Party conference was discontinued.  All the major Sage Accpac third party developers will be there and will be a good time for Unisoft to get up to date on all their latest technologies and developments. There will be training sessions and exhibitions that will allow Unisoft to help find the best products to help improve our customers business systems. We will be posting back here after the Conference to give a quick summary of what of the Accpac conference.

What is ERP Software?

Thursday, August 16th, 2007

This is a good question. For any business, small, medium or large, looking to utilize technology to their full advantage they will need to know what ERP is and how they can use it.  Essentially, ERP stands for Enterprise Resource Planning, another great IT acronym. However, this is not what we are after, we are after the concept that is making ERP software the next revolution in business technology.

ERP software is meant to be a solution for your business that can encompass and integrate all of your business processes and needs. It can include manufacturing, supply mangement, sales, financials, customer management  or just a few business activities. ERP systems are built around what your business needs.

Why is ERP software so important? Because it brings all your systems together and ensures every business process is integrated, bringng your business technology system closer and closer to mimicking your business. This makes all your company activities more efficient and enables you’re business to get more out of your investment.Â