Tuesday 3 August 2010

"Runtime error '429': ActiveX component can't create object" Error When Trying to Access Statement Designer

If you encounter an error "Runtime error '429': ActiveX component can't create object" Error When Trying to Access Statement Designer. Follow this step

Logon to the server with the Administrator account and attempt to run the Statement Designer. If the same error is received, the accpacfrXXX.xla file (where "XXX" indicates the version of the file) may need to be manually added as an add-in component in Microsoft Excel.

This can be done by opening Excel outside of ACCPAC by performing the following steps.

  1. Open Excel.
  2. Select Add-Ins from the Tools menu.
  3. Click the Browse button and browse to the General Ledger program directory. For example, if version 5.5 of Sage
  4. Accpac ERP is installed, the accpacfrXXX.xla file will be located in the [accpac]\GL55A folder (where [accpac] is the directory where Sage Accpac ERP is installed. By default, this directory is C:\Program Files\Sage Software\Sage Accpac.)
  5. Once in the proper directory, select accpacfr550.xla and click OK.
  6. Select the checkbox beside the entry in the Add-Ins window for the file added in the previous
    step and click OK to close the Add-Ins window.

Completing these steps should correct the problem for the Administrator as well as all other Windows accounts.

If running Windows Vista, ensure the "Run as Administrator" option has been selected when running Accpac.

  1. Right-Click the Accpac shortcut
  2. Under the General tab, enable the Run As Administrator option.
When running Windows 2008, add Accpac.exe file under Data Execution Prevention:
  1. Click Start, right click Computer, choose Properties
  2. Choose Advanced System Settings
  3. Click "Settings" under "Performance"
  4. Go to the tab "Data execution prevention"
  5. The selection on that tab is normally on "Turn on DEP for all programs", leave it as is
  6. Click on Add at the bottom
  7. Browse to accpac installation folder, then the Runtime folder
  8. Confirm that accpac.exe file shows up in the list and has a check mark in front of it
  9. Click OK to confirm

Wednesday 7 July 2010

Create Databases and Datasource Names (DSNs) in Pervasive.SQL

To create company and system databases in Pervasive.SQL:

  1. Click Start > All Programs > Pervasive > Pervasive.SQL Control Center.
  2. In the Common Tasks section in the right panel, click New Database. The New Database window opens.
  3. In the Server field, click the down arrow, select a server from the list, and then click Next.
  4. In the Database Name field, type the name of the folder you created for the database. Note: The folder name and the database name must be identical.
  5. In the Location field, type the path to the folder you created for the database.
  6. In the DBName Options section, select Bound and Create Dictionary Files. Do not select the option, Relational Integrity Enforced, as Sage Accpac checks integrity.
  7. Select the Create DSN option, and leave Normal as the Open Mode. Note: The DSNs are used in Database Setup when you set up your system and company databases.
  8. Click Finish.
  9. Create other databases (for example, if you created a system database, now create a company database).
  10. Close the Pervasive.SQL Control Center.

Wednesday 30 June 2010

A short video on what's coming in Sage ERP Accpac V6.0




Here is link to a video on what's Sage Accpac 6.0 will look like. There are several new feature in this version release of Accpac(As mention in Sage Accpac blogs)

  • A new personalized Portal – which makes it a lot easier for users to find and navigate to the screens they need.
  • Snapshots – which provide information on key performance indicators (KPI) for financial managers, such as income statement and balance sheets, aged payables and receivables, and days outstanding payables and receivables.
  • Inquiry – which allows any user of Sage Accpac to quickly create “ad hoc” queries to get lists of information out of GL, AR and AP (reducing the need to have to customize Crystal Reportrs!)
  • SageCRM Integration – designed from a sales person’s point of view, the SageCRM integration is now “seamless” and makes it much easier for sales people to create quotes and orders.
  • And, last but not least, the ability the lock fiscal periods by module. This is a highly requested enhancement by user

Tuesday 29 June 2010

Pre Installation Check for upgrade To Sage Accpac 56

Before upgrading process take place, It's better get to know first what need to be done in order to have a successful upgrade of Accpac :
1. Check for hardware and system requirement

For Server :
  • Windows 2003 Server SP 2
  • Windows 2008 Server

Database :
  • Pervasive 9.7(32bit)
  • Pervasive 10.2(32bit&64bit)
  • Microsoft SQL 2005 SP 3(32bit & 64bit)
  • Microsoft SQL 2008 (32bit & 64bit)

Workstation:
  • Windows XP SP 3
  • Windows Vista
  • Windows 7

2. Run The following Task :
  • Post transactions in Project and Job Costing (if you are upgrading from version 5.3 or 5.4).
  • Invoice any partially invoiced P/O receipts that included serialized or lotted items.
  • Run Day End Processing (if you use Inventory Control).
  • Post any open batches in Accounts Receivable and Accounts Payable.
  • Post bank reconciliations, create a G/L batch in Bank Services, and clear the Bank Reconciliation Posting Journal. (The Update Notice contains additional important information about this task.)
  • Post any open G/L batches in General Ledger.
  • Deactivate any Sage Accpac Options (UniDevCo) products you used with the previous version.
  • Back up your company data.
  • Perform Database Dumps of IBM DB2 Data (if you used DB2 in the previous version).
When all the things done, enjoy the new upgrade feature from Sage Accpac 56. Where you can just click all the module that are used and the system will convert automatically the data based on the module that has been selected(In Previous version, we need to upgrade module by module).

Good luck and don't forget one more important part "Pray" :D

Wednesday 26 May 2010

Ops Inquiry 56

With the release of 56. Ops inquiry is now part of Accpac, which means another FREE module has been incorporated into core accpac. Ops inquiry give you the ability to check and view all information regarding an item starting from first it was created, received and shipped out. All into 1 single screen. It also give the ability to preview sales or purchase information
Below are some screen shot from the ops inquiry module :




Tuesday 27 April 2010

Export Import in CB56


Dreaming/hoping for a better way to manage transaction in Cashbook? Where you have hundreds of transactions need to be recorded from branch or transaction recorded from other 3rd party system. And you're dream is coming true!


Cashbook 56 provide the ability to Export/Import Transaction Just like what Accpac has been doing. And now this Feature is build in to 56. And there are more to come stay tuned for the latest update on Cashbook 56.



Tuesday 6 April 2010

What Windows Operating Systems Are Supported For Pervasive.SQL 10.2 and 10.3?

For the Pervasive.SQL 'Server' for Windows edition, X64(64bit) and X86(32bit) platforms are available. Both platforms have been tested and are supported with the following Windows operating Systems:

Windows Vista (Requires SP1 for v10)

  • Enterprise x86 and x64 Editions
  • Ultimate x86 and x64 Editions
  • Business x86 and x64 Editions

Windows 7

  • Professional
  • Ultimate
  • Enterprise

Windows Server 2003

  • R2 Server x64 Edition
  • R2 Server and Small Business Server
  • R2 Server, Small Business Server, and Failover Cluster
  • R2 Server Terminal Services
  • Server x64 Edition (SP 2)
  • Server and Small Business Server (SP 2)
  • Server, Small Business Server (SP 2), and Failover Cluster
  • Server Terminal Services (SP 2)

Windows Server 2008

  • Web Server x86 and x64 Editions
  • Datacenter x86 and x64 Editions
  • Enterprise x86 and x64 Editions
  • Standard x86 and x64 Editions

Windows Small Business Server 2008

  • Standard and Premium Editions x64


For the Pervasive.SQL 'Workgroup' for Windows edition, this platform is only available in X86(32bit). This edition has been tested and is supported with the following Windows operating systems:

Windows XP

  • Professional 64-bit Edition (SP 2)
  • Professional and Home Edition (SP3)
  • Window XP Embedded (SP1), and Embedded for Point of Service

Windows Vista (Requires SP1 for v10)

  • Enterprise x86 and x64 Editions
  • Ultimate x86 and x64 Editions
  • Business x86 and x64 Editions
  • Home Premium x86 and x64 Editions
  • Home Basic x86 and x64 Editions

Windows 7

  • Home Premium
  • Professional
  • Ultimate
  • Enterprise

Windows Server 2003

  • R2 Server x64 Edition
  • R2 Server and Small Business Server
  • R2 Server Terminal Services
  • Server x64 Edition (SP 2)
  • Server and Small Business Server (SP 2)

Windows Server 2008

  • Web Server x86 and x64 Editions
  • Datacenter x86 and x64 Editions
  • Enterprise x86 and x64 Editions
  • Standard x86 and x64 Editions

Windows Small Business Server 2008

  • Standard and Premium Editions x64

Thursday 25 February 2010

Sage Accpac 56 is released

For Our Beloved Sage Accpac Indonesia Customer. Sage Accpac 56 has been released with lot of new features. Call us or email us to get more information about what 56 is about. Here are some quote from the release of Sage Accpac :
"As the world of business is constantly evolving, so must your business management
software. At Sage, we work to continually improve your experience with Sage Accpac
Integrated Suite and develop new functionality to help you get more out of your solution.
We work directly with our extensive customer base (over 45,000 companies and 200,000
users) to ensure our products work the way you do to improve processes and enhance
productivity. Over the past year, over 5,000 customers and partners worldwide have
been consulted through on-site visits, surveys, interviews, and observational studies in
our state-of-the-art usability laboratories. The results of this rigorous research are poured
into the product development process to help us design and build better software.
The key enhancements developed in Version 5.6 will help to automate workfl ow and
reduce costs throughout your organization, helping you accomplish more in less time.
How you can get your hands on all of the dynamic new features packed into this version?
Great news! You are entitled to software upgrades and maintenance updates as part of
your Sage Cover plan. Need to renew your plan?"call us at 7660349