Sage ERP Accpac 6.0 Data Portlets
The new Sage ERP Accpac 6.0 Portal can display a selection from a number of Data Portlets. Think of these as a new dashboard of key performance indicators and corporate summary data. All the data is up to date when the pages is displayed and can be refreshed at any time. Below is a selection of Data Portlets from A/R, G/L and A/P.
These give you a nice graphical view of the status of your company. Then if you hover over a piece of the graph it will tell you the data, plus you can click on any of the hyperlinks to run a report. You can also configure the Portlet to give you the data you need.
Implementing these Data Portlets wasn’t just a matter of accessing Accpac data the same old way; we had to optimize the database schema so that we could quickly retrieve this data with in seconds. We had to change the index structure of a number of A/R and A/P tables to speed up the Aging Portlets. We had to collect extra summary data at posting time to support the days outstanding Data Portlets. We have been running benchmarks on quite a few large customer databases to ensure the performance is sufficient to make these Data Portlets useful. We are aiming to make the Portal and Data Portlets fast enough so you can run six such Data Portlets; but, we anticipate a given user would typically have two of these on their home page.
To support printing Financial Reports from the G/L Data Portlets we needed to add tables to hold the generated data, so Crystal Reports could run off the correct data.
The G/L Account Groups now have a new “Group Category” to allow you to configure how your Accounts will appear in the G/L Portlets.
Hopefully these Data Portlets will give customers a useful view of their company as soon as they sign-on to Accpac and provide a useful starting point to getting their work done.
it will be good if user could create their own portlet.
KC
February 26, 2010 at 4:38 pm
Right now only development partners can create portlets using the SDK. Perhaps one day in the future…
smist08
February 26, 2010 at 9:29 pm
[…] construct some menus to act as an “Accpac Mobile Desktop” to launch our various data portlets (https://smist08.wordpress.com/2009/12/24/sage-erp-accpac-6-0-data-portlets/). This lets a user see various dashboards in real time from their […]
Accpac on the iPhone and Android « Stephen Smith's Blog
June 25, 2010 at 11:40 pm
[…] other blog posts like https://smist08.wordpress.com/2009/12/03/the-sage-erp-accpac-6-0a-portal/ and https://smist08.wordpress.com/2009/12/24/sage-erp-accpac-6-0-data-portlets/. But as a developer, how do you create new Web Based forms using the Accpac […]
Creating a Web Form for Accpac 6 « Stephen Smith's Blog
August 14, 2010 at 4:28 pm
[…] Data Snapshots: https://smist08.wordpress.com/2009/12/24/sage-erp-accpac-6-0-data-portlets/ […]
Preparing for the Sage ERP Accpac 6.0A Launch « Stephen Smith's Blog
September 25, 2010 at 4:09 pm
[…] of your business in a simple graphical snapshot. For more information on the new dashboard see: https://smist08.wordpress.com/2009/12/24/sage-erp-accpac-6-0-data-portlets/. The goal of the new Accpac Inquiry tool is to give you a simple way to view your data without […]
Sage ERP Accpac 6.0A Compelling Installed Base Value « Stephen Smith's Blog
October 16, 2010 at 4:44 pm
Can you provide us with sample code of calling/using the OE entry OCX in VB6 (At least for Sage Accpac version 5.5A or 5.6A)?
Solomon
November 1, 2010 at 6:18 pm
[…] you don’t. And with options to configure “My Shortcuts” and a selection of optional “Data Portlets”, your personal portal is more customizable than ever […]
Say Hello to Six-Point-O: A Look at Sage ERP Accpac Version 6.0 | Axis Global Partners Blog
December 13, 2010 at 2:57 pm
[…] on Sage ERP Accpac 6.1A. Accpac 6.0 introduced our new Web Based technologies with the new Portal, Dashboards, Inquiry tool and Quote to Orders. With Accpac 6.1 we are now looking to fill out the main […]
Accpac 6.1 Development Kick-off « Stephen Smith's Blog
January 15, 2011 at 5:34 pm
[…] learn more about Sage ERP Accpac 6.0A including the new Web Portal, new Web Based CRM Integration, Dashboards, new Inquiry tool and more, please attend our Virtual Launch […]
Sage ERP Accpac 6.0A and the Technologies it is Based On | The Business Management Blog
February 3, 2011 at 2:49 pm
[…] Sage ERP Accpac 6.0A Portal Sage ERP Accpac 6.0 Adhoc Query Sage ERP Accpac 6.0 Quote to Orders Sage ERP Accpac 6.0 Data Portlets Sage ERP Accpac 6.0 – Locking Fiscal Periods by Module Drilling Down from Crystal Reports in Sage […]
Accpac 6 FAQ « Stephen Smith's Blog
February 10, 2011 at 11:50 pm
[…] product as it shipped only defined a few SData feeds that it needed to support the new Web Portal, Data Snapshots, Inquiry Tool and Quotes to Orders features. But Sage 300’s support for SData is based on […]
Defining SData Feeds for Sage 300 ERP « Stephen Smith's Blog
March 3, 2012 at 11:57 pm
[…] had similar data widgets in our Sage 300 6.0 Portal, these new KPIs leverage what was developed there as well, for instance […]
The Sage 300 2016 KPIs | Stephen Smith's Blog
September 6, 2015 at 11:06 am