Out of operating system limit - ACCPAC DOS

When processing a transactions (e.g. order entry), an error message is generated 'Out of operating system limit'. This is due to the operating system settings.

To avoid this, review your settings:

Windows 95/98

In the config.sys, make sure it contains the following:
device=c:\windows\himem.sys
device=c:\windows\emm386.exe ram
files=250
buffers=30
dos=high,umb

Windows ME/XP

MS DOS settings are not set inside the config.sys. The FILES setting is not used but the PerVMFiles settings is used. This setting increases the number of available file handles in each MS DOS virtual machine. To set the setting, add the following line to the System.ini file, under the [386Enh] section:

PerVMFiles=255

Restart Windows ME/XP

Missing CB Header/Title in Batch List / Entry screen

Occasionally when you launch cashbook, the batch list / batch entry appears but without any column headers or titles.

To resolve this, delete all files with $ in the user folder (normally located at C:\WINACCT\USER\UserID folder).

Common database error codes

Occasionally you may encounter the following error message:

Database error code 2 - Missing / corrupted / bad database
Database error code 98 - Unable to connect to database
Database error code 108 - harddisk full / not enough space to carry out operation
Database error code 113 - access denied to database
Database error code 118 - file, page, or record is locked
Database error code 40960 - database driver not defined / unable to authenticate
Database error code 49153 - PC is not mapped to server or PC unable to access server

Removing the print confirmation when printing directly to printer

When printing to a printer, the printer driver confirmation window prompts the user to enter the number of copies to print. In addition, it offers the option to change the printer options for the job at print time. If you are in a secure environment where printing privileges are restricted for security or other reasons, you may not want to offer certain users the ability to print multiple copies of a report.

You can bypass this prompt and force ACCPAC to only send one copy to the printer, on a user-by-user basis. In each user's PLUSUSER.INI file, you should find in the [options] section the following line:

confirm on print=yes

Changing the value of the above setting to "no" removes the printer driver prompt at print time and forces the document through directly to the specified printer.

If you are intending to use this feature to restrict the number of copies a user can print of a specific report, this setting alone will not be sufficient, as the user would still be able to return to the print UI and select the reprint option; that would enable them to generate a duplicate copy. To prevent this, you will need to customize the UI through Administrative Services -> UI profile Maintenance to remove the reprint select boxes in each of the print UIs, when you would like to restrict this function.

Export to MS Excel format is not available

In Crystal Reports 8.5 and later, the option to export to Microsoft Excel format is not available in the 'Format' box of the 'Export' dialog box. Previously, the option was available. Why does this behavior occur and how can the export to Microsoft Excel format be made available?

There are three possible reasons why the option to export to Excel is no longer available.
• A virus update was recently installed
• The Excel export DLL was moved, renamed or deleted
• A third party application was installed

NOTE: The name of the file that handles the exporting to Excel depends on the version of Crystal Reports in use.
• CR 8.5 may use both u2fxls.dll and crxf_xls.dll depending on the different Monthly Hot Fixes, Weekly Hot Fixes and/or Service Packs that have been applied. If you are using u2fxls.dll, it is located in the C:\WINNT\CRYSTAL folder. If you are using crxf_xls.dl, it is located in the C:\Program Files\Common Files\Crystal folder.
• CR 9 and 10 use crxf_xls.dll

To correct this behavior perform the following steps.
1. Quit Crystal Reports.
2. In Control Panel, double-click 'Add/Remove Programs'.
3. Select 'Crystal Reports' and then click 'Change'.
4. In the 'Crystal Reports Setup' dialog box, click 'Reinstall'.

If after performing the steps above, the Excel option is still unavailable in the 'Format' box then perform the following steps.
1. Quit Crystal Reports.
2. In Control Panel, double-click 'Add/Remove Programs'.
3. Select 'Crystal Reports' and then click 'Change'.
4. In the 'Crystal Reports Setup' dialog box, click 'Add/Remove'.
5. Expand 'Export Support' and then click the arrow next to 'Excel Format'.
6. Click 'Entire feature will be installed on local hard drive', then click 'Next' and then click 'Next' again.
7. Once the installation completes, click 'Finish'.
8. Open Crystal Reports and then export the report.

P&L account setup as Balance Sheet

If a P&L account code is setup with a wrong account type of BS (Balance Sheet).

After doing a Year End, the error was discovered i.e. the P&L account code did not transfer the balance to the Retained Earnings.

To rectify the problem, do the following steps:

1. Do a journal entry to transfer the balance to Retained Earnings
e.g. DR Sales 1,000.00
CR Retained Earnings 1,000.00
2. Change the account type to IE (Income & Expense)
3. Do a journal entry to reinstate the balance
e.g. DR Retained Earnings 1,000.00
CR Sales 1,000.00

Because the account type is now Income & Expense, ACCPAC will automatically do the closing entries to transfer to Retained Earnings.

Re-register ACCPAC DLLs and OCXs

Occasionally after reinstalling ACCPAC, you may find that ACCPAC takes a longer time to launch an operation after you double-click an icon. This maybe due to DLLs or OCXs not properly registered during the installation process.

A very quick way to register DLLs and OCXs for ACCPAC is to do the following:

Launch Windows Explorer > Browse to the folder you installed ACCPAC e.g. C:\PLUSWIN or C:\ACCPAC or C:\Program files\ACCPAC > Select the Runtime folder > Locate the Regacc.exe file > Double-click the file

This program will register all ACCPAC DLLs and OCXs.