Friday, 15 February 2013

Sage ERP Accpac is Now Sage 300 ERP

Dear Our Customer,

Be Reminded we are having change on our Sage Accpac product  below are the change:
Sage ERP Accpac is Now Sage 300
Sage ERP Accpac 100 is Now Sage 300 Standard ERP
Sage ERP Accpac 200 is Now Sage 300 Advanced ERP
Sage ERP Accpac 500 is Now Sage 300 Premium ERP

We will be using this name starting on the release of Sage 300 ERP 2012.

Year End Closing

Customers,

In Accpac Year End processing consist of 2 part which is Mandatory and Optional. For those optional one mostly is resetting batch no, clearing history, clearing posting journal. But For the mandatory One If you have not processed it , it will Stop your transaction for upcoming Year . So Here are 2 process which is mandatory in the Year End Closing :
1. General Ledger
Create New Year function is to close all your income statement account against Retained Earning and create opening balance for the upcoming Years. This process is done Automatically in the system. The Menu Can Be Found Under :
  • G/L Periodic Processing
  • Create New Year
2. Fixed Asset
Fixed asset Also Required a Year End Processing to create the new Fiscal Year. Without this you won't be able to record New Acquisition or other transactions. The menu can be found under:
  • A/M Periodic Processing
  • Year End Processing
After This two is run then you can continue to use your Sage Accpac. 

Tuesday, 26 June 2012

License Registration in Accpac

License Registration either Lanpak or module is now easier. Starting with version 56 and above. The installation come into 1 DVD with all the core module included. So when we run the installation we just need to check which module we need and the system will directly installed it. Compare to older version where each module we install it will ask for license. But now the license only entered after the installation finished or from the License menu under Sage 300 ERP help files.

So today we are going to discuss about licensing from inside Sage 300 ERP (Formerly Sage ERP Accpac) :
1. Click On The help menu in the main screen and then select Licenses
 2. Select License Manager
 3. You will see the below screen, this is where you put your company name and dealer name.
  • Client ID = unique ID given to each Sage 300 Customer, you can find this under your license
  • Company = Registered Company name(case sensitive)
  • License to= Company Name or Person in Charge
  • Dealer = PT. Microtek Informa Solusindo
  • CC =PT. Microtek Informa Solusindo
  

 4. Second Tabs is for all module licenses. Just double click on the column to fill in the license. When succesfull it will written as Activated
 5. 3rd Tab is used to register Lanpak. To add line just press the "INSERT" button on keyboard and then select the License Type and Count then enter the Serial Number And Activation code.

Unlike The older version, Lanpak now does not need installation. Just Enter the activation on the License Manager and Done. That's all hope this help you all our beloved customer.

Thursday, 17 March 2011

What is called Portal in Sage ERP Accpac 6.0

Sage ERP Accpac 6.0 is officially released for Indonesia's customer. One of the most awaited feature is the PORTAL. Then for those who never watch the video posted before , take a look on the screen shot taken for explaining what is PORTAL. And what can you get from this 60 Feature.

Image 1.1 Main PORTAL screen


Image 1.2 Detail reporting available from clicking on the chart


Image 1.3 Report Generated as a result of clicking the chart


Image 1.4 Query function

Query can either be preview on the screen or exported to an excel,csv,pdf.

Feel free to contact us at 62-21-7660349 for more detail information or even have an upgrade to the Latest version of Sage ERP Accpac.

Monday, 31 January 2011

Make Accpac load faster in a Citrix\TS environment

For customer that are using citrix or terminal server connection, there are several things that you can do to make Accpac load faster for the first time :
  • Removing the splash screen. There are 2 splash screen one belong to Accpac and the other one belong to Pervasive if you are using Pervasive database. Here how you can remove the splash screen :
  1. Click Start in Windows, then Run. Type "regedit" and click OK to open up the Registry Editor.
  2. Expand HKEY_CURRENT_USER\SOFTWARE\ACCPAC International, Inc.\ACCPAC\DESKTOP.
  3. If Splash Screen exists already on the right hand pane of the window, change its value from "Yes" to "No". If it does not, right click the right hand pane of the window. Select New, then String Value. Name it "SplashScreen" and set its value to "No".
  • Removing JPEG File : Under Accpac folder search for folder called ASXXA\ENG there are 2 jpeg file, you rename/delete this two jpeg.
There you go how you can make it faster now.

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

Friday, 10 July 2009

How To Create Sage Accpac SQL Data

There are several types of database that Sage Accpac support like Pervasive SQL, Microsoft SQL, Oracle database. This time I'm going to give instruction on how to create SQL database and then link it to Sage Accpac.
First On the SQL :
Create 2 database : 1 for system and the other one is for data. Normally myself will put the name like XXXSYS, and then for data is XXXDAT
Second : Create ODBC
1. Open Control Panel\Administrative Tools\Data Sources(ODBC)
2. Select System DSN Tab and then click Add
3. Choose SQL Server Then Click Finish
4. Put Name for the ODBC like Accpac , select the SQL Server name from drop down list
5. Click Next put in the SQL user id or if you use windows user id then click next
6. Just let everything on default until Finish.
Third : Sage Accpac Database Setup
1. Open Start\All Program\Sage Accpac\Database Setup
2. Put in Admin Password
3. Click New
4. Put in database ID first will be the XXXSYS , Database Format : Microsoft SQL, Database Category : System
5. Click Ok
6. Choose Data Source that we just created in this case Accpac
7. Put in SQL User id and password
8. Put in Database Name XXXSYS then click ok
9. Next Click New again and this time is for XXXDAT, Database Format Microsoft SQL, Database Category Company and system database id is XXXSYS.
10. Follow the same step from 6-8 then click ok.

There now you have 1 new database and you are ready to go. Now open Sage Accpac and start the database creation module by module. Good Luck.

Friday, 26 June 2009

Having trouble with Windows Firewall when configuring Sage Accpac ERP Web Deployment?

Web Deployment issues are among the most popular topics we discuss in Customer Support.

A common error message that users encounter when logging onto an Accpac ERP 5.4 or 5.5 servers via Web Deployment is:
Error occurred when connecting to Sage Accpac Server

Whenever users need to access the Sage Accpac Web Deployment either internally or externally on their network, ports 9000 to 9180 (by default) are opened on the web server.

If external connection is desired, the externally facing router or gateway could be configured to properly redirect all traffic from these ports to the web server.

By default, when Windows Firewall is enabled, these ports are blocked. It is never a good idea nor is it a best-practice to turn off the firewall, even during testing.

We could not find a convenient tool to easily open a range of ports for Windows Firewall. For that, the Support team developed a utility which will allow users to do just that -- open/close a range of ports for Windows Firewall. At this time, it has been tested for following operating systems:

  • Windows XP x32 and x64
  • Windows Vista x32 and x64
  • Windows 2003 Server x32 and x64
  • Windows 2008 Server, x32 and x64

If you needed the file please contact us. Should you run into the above scenario, try it out and come back and tell us about your experience. Did it resolve the issue for you? Could we fine-tune the utility further to make it more user-friendly? We would love to hear from you.

Thursday, 18 June 2009

"Error pcsStart Error" when processing a function

Summary

When attempting to process a function in an Advantage Series module such as Day End processing in Inventory Control or batch posting in the General Ledger, one or more of the following errors may occur.

Error pcsStart Error
Error pcsStart error (1046 ICDEP1.C)
Error pcsStart error (1224 GLJPSTI.C)

Subsequently, the process may not complete and a restart record may be created.

Solution

Rename the RESTART.ism file located in C:\Program Files\ACCPAC\SITE folder(This is the default location but your particular installation may be to a different directory). Once that is done, reprocess the function that originally generated the error.

Note: The RESTART.ism file will be recreated automatically as the program needs it however, it will not retain any of your previous restart records. It may be necessary to process all outstanding restart records prior to renaming the file

Wednesday, 1 April 2009

Speed...Speed and More Speed

With the release of 55 , Sage Accpac has done a series of test for speed improvement.Test was done in testing and production area to make sure the program run faster compare to previous versions. Both the controlled environment testing and the production environment installations of Version 5.5 proved to be very successful.Performance testing was conducted on key areas of Sage Accpac ERP including General Ledger, Accounts Receivable, Accounts Payable, Project Job Costing.

Key functionality in each of these areas was tested using Version 5.4 with the latest service pack and Version 5.5. Tests were conducted in a controlled environment using identical hardware and software configurations for both versions’ tests. In many cases, multiple scenarios were set up to replicate different real world situations – different combinations of numbers of records, numbers of Details, and numbers of Optional Fields.

So here are the Result of the testing:
Overall, the series of tests determined that in all of the key functionality areas, Version 5.5 performed better than Version 5.4. Some of the findings* include faster performance in these operations:
-posting AP invoices (faster by 27%);
-importing AP payments (60%);
-posting AR invoices (41%);
-importing AR receipts (68%);
-importing GL journal entries (28%);
-PJC AP payments (77%);
-OE Day End Processing after invoices (42%).

Here are some samples of performance improvements that were experienced in the test environment:
- Post 50 AR invoices with 500 Details 90 seconds faster than on Version 5.4
- Post 50 AP payments with 500 Details 6 minutes faster
- Post 50 AR receipts with 500 Details nearly 8 minutes faster
- Import 20 GL entries with 1,000 Details (and Optional Fields) 3 minutes faster
- Enter 20 shipments with 25 Details 58 seconds faster
- Post 200 line revenue recognition in Project & Job Costing almost 9 minutes faster

So need more speed? Upgrade you Sage Accpac to the latest version

Monday, 16 February 2009

Partially Transfer Items Using The Inventory Control Transfer Function

How to partially transfer items using the Inventory Control (I/C) Transfer function. Partial transfer occurs when the requested quantity is more than the quantity available in inventory.
Solution

The following are the steps to do partial transfer of items:

1. From the I/C Transaction folder, click Transfers.
2. Click the New icon to create a new document.
3. For Document Type select Transfer.
4. In the detail grid, enter values in the Item Number, From Location, To Location, Requested Qty and Transfer Quantity fields.
To simulate partial transfer, enter a transfer quantity that is less than the requested qty.
For example:
o Enter 10 for Requested Quantity.
o Enter 7 for Transfer Quantity.
o This results to an outstanding quantity of 3.
5.Click Post to post and generate the document number.
6.Select "No" to the question "Do you want to delete this transfer after posting?"

At this point the user can no longer open the document and transfer the outstanding quantities. Instead, to complete the transfer, user can create a new document and use the incomplete transfer as reference transfer number.

Perform the following steps to complete the transfer:

1. Click on the New icon to create a new document.
2. For Document Type select Transfer.
3. For Transfer Number enter the transfer number of the incomplete document. Based on the example, the 'Outstanding Qty' should have 3 and 'Transfer Quantity' should also have 3.
4. Click Post to complete the transfer of the outstanding quantities.

Tuesday, 10 February 2009

Sql 2008 is now fully Supported

With the release of Sage Accpac 55 Product Update 2 , SQL Server 2008(32bit) is now fully supported for Sage Accpac 55.

For customers that would like to use Sql server 2008 please contact our office at 7660349 to get the latest product update for Sage Accpac 55.

Monday, 2 February 2009

Does Accpac has manufacturing??

This question has been asked by many people , does Accpac support manufacturing?
The answer is YES, Misys manufacturing is a 3rd party company that specialized in manufacturing system since the dos version. In the Windows Version Misys introduce 3 different level of product :
Level 1 : Basic manufacturing(include multilevel BOM, Purchase Order)
Level 2 : Production Planning and scheduling(PPIC)
Level 3 : Machine capacity,BOM Routing

In misys, the system support 15levels of BOM and it completely help you on planning what to produce, when to produce, when to buy, how many to buy, from whom you need to buy.

So decide on your need or if you confused feel free to ask us, we will gladly to help you.