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

Cashbook 54 SP 7

On 31Oct2008 cashbook 54 has release it's newest service pack, Service Pack 7 with the following update :

• Fixed - Post - Multicurrency - Unapplied Cash entries were not posting in Accounts Receivable.
• Fixed - Post - To correctly locate the cheque to update in bank reconciliation after printing a batch using the same cheque numbers that had been previously voided.
• Fixed - Post - When entering an AR Refund in Cashbook for R 100.00 and allocating R 50.00 to 2 different Credit Notes for the same Customer, the AR Refund Batch is generated with an AR Refund Amount of R 200.00 with R100.00 allocated against each Credit Note.
• Fixed - Post - If the Customer and Vendor numbers are the same and the invoice numbers in both the Customer and Vendor accounts are the same it results in the allocation against the Customer account reflecting as Pending in the Vendor account.
• Fixed - Post - When posting a transfer batch with a blank reference number it created an error batch for the receiving bank which could not be edited or deleted.
• Fixed - Post - Bank Transfers - A transfer batch with a blank reference resulted in an error batch being created that could not be edited.
• Fixed - Batch Entry - Allow editing of batch control description and single reference details in a retrieved batch.
• Fixed - Batch Entry - Web Client Only - The default tax code was giving an error in a tax batch.
• Fixed - Batch Entry - Batch Entry AP allocation picked up Pending Adjustment amount when selecting the Pending allocation in subsequent allocations.
• Fixed - Batch Entry - Allocations against Job Related invoices which contain 0.00 amount lines.
• Fixed - Batch Entry - PJC - when the Project has an Accounting Method of Accrual-Basis the cost account defaults to the "Cost of Sales" account setup in the Account Set, and when the Project has an Accounting Method other than Accrual-Basis the cost account defaults to the "Work in Progress Account" setup in the Account Set.
• Fixed - Batch Entry - After entering a Distribution Code and tabbing onto the grid, the grid was not accepting focus correctly.
• Fixed - Retrieve from Other Systems - Cashbook AR refunds were incorrectly being retrieved.
• Fixed - Retrieve from Other Systems - AR Error Batch with entry which originated in Cashbook being retrieved to Cashbook when retrieving AR entries.
• Fixed - Print Tax - Transfer to ACCPAC Tax Services of multicurrency tax lines.
• Fixed - Print Tax - When Transferring Cashbook Tax Tracking to Sage Accpac Tax Services the Cashbook Reversals transferred as a 0.00 amount entry.
• Fixed - Bank Reconciliation Reversals - Cashbook only partially returns AR Receipt reversals in Bank Services leaving the entry status "In Transit".
• Fixed - Bank Reconciliation Reversals - Cheques with the same vendor,reference and amount but different dates were reversing the incorrect line in ACCPAC.
• Fixed - Bank Reconciliation Reversals - Single Reference cheque batches were not reversing correctly in ACCPAC.
• Fixed - Bank Reconciliation Reversals - Redesigned to handle large EFT SR batches. The entry is now only located in Bank Services if it is contained in a deposit or Single Reference batch and the 'Reverse' column is clicked to 'Yes'.
• Fixed - Bank Reconciliation Reversals - To use the reversal fiscal year in the reversed line.
• Fixed - Batch Import - When the next batch number to be created exceeded 32767, then an error was generated: "Invalid field 35".
• Fixed - Batch Import - Importing Unapplied Cash entries for 2 different Customers. Only the first entry is imported as Unapplied Cash, the second entry is imported as "Select" Mode.
• Fixed - Batch Import - Importing an allocation with more than 2 payment numbers in a particular payment schedule to the same invoice.
• Fixed - Batch Import - GL Transfer - The "There are no G/L transactions to consolidate" message being erroneously displayed when selecting GL Transfer and Consolidate Before printing.
• Fixed - Print Cheque/Receipt/Deposit Forms - Printing Cheques off-line resulted in the Cashbook Transaction Header table Fiscal Year field being updated with "0000".
• Fixed - Integrity Check - To check batch sub-detail.
• Fixed - Integrity Check - Language resource errors.
• Fixed - Batch Listing Report - Stops allocations going to second page if more than 32 lines.
• Fixed - G/L Transfer - Auto Post in G/L was causing an error if G/L Options were set to require printing before posting.
• Enhancement - Online Printing - Form now saves last settings for Receipts/Deposits.

If You need this update, please contact us and we will arrange an update file for you.