PT. Microtek Informa Solusindo is a premier solution provider for SAGE Accpac ERP accounting over 12 years in Indonesia. We provides comprehensive service and support for small and mid-market enterprises to assist in the planning and budgeting, new implementations, upgrades, customizations and ongoing maintenance for SAGE ACCPAC ERP and SAGE ACCPAC CRM.
Friday, 15 February 2013
Sage ERP Accpac is Now Sage 300 ERP
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
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
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
Tuesday, 26 June 2012
License Registration in Accpac
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
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
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
- 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 :
- Click Start in Windows, then Run. Type "regedit" and click OK to open up the Registry Editor.
- Expand HKEY_CURRENT_USER\SOFTWARE\ACCPAC International, Inc.\ACCPAC\DESKTOP.
- 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.
Tuesday, 3 August 2010
"Runtime error '429': ActiveX component can't create object" Error When Trying to Access Statement Designer
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.
- Open Excel.
- Select Add-Ins from the Tools menu.
- Click the Browse button and browse to the General Ledger program directory. For example, if version 5.5 of Sage
- 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.)
- Once in the proper directory, select accpacfr550.xla and click OK.
- 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.
- Right-Click the Accpac shortcut
- Under the General tab, enable the Run As Administrator option.
- Click Start, right click Computer, choose Properties
- Choose Advanced System Settings
- Click "Settings" under "Performance"
- Go to the tab "Data execution prevention"
- The selection on that tab is normally on "Turn on DEP for all programs", leave it as is
- Click on Add at the bottom
- Browse to accpac installation folder, then the Runtime folder
- Confirm that accpac.exe file shows up in the list and has a check mark in front of it
- Click OK to confirm
Wednesday, 7 July 2010
Create Databases and Datasource Names (DSNs) in Pervasive.SQL
- Click Start > All Programs > Pervasive > Pervasive.SQL Control Center.
- In the Common Tasks section in the right panel, click New Database. The New Database window opens.
- In the Server field, click the down arrow, select a server from the list, and then click Next.
- 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.
- In the Location field, type the path to the folder you created for the database.
- In the DBName Options section, select Bound and Create Dictionary Files. Do not select the option, Relational Integrity Enforced, as Sage Accpac checks integrity.
- 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.
- Click Finish.
- Create other databases (for example, if you created a system database, now create a company database).
- 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
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).
Good luck and don't forget one more important part "Pray" :D
Wednesday, 26 May 2010
Ops Inquiry 56
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
"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
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
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
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
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
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??
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.