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.

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.

"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

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

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.

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.

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.

GL Security

Now in Sage Accpac General Ledger 55A included a module called GL Security. Here I will explain a little bit on function of the GL Security that was built in to the core module right now.
So if you feel that you need one of this security than you should consider on upgrading to 55 :
1. Security by account which allow a specific account can only be view, update by a specific person/group
2. Security by segment which allow a specific range of account based on segment to be viewed, update by a specific person/group.

This GL Security will remove the account from the screen if the user does not have the privileges to access it.

Norming 55 is now Available

Dear All Our Beloved Customer,

Norming 55 is now available, you can contact us to get the new version of Norming fixed asset with some of the new feature included in the current release :

• Fully Integrated With Sage Accpac ERP 55
• Exchange gains/losses can be recognized on revaluation
• Moves the disposal Cost and proceeds accounts to cost center
• Multiple depreciation expense account for 1 cost center, so we can allocate base on a specific percentage of cost to different account
• Maintain The original Purchase Cost for assets
• Converts PO Item into single or multiple assets
• Includes existing add on as an acquisition type in asset acquisition entry
• And much more

So what are you waiting for come and grab your cd for update..

Cashbook 55 SP 1

On 30 October 2008 , Cashbook 55 has release the newest service pack. Service Pack 1 which has the following update :

• Fixed - Batch Entry - Web Client Only - Tax On - An invalid field ID error code was generated when using a source code with a default tax code.
• Fixed - Batch Entry - The pending amount in the allocation screen was incorrect for customers and vendors having the same customer/vendor code.
• Fixed - Batch Entry - After entering a Distribution Code and tabbing onto the grid, the grid was not accepting focus correctly.
• Fixed - Bank Reconciliation - Reversals - Accounts Receivable Only - An AR entry's status in Bank Services was not correctly being changed when reversed in CB.
• Fixed - Bank Reconciliation - Reversals - Accounts Payable Only - Same vendor/reference/amount - resulted in incorrect line being reversed.
• Fixed - Bank Reconciliation - Single Reference/Deposit Entries - Only locates in Bank Services if 'Yes' is selected for that row to allow faster processing in large single EFT entries.
• Fixed - Post - Refund batches were doubling up if allocated to more than one credit note.
• Fixed - Post - To correctly update Partially Posted transactions that were first Voided when printed.
• Fixed - Post - Bank Transfers - A transfer batch with a blank reference resulted in an error batch being created that could not be edited.
• Fixed - When posting a Cashbook batch in Accounts Payable with an allocation against a Job Related invoice the message "The payment amount for document xxx is not fully distributed" was returned.
• Fixed - Print Cashbook - When printing Bank Reconciliation or Bank Charges by period, an invalid field error was being returned.
• Fixed - Batch Import - A field ID error was generated when the batch number being created exceeded 32767.
• Fixed - Miscellaneous Codes - Wasn't importing EFT details.
• Fixed - Cheque/Receipt/Deposit Forms - Bank totals weren't being updated correctly.
• Enhancement - Online Printing - Form now saves last settings for Receipts/Deposits.
• Fixed - G/L Transfer - Auto Post in G/L was causing an error if G/L Options were set to require printing before posting.
• Fixed - Batch Listing Report - Stops allocations going to second page if more than 32 lines.

Contact us immediately if you need this file. Call us at 021-7660349