Stephen Smith's Blog

Musings on Machine Learning…

Accpac 6 FAQ

with 24 comments

Happy New Year everyone. Hope you all had a good holiday. Over the past year this blog has had quite a few postings to do with Sage ERP Accpac 6.0A and the new Web Based technology platform that it is based on. Sage ERP Accpac 6.0A has now been released. It has been available for download for a couple of weeks now. In this posting I wanted to address a number of questions I’ve been receiving as well as try to put to rest some misconceptions that seem to be out there (mostly to do with the transition from VB to Web).

Does Sage ERP Accpac 6.0A become a 100% full web based solution? No – this is the first step in that journey. With this release we have the technology foundation, the new web based portal, the new dashboard, the new Inquiry tool along with the web based screens that make up Quote to Orders. All the other accounting screens are still the VB screens similar to 5.6A.

When Will Sage ERP Accpac be 100% fully web based? Version 6.2 which is estimated for release at the end of calendar 2012. With this release the entire product will have a web based option, including all accounting modules and options products. However version 6.1 which is estimated to ship at the end of 2011 will have all the major modules Web based including GL, AP, AR, IC, OE and PO.

As Web Screens are released will the VB screens disappear? No. You will still be able to run the VB screen from the original Accpac desktop. As Web Screens are completed they will take the place of the VB screens in the new Web Portal, but the original VB screens are still installed, supported and accessed from the original desktop.

How long will the VB screens be supported? At least through 6.2A, beyond that it will depend on market demand. If everyone moves to the web quickly then that will be it. But if it takes time to move customizations and such, then you will have that time.

Is SageERP Accpac 6.0A SaaS? No. This is an on-premise installed product. You can install it in the cloud, but this is still essentially on on-premise install, just with a remote server.

When will there be a true SaaS version of Accpac? After we have a number of accounting modules Web based then we will look to do a SaaS deployment through AccpacOnline (ie after 6.1 or early 2012).

If I don’t deploy the web components, why should I upgrade to 6.0? There is the lock fiscal periods by module feature that is used by both. Plus there are many bug fixes.

Why should I deploy the Web components? You will get the new portal, dashboards and inquiry tool. Plus this will prepare you for 6.1A. If you get the web components going then installing 6.1A will be very easy since you will have the infrastructure all deployed.

If the product is web deployed why do I need workstation setup? Until the VB accounting screens are moved to the Web in 6.1 or 6.2, we are running the current VB screens from the Portal. The only data entry screens in the new Web technology for 6.0A are the Quote to Order screens run from inside SageCRM.

Why is there an ActiveX control in the new Portal? This is required to run the VB UI screens. This will be removed once all the VB screens are moved to the Web.

Can I run the Portal for remote users? Only for the new Web parts. The VB screens will not run remotely with this technology, Workstation Setup is required. This will be more realistic starting with 6.1A.

Can I use browsers other than IE? The only supported Browsers are Internet Explorer 7 and 8. You can use Firefox, Safari or Chrome but you can’t run the VB screens from these Browsers (since they don’t support ActiveX controls). The CSS (Cascading Style Sheets) are optimized for IE and will have many rendering glitches with the other browsers (this will be fixed for 6.1A).

Does the new Web Portal use a Lanpak? No. Logging on to the new Web Portal, seeing the dashboard, drilling down to reports from the dashboard, accessing help and using the Inquiry tool does not use a lanpak. However you will use a lanpak the first time you run an accounting screen. The idea is to promote the use of Accpac in the Enterprise outside of the accounting department.

Do the Quote to Order Screens use a Lanpak? No. You just need the SageCRM User count to sign onto SageCRM, then no further Lanpaks are required.

Do I require a new server for the web parts? Depends. Often people already have a good file server that is being under-utilized, you may be able to use this additionally as your web server. If you are already running SageCRM, then this server will probably be ideal as the Accpac Web server also. But if you are running local installs and Pervasive workgroup and have no server, then you will need to get one.

Where can I see a demonstration of Sage ERP Accpac V6.0? You can view a short 5 minute overview video on YouTube: You can also view short, detailed videos of each new feature at:

Where can I learn more about what’s new in Sage ERP Accpac V6.0? You can visit a dedicated website with details on the V6 release:

In addition, Sage University ( offers a FREE anytime learning course about “What’s New in Version 6.0”. Customers and solution providers can register (for free) and complete the online curriculum at their convenience.

This course provides an overview of all the exciting new features offered in our version 6.0 release of Sage ERP Accpac. You will find out about how each feature works and how it can improve and enhance your Sage ERP Accpac solution. Learn about our new Sage ERP Accpac Portal and other key enhancements that are now available in Version 6.0. This comprehensive course includes information on Extended Enterprise modules like SageCRM. To make the most of your investment with Sage ERP Accpac and learn all of the amazing new features and functions, you must attend this course.

Course Length: 1 1/2 hours
Course Level: Basic Course
Instructional Method: Self paced Internet-based

Course Content:

  • Learn about the new Sage ERP Accpac Portal including navigating and security.
  • Learn how to work with tasks, shortcuts, snapshots, and the Learning Center in the Portal.
  • Learn the new quote to order workflow with SageCRM.
  • Learn about Printing and Exporting Inquiries and Inquiry security.

What is involved in upgrading to V6.0?
Upgrading from 5.6 is a single step activation to upgrade to v6.0.
Upgrading from 5.3, 5.4 or 5.5 is a 2 step process – first to 5.6 and then to 6.0.
Upgrading from 5.3 or older is a 3 step process – first to 5.3, then 5.6 and 6.0

In general you will want to make sure the following are compatible with 6.0.

  • Program Customizations, VBA Macros, Excel Macros that integrate with Accpac.
  • Customized Crystal Reports
  • 3rd Party programs that integrate with Accpac
  • The appropriate version of MS-SQL or Pervasive database.

It is best to discuss your upgrade options with your Accpac Solution Provider as they are most familiar with your business requirements.


Blog Postings on Sage EPR Accpac 6

Now to use a trick of many blog posters who are lazy during the holidays and rather than write new content just reference previous content. Here is a directory of the various articles on Accpac 6 from this blog:


Sage ERP Accpac 6.x Product Roadmap
On Total Cost of Ownership
Accpac on the iPhone and Android
Sage ERP Accpac 6 Competitive Advantages
Sage ERP Accpac 6.0A Compelling Installed Base Value
How to Best Demo Sage ERP Accpac 6.0A


The 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 ERP Accpac 6
Running Classic Forms in Sage ERP Accpac 6
Sage ERP Accpac 6 User Assistance


Sage ERP Accpac 6 Deployment
Installing and Deploying Sage ERP Accpac 6.0A
Setting up Sage ERP Accpac 6.0A Securely


Sage ERP Accpac 6 Customization
Migrating Customizations to Sage ERP Accpac 6
Customizing Quotes to Orders
Customizing the Order Details in Quote to Orders


SData in Sage ERP Accpac 6
More on SData and Sage ERP Accpac 6
Stateful SData
On the Sage GCRM Contract


Declarative Programming in Sage ERP Accpac 6.0A
Sage ERP Accpac 6 Performance Testing
Sage ERP Accpac 6 Security
Sage ERP Accpac 6.x Mobility
Automated Testing in Sage ERP Accpac Development
How to Layout Forms in Sage ERP Accpac 6
Creating a Web Form for Accpac 6
Client Logic for an Accpac 6 Web Form
Writing Server Side Code for Accpac 6 Web UIs
Preparing for the Sage ERP Accpac 6.0A Launch


This posting is really just meant to tie up some loose ends from 2010 and to set the stage for 2011. Now that Sage ERP Accpac 6.0A has shipped, I will be starting to blog about Accpac 6.1A as it progresses through development as well as writing posts on topics for 6.0A as well as various topics on 5.6A.

If you have any questions or topics you would like covered in this blog, then please leave a comment. I read all the comments and especially appreciate topics for future posts.

Written by smist08

January 1, 2011 at 10:38 pm

Posted in sage 300

Tagged with , ,

24 Responses

Subscribe to comments with RSS.

  1. Stephen, I am looking forward to additonal blogs on the 6.1 development. Future blog topics re: customizing the new UI’s and events would be good, although I know you have covered some of this already. Also technical uses for RVSpy and how to mine the logs for useful info would also be good.


    January 27, 2011 at 6:06 am

    • Thanks, both good topics.


      January 28, 2011 at 3:47 am

  2. hi smith……
    today i have configured sage web’s working fine & every chart showing fine,.but when i click in any graph showing the below error “java.util.concurrent.ExecutionException: java.lang.RuntimeException: while pointing the report to the database”


    May 30, 2012 at 12:15 pm

    • Not sure. Which database are you running?


      May 30, 2012 at 10:45 pm

      • SQL Server 2008 R2.
        One is sysdatabase, one is datdatabase, & for portal using portal database,


        May 31, 2012 at 7:20 am

      • Usually SQL Server is fairly painless. Check out the items under SQL connection issues in this posting: Sometime people have problems if they have multiple SQL instances installed, which requires you set the correct port number rather than the SQL instance name.


        May 31, 2012 at 4:07 pm

  3. Hi Stephane,
    I am a new user of Accpac ERP500 (Version 6.0A). We would like to get the information of an inventory item on one screen, for example the item number, description, the vendor, the quantity on hand, the average cost and the selling price. Right now, we have to go to several places to find out the information we need. Could you tell me whether there is way to group information from several tables into one screen and how to do it?
    Your help is highly apprecatied,

    Sherry Sun

    September 21, 2012 at 8:37 pm

  4. Hi Smith,
    is it possible to change properties(like change a textbox backcolor, fontnamte fontsize etc) of a control ?


    October 4, 2012 at 1:51 pm

    • If you have the SDK you can checkout UILayout.xsd for all the things you can set. But generally we don’t have explicit properties for things like this, because we use CSS for this. You can change the style name used and provide a new style that does what you want.


      October 4, 2012 at 5:48 pm

      • i have SDK for accpac 5.5. but i don’t know how i change ? please help me


        October 5, 2012 at 4:47 am

      • To get the SDK, you need to be part of our developer partner program. Depending on which region you are located, you typically do this through your Sage regional office. You can also contact for more information.


        October 5, 2012 at 3:41 pm

      • Dear,
        already i have SDK. but i don’t know how i change properties of a text box . please help me


        October 7, 2012 at 9:04 am

  5. is it possible to customize 6.0 dashboard or add new dashboard ?


    October 4, 2012 at 6:28 pm

    • I’m not sure there is much to customize in the current dashboard snapshots. You can create new ones, you have to use the SDK to do this and it requires creating new SWT UIs. There is a workshop in the SDK on how to do this.


      October 4, 2012 at 7:24 pm

  6. Hi Smith, if possible give me a contract person at ASIA who give training on Sage ACCPAC SDK desktop version.


    October 20, 2012 at 5:56 am

  7. Hi Stephen,
    In A/P Vendor screen, on the address tab, there are four lines alloted for address. We used the 4th line for TAX IDENTIFICATION NUMBER, we want to put the label ‘TIN’ beside the 4th address line? Can we do this without SDK?

    Jo Inovero

    February 21, 2013 at 3:06 am

    • Without the SDK, you can embed the A/P Vendors UI in a VBA macro and then use VBA to change the label. This is probably the easiest way to do it.


      February 21, 2013 at 4:45 am

  8. Hi Steve,

    Hope things are going good. I read your article about drone. This is something amazing.

    I have a query, request your help.

    am trying to customize the Internal usage where i am trying to show the stock on hand, on PO, on SO similar to OE Order entry.

    I have placed a datasource control for adsICLOCQT – IC0374. To activate the datasource at runtime I need to set the DBLink. I see that Accpac UI control expose property called UIDBLinks however, i am unable to get the DBLink (company) to activate the datasource adsICLOCQT – IC0374. getting the error

    “Object doesn’t support is property or method”

    Not sure where i am going wrong. here is the code snippet.

    ‘ Code snippet

    Option Explicit

    Private WithEvents mIC3530 As VBControlExtender
    Private mDBLink As AccpacDBLink

    Private Sub Form_Load()

    Set mIC3530 = Me.Controls.Add(“ACCPACIC3530.ACCPACIC3530UICtrl”, “mIC3530″)
    Me.Caption = mIC3530.object.CompanyID & ” – ” & “Customized I/C Internal Usage Entry”
    Me.Icon = mIC3530.object.uiicon
    Set mDBLink = mIC3530.object.uidblinks(0).GetDBLink
    mIC3530.Visible = True

    End Sub

    Looking forward to your help.



    May 1, 2015 at 11:51 am

    • Not 100% sure, but if the UI isn’t signed on there won’t be anything in the collection. I’m also not sure that it indexes from 0, you might try 1. Also you might try a for each statement to see what is in the collection.

      This seems like an unusual thing to need, usually you would just interact with the data sources to do what you need, I’m not too sure why you really need the dblink.


      May 1, 2015 at 3:18 pm

  9. HI Steve,

    Thank you for the response. I tried the index 1 and it worked 🙂 I wanted to activate the datasource adsICLOCQT at runtime hence, i need the dblink object.

    However, i now end up with one more issue which i would need your help.
    Below is the code snippet when i run the program i get an error as “Type Mismatch” Run-time error 13 in the statement Set afecICICEH_Status = mIC3530.object.UIAppControls(“fecICICEH_Status”).GetControl

    The same kind of code i have written many times it was working for other UI controls. am not sure what is the issue with this code now.

    Looking forward to your reply.


    ‘ Code Snippet begins ==================================================

    Option Explicit

    Private WithEvents afecICICEH_Status As AccpacFieldEditControl

    Private Sub Form_Load()

    Set mIC3530 = Me.Controls.Add(“ACCPACIC3530.ACCPACIC3530UICtrl”, “mIC3530”)
    Me.Icon = mIC3530.object.uiicon

    mIC3530.Visible = True

    End Sub

    Private Sub mIC3530_ObjectEvent(Info As EventInfo)

    Select Case Info.Name
    Case “OnUIAppClosed”
    Unload Me

    Case “OnUIAppOpened”

    Set afecICICEH_Status = mIC3530.object.UIAppControls(“fecICICEH_Status”).GetControl

    End Select

    End Sub


    May 3, 2015 at 8:40 am

    • It might depend if you are using VB and have to use the ControlExtender object.


      May 5, 2015 at 6:06 pm

  10. Steve, thanks for the response.

    I am using the below declaration statement already. However, I am getting the error. There is something I am going wrong not sure what it is.


    Private WithEvents mIC3530 As VBControlExtender


    May 7, 2015 at 2:26 am

    • You only use that with VB and not VBA so make sure which you are using. Here is a small sample:

      Dim WithEvents tabctl As VBControlExtender

      Private Sub AccpacBK1600UICtrl1_OnUIAppOpened()
      Set tabctl = AccpacBK1600UICtrl1.UIAppControls(“tbOptions”).GetControl

      End Sub

      Private Sub tabctl_ObjectEvent(Info As EventInfo)
      If Info.Name = “Click” Then
      MsgBox (“tab clicked”)
      End If

      End Sub


      May 7, 2015 at 2:36 am

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: