tag:blogger.com,1999:blog-85583862024-03-08T14:06:29.061+08:00SAGE ACCPAC ERP Tips & TricksOnce in a while, you come across some problems while using Sage ACCPAC ERP system. Hopefully this blog will help you by providing some tips and tricks in making your work a little more easier, a little less stressful.DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-8558386.post-86349339365692180992008-05-03T22:46:00.003+08:002008-06-16T12:03:22.758+08:00F1 help key does not work after workstation setup<p></p><span style="font-family:trebuchet ms;">After doing a workstation setup, the F1 help key does not work. You get a 'Cannot display page' error message. To rectify this, create a reg file (e.g. F1Help.reg) and enter the following:<br /><blockquote></blockquote>Windows Registry Editor Version 5.00</span><br /><br /><span style="font-family:trebuchet ms;">[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\ItssRestrictions]</span><br /><span style="font-family:trebuchet ms;">"MaxAllowedZone"=dword:00000002</span><br /><span style="font-family:trebuchet ms;">"UrlAllowList"="\\\\servername\\Accpac\\Sage54\\help;file://\\\\servername\\Accpac\\Sage54\\help"</span><blockquote></blockquote><span style="font-family:trebuchet ms;">Please make sure that the number of backslash '\' is correct and the UNC path is correct. Save the file and copy to where Accpac is installed in the server. This reg file needs to be registered in the server and every workstation client PCs.<br /><br />As with any registry edit, care must be taken as any incorrect registry edit may render your PC inoperable.</span>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com215tag:blogger.com,1999:blog-8558386.post-766824792239267132007-04-01T14:15:00.001+08:002007-04-01T14:15:56.700+08:00Cannot open SQL server<p><font face="Tahoma"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);">Problems printing non-datapiped reports in Accpac Advantage Series 5.2<br> </span></font></p> <p><font face="Tahoma"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);">The following error is returned:<br> </span></font></p> <p><font face="Tahoma"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);">Description: Cannot open SQL server<o:p></o:p></span> </font></p> <p><font face="Tahoma"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);">All databases in 5.2 use DSNs. The problem occurs when multiple database types are used and the same database IDs' exist.<o:p></o:p></span> </font></p> <p><font face="Tahoma"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);">Example. A Saminc and a Samsys DSN already exist on a machine from a DB2 install. When the client accesses a Saminc database for Pervasive, a Saminc and a Samsys DSN will be created for Pervasive on the same machine. This creates duplicate DSNs on that machine and the above error will occur.<o:p></o:p></span></font></p> <p><font face="Tahoma"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);">Remove the duplicate DSNs from Datasource (ODBC) setup. If the database does exist with the same name for both types of databases, ie. Pervasive and DB2, then use DBDump and DBLoad for one of them to a different database ID.<br> <br> </span></font></p> DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com3tag:blogger.com,1999:blog-8558386.post-45435865099951502402007-04-01T13:47:00.001+08:002008-06-16T12:04:06.218+08:00Error "A Strong SA Password is Required for Security Reasons" When Trying to Install MSDE<p></p><p>When trying to install MSDE included with Sage Accpac HRMS, the following error may occur:</p><p>"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will no exit."</p><p>The installation then terminates.This error normally occurs on Windows Server editions, but may also occur on Windows XP.</p><p>Follow the steps below to setup MSDE manually:</p><ol><li>From the Start Menu, select Run...</li><li>In the Run dialog box, type in "cmd" and click OK.</li><li>Complete the following commands, pressing the Enter key after each command:</li></ol><ul><li>"x:" (where x is the CD Drive where the HRMS CD is inserted)</li><li>"cd\msde2000"</li><li>"setup SAPWD="password" INSTANCENAME="name" SECURITYMODE=SQL (where password is the password you choose and name is the identifier which you choose to call the MSDE installation) (NOTE: the password must be a strong password, meaning it must contain both numbers and letters).</li></ul><p>During the Accpac database setup, the login information will be as follows (unspecified fields can be left with their default values):</p><p>Server Name: <name>\<the><br />User Name: sa<br />Password: <the></the></the></name></p>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com3tag:blogger.com,1999:blog-8558386.post-44145076537608029842007-04-01T13:45:00.001+08:002007-04-01T13:45:59.023+08:00"Violation of PRIMARY KEY constraint 'ICUNIT_KEY_0'" when performing a DBload of data into MS-SQL<p class="MsoNormal" style="margin: 1.5pt 0in 4.5pt; line-height: 10.5pt;"><font face="Arial"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);">When importing data through DBLoad into a new Microsoft SQL database, the following error may occur:<br> <o:p></o:p></span></font></p> <p class="MsoNormal" style="margin: 1.5pt 0in 4.5pt; line-height: 10.5pt;"><font face="Arial"><span style="font-size: 9pt; font-family: Tahoma; color: red;"><br> INSERT (error = 127, native code = 2627) message: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'ICUNIT_KEY_0' Cannot insert duplicate key in object 'ICUNIT'</span><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);"><o:p></o:p></span></font></p> <p class="MsoNormal" style="margin: 1.5pt 0in 4.5pt; line-height: 10.5pt;"><font face="Arial"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);"><br> This error is not evident performing the same procedure in an environment running another database engine such as Pervasive. This problem may be related to an incorrectly defined Sort Order or Collation Name in the setup of the Microsoft SQL database.<o:p></o:p></span></font></p> <p class="MsoNormal" style="margin: 1.5pt 0in 4.5pt; line-height: 10.5pt;"><font face="Arial"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);"><br> To correct this problem, do the following: <br> </span></font></p> <p class="MsoNormal" style="margin: 1.5pt 0in 4.5pt; line-height: 10.5pt;"><font face="Arial"><span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);"></span>Set Sort order to Case Insensitive <span style="font-size: 9pt; font-family: Tahoma; color: rgb(102, 102, 102);"><br> Set collation name to Latin_general_bin</span></font></p> DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com4tag:blogger.com,1999:blog-8558386.post-19590751431594918472007-02-24T03:32:00.001+08:002008-06-16T12:04:36.820+08:00Pop-up CalculatorWhen you are in any number field, you can access the calculator by pressing the<strong> + </strong>key in the numeric keyboard or by pressing <strong>Shift + =</strong> (shortcut).<br /><br />You copy and paste your result directly to the number field using <strong>Ctrl + C</strong> (copy) and <strong>Ctrl + V</strong> (paste). If your calculator has a paste button, you can use it to paste the result directly to the number field without having to copy the result first.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com1tag:blogger.com,1999:blog-8558386.post-44524130952770637422007-02-24T03:19:00.001+08:002008-06-16T12:05:15.165+08:00Error Code: 2147467259 - Automation Error - Unspecified ErrorIf you receive the following error message:<br /><br />"Error code: 2147467259 Automation error - Unspecified error."<br /><br />This may be due to restrictions on the temporary directory paths that are set in the Environment Variables on the local workstation. Change the path to a shared temp directory such as C:\Windows\Temp.<br /><br />To do this, do the following:<br /><ol><li>Before proceeding, please close out of all ACCPAC® programs.</li><li>Click the Start button, point to Settings and select Control Panel (in Windows XP, skip the Settings step)</li><li>Double click to open the System icon</li><li>In the System Properties windows, click the Advanced tab</li><li>Click the Environment Variables button</li><li>In the User variables for [username] field, highlight the TEMP variable in the list and click the Edit button</li><li>In the Edit User Variable window, change the Variable Value field to C:\Windows\Temp</li></ol><p>Repeat the above steps for the TMP variable as well. If you want to retain the existing variable values, paste the current variables into notepad or other text file and save this file in a location where you can retrieve it at a later date if necessary. </p><p>Restart ACCPAC.</p>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com53tag:blogger.com,1999:blog-8558386.post-83989943341092542072007-02-24T03:03:00.001+08:002008-06-16T12:08:33.671+08:00Shortcuts and Function Keys<span style="font-family:arial;">Listed below are some Function Keys and Shortcuts that you can use in Sage Accpac ERP.</span><br /><span style="font-family:Arial;"></span><br /><span style="font-family:arial;">Using Function Keys - The following function keys or “Hot Keys” provide you with shortcuts:</span><br /><span style="font-family:arial;"><br /><strong>F1 Key</strong> - Displays online help. Available anywhere in ACCPAC.<br /><strong>F5 Key</strong> - Displays a finder window to select records from.<br /><strong>F7 Key</strong> - Displays the information for a record (go button).<br /><strong>F9 Key</strong> - Enlarge the selected record to display more information about the record (zoom Button).<br /><br />Using Menu Commands & Buttons:<br />Data entry forms display similar menus (for example, file and help menus) Thus you need to become familiar with only a few commands and buttons to work with ACCPAC data entry forms.<br />Advantage Series: Using Keyboard Functions instead of the Mouse:<br /><br /><strong>Alt + S</strong> - Use to save changes made to the displayed record.<br /><strong>Alt + D</strong> - Use to delete the displayed records.<br /><strong>Page Up</strong> - Navigation buttons<br /><strong>Page Down</strong> - Navigation buttons<br /><strong>Ctrl + Page Up</strong> - Navigation buttons<br /><strong>Ctrl + Page Down</strong> - Navigation buttons<br /><strong>Alt + E</strong> - Use to set criteria to specify records to display in the finder.<br /><br />Editing Columns of Data:<br /><br /><strong>Insert</strong> - insert a blank row to add a new record.<br /><strong>Delete</strong> - remove a selected row.<br /><strong>Tab</strong> or <strong>Enter</strong> - Go to the next or previous column in a list.<br /></span><strong><span style="font-family:arial;">Up</span></strong><span style="font-family:arial;"> or <strong>Down Arrows</strong> - Go up or down one row.<br /><strong>Right</strong> or <strong>Left Arrows</strong> - Go right or left in a column.<br /><strong>Page Up</strong> - Go to the top row in a view.<br /><strong>Page Down</strong> - Go to the bottom row in a view.<br /><strong>Home</strong> - Go to the first row in a list.<br /><strong>End</strong> - Go to the last row in a list.</span><a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com0tag:blogger.com,1999:blog-8558386.post-43332494936562477182007-01-29T18:31:00.001+08:002008-06-16T12:09:51.894+08:00Out of operating system limit - ACCPAC DOSWhen 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.<br /><br />To avoid this, review your settings:<br /><br /><u>Windows 95/98</u><br /><br />In the config.sys, make sure it contains the following:<br />device=c:\windows\himem.sys<br />device=c:\windows\emm386.exe ram<br />files=250<br />buffers=30<br />dos=high,umb<br /><br /><u>Windows ME/XP</u><br /><br />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:<br /><br />PerVMFiles=255<br /><br />Restart Windows ME/XP<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com18tag:blogger.com,1999:blog-8558386.post-65108803303535105222007-01-29T18:13:00.001+08:002008-06-16T12:12:29.609+08:00Missing CB Header/Title in Batch List / Entry screenOccasionally when you launch cashbook, the batch list / batch entry appears but without any column headers or titles.<br /><br />To resolve this, delete all files with $ in the user folder (normally located at C:\WINACCT\USER\UserID folder).<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com0tag:blogger.com,1999:blog-8558386.post-14480925554715832992007-01-29T00:10:00.001+08:002008-06-16T12:12:40.839+08:00Common database error codesOccasionally you may encounter the following error message:<br /><br />Database error code 2 - Missing / corrupted / bad database<br />Database error code 98 - Unable to connect to database<br />Database error code 108 - harddisk full / not enough space to carry out operation<br />Database error code 113 - access denied to database<br />Database error code 118 - file, page, or record is locked<br />Database error code 40960 - database driver not defined / unable to authenticate<br />Database error code 49153 - PC is not mapped to server or PC unable to access server<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com32tag:blogger.com,1999:blog-8558386.post-46754933217643374302007-01-29T00:05:00.001+08:002008-06-16T12:12:55.205+08:00Removing the print confirmation when printing directly to printerWhen 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.<br /><br />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:<br /><br />confirm on print=yes<br /><br />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.<br /><br />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.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com3tag:blogger.com,1999:blog-8558386.post-33607671995433877352007-01-28T23:57:00.001+08:002008-06-16T12:13:12.232+08:00Export to MS Excel format is not available<p>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?<br /><br />There are three possible reasons why the option to export to Excel is no longer available.<br />• A virus update was recently installed<br />• The Excel export DLL was moved, renamed or deleted<br />• A third party application was installed </p><p>NOTE: The name of the file that handles the exporting to Excel depends on the version of Crystal Reports in use.<br />• 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.<br />• CR 9 and 10 use crxf_xls.dll </p><p>To correct this behavior perform the following steps.<br />1. Quit Crystal Reports.<br />2. In Control Panel, double-click 'Add/Remove Programs'.<br />3. Select 'Crystal Reports' and then click 'Change'.<br />4. In the 'Crystal Reports Setup' dialog box, click 'Reinstall'. </p><p>If after performing the steps above, the Excel option is still unavailable in the 'Format' box then perform the following steps.<br />1. Quit Crystal Reports.<br />2. In Control Panel, double-click 'Add/Remove Programs'.<br />3. Select 'Crystal Reports' and then click 'Change'.<br />4. In the 'Crystal Reports Setup' dialog box, click 'Add/Remove'.<br />5. Expand 'Export Support' and then click the arrow next to 'Excel Format'.<br />6. Click 'Entire feature will be installed on local hard drive', then click 'Next' and then click 'Next' again.<br />7. Once the installation completes, click 'Finish'.<br />8. Open Crystal Reports and then export the report. </p>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com14tag:blogger.com,1999:blog-8558386.post-37209966416770479882007-01-28T23:50:00.001+08:002008-06-16T12:13:26.842+08:00P&L account setup as Balance SheetIf a P&L account code is setup with a wrong account type of BS (Balance Sheet).<br /><br />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.<br /><br />To rectify the problem, do the following steps:<br /><br />1. Do a journal entry to transfer the balance to Retained Earnings<br /> e.g. DR Sales 1,000.00<br /> CR Retained Earnings 1,000.00<br />2. Change the account type to IE (Income & Expense)<br />3. Do a journal entry to reinstate the balance<br /> e.g. DR Retained Earnings 1,000.00<br /> CR Sales 1,000.00<br /><br />Because the account type is now Income & Expense, ACCPAC will automatically do the closing entries to transfer to Retained Earnings.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com5tag:blogger.com,1999:blog-8558386.post-52216210504517745092007-01-28T23:40:00.001+08:002008-06-16T12:13:39.115+08:00Re-register ACCPAC DLLs and OCXsOccasionally 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.<br /><br />A very quick way to register DLLs and OCXs for ACCPAC is to do the following:<br /><br />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<br /><br />This program will register all ACCPAC DLLs and OCXs.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com16tag:blogger.com,1999:blog-8558386.post-31253338989640026712007-01-28T23:34:00.001+08:002008-06-16T12:13:53.397+08:00Error message when activating a moduleIf you are activating a module and the following error message is generated:<br /><br />Damaged data - Data dictionary inconsistent<br /><br />Do the following:<br /><br />1. Do a database dump and load<br />2. Login and do the module activation<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com1tag:blogger.com,1999:blog-8558386.post-53923606725955416102007-01-28T23:28:00.001+08:002008-06-16T12:14:08.014+08:00Assigning a network printer to port - lpt1Under Windows XP operating system - to assign a network printer to a local port e.g. lpt1, do the following:<br />Start > Run > type cmd > type<br />net use lpt1: \\computername\printername /persistent:yes<br /><br />To delete / remove assignment - do the following:<br />Start > Run > type cmd > type<br />net use lpt1 /delete<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com0tag:blogger.com,1999:blog-8558386.post-73780169287663779502007-01-28T18:07:00.001+08:002008-06-16T12:14:57.872+08:00Adding 7.0 Text Compatibility to Crystal Reports 9In Crystal Reports (CR) 8.5, there is an option called '7.0 Text Compatibility'. This option is no longer available in CR 9.<br /><br />Is it possible to add this option to CR 9?<br /><br />To access the '7.0 Text Compatibility' option in CR 8.5, on the 'File ' menu click 'Options'. You will see the '7.0 Text Compatibility' check box on the 'Reporting' tab.<br /><br />This option was removed from CR 9 but you can add this functionality by adding a registry value.<br /><br />====================<br />WARNING:<br /><br />Using the Registry Editor can cause serious problems that may require reinstalling the operating system. Use the Registry Editor at your own risk. It is recommended that you back up the registry before you edit it.<br />====================<br /><br /><br />Add the 'Use70TextCompatability' Registry Value<br /><br />1. On the 'Start' menu, click 'Run'. Type 'regedit' then click 'OK'.<br />2. Browse to the following registry subkey:<br />HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\SavedData<br />3. Right-click the 'SavedData' sub key and then click 'New' > 'String Value'.<br />4. Name this string value 'Use70TextCompatability'.<br />5. Right-click the 'Use70TextCompatability' string value then click 'Modify'.<br />6. Type 'Yes' in the 'Value data' text box then click 'OK'.<br /><br />After following these steps you will still not see the '7.0 Text Compatibility' check box in the 'Options' dialog box; however, having the new registry string value equal to 'Yes' in CR 9 is equivalent to selecting the '7.0 Text Compatibility' check box in CR 8.5. Changing this value to 'No' in CR 9 is equivalent to clearing the '7.0 Text Compatibility' check box in CR 8.5.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com3tag:blogger.com,1999:blog-8558386.post-18578454868593909372007-01-28T17:22:00.001+08:002008-06-16T12:15:55.098+08:00Receipts entered to wrong customer codeIf you have accidently entered a receipts to a wrong customer code, Use Bank Services, Return Customer Check process to reverse the posting.<br />Upon completing, enter a new entry and post the check to the correct customer code in A/R.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com4tag:blogger.com,1999:blog-8558386.post-18459366438129746392007-01-28T17:19:00.001+08:002008-06-16T12:17:16.873+08:00Steps to fix "Control not properly installed" errorThis error occurs when the user doesn't have sufficient security rights to the local workstations registry. Anyone who uses ACCPAC nees to be in the Power Users Group on the local workstation. ACCPAC users also need to have read/write access for the ACCPAC Data directory and access to the registry on the server.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com6tag:blogger.com,1999:blog-8558386.post-31048181655173469062007-01-28T17:16:00.001+08:002008-06-16T12:18:31.475+08:00Creating custom folder for all usersCreate the custom folder on the ACCPAC desktop of one user.<br />Once this is complete, copy the -c.ism file for that user to all other user folders on the system. The file can be found in the ACCPAC>USER>username directory where ACCPAC is installed.<br />Make sure you copy the correct company_c.ism file from one user to the next.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com0tag:blogger.com,1999:blog-8558386.post-50362065386828710712007-01-28T17:10:00.001+08:002008-06-16T12:19:03.788+08:00MDAC issue in CashbookMDAC cannot be re-installed, when a re-installation is attempted the message displayed is "MDAC has installed successfully" but the installation only takes a few seconds therefore not reflecting a true installation.<br /><br />MDAC can be located and downloaded from the Microsoft website: www.microsoft.com<br /><br />If MDAC is not installed correctly.<br /><br />Do the following:<br /><br />1. Go to directory c:\program files\common files\system\ado by typing in the path in the run dialog box (or via 'My computer').<br /><br />2. Highlight all the dlls.<br /><br />3. Then go Right ClickOpen. It will ask you what program to use to open and you select 'Microsoft Register Server'. If it does not appear click the browse button and select it from \winnt\system32. A message should appear for most of the files saying Registered Succeeded.<br /><br />Some of the files will give this error and some will say successful. That is ok as some of the dlls don't need to be registered.<br /><br />...Program Files\Common Files\System\ado\ms**.dll was loaded, but the DllRegisterServer entry point was not found.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com1tag:blogger.com,1999:blog-8558386.post-23406053322363118922007-01-28T17:03:00.001+08:002008-06-16T12:19:41.768+08:00Cashbook - Taking on Unreconciled TransactionsTaking on Unreconciled Transactions<br /><br />To ensure that your Cashbook Balance and Bank Statement Balance are correct, you must enter your Cashbook Balance, Unreconciled Transactions and a Contra Entry for the Unreconciled amounts. This is done via a take-on batch.<br />Note - We suggest that this take-on is done in the prior month, i.e. if you want to create your Cashbook for May, enter this take-on batch in April, so as to avoid reflecting these transactions on any reports.<br />Enter your Cashbook Balance, this can be taken from your manual Cashbook, if stand-alone, or taken from your Bank Account Balance in the ACCPAC for Windows General Ledger.<br />Enter all your unreconciled items i.e. all those transactions not yet on your Bank Statement.<br />Enter a Contra Entry for the exact amount of your unreconciled entries. If the total of unreconciled items is a net payment, your contra entry must be a receipt, (or vice versa).<br /><br />For Example:<br />Cashbook Balance 10,0000.00 (Credit)<br />Unreconciled Transactions 500.00 (Credit)<br />Contra Entry (Use any account code for entry) 500.00 (Debit)<br /><br />After completing the entry, print the batch from the File menu to check your batch details. Once your are satisfied that the batch is correct, proceed to post it.<br />Post this Take-on batch using the Post Batches function on the Entries Menu.<br />You must now reconcile the Cashbook Opening Balance amount as well and the Contra Entry amount. Go to your Cashbook display and use the Reconcile function to reconcile these amounts.<br />You can now check that the two bottom balances equal your Cashbook balance and Bank Statement balance respectively.<br />Finally, if interfaced to ACCPAC for Windows General Ledger, delete the batch created in ACCPAC G/L or print and Clear (without Transferring) the G/L Transactions, this will avoid duplication of transactions to the General Ledger.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com6tag:blogger.com,1999:blog-8558386.post-46795374749876022822007-01-28T16:48:00.001+08:002008-06-16T12:20:24.538+08:00Revaluation - General LedgerYou may encounter a situation where after running the GL revaluation process, an account with zero source amount generating revaluation entries.<br /><br />To resolve this, please follow the steps outlined below:<br /><br />Run the revaluation as normal > General Ledger > G/L Periodic Processing > Create Revaluation Batch<br />After the batch have been created by the revaluation process, click Close > click Close<br />Go to GL Batch List > General Ledger > G/L Transactions > Batch List<br />Open the GL batch created by the revaluation process.<br />At the G/L Journal Entry > select the entry that should not have any revaluation > unselect the Auto Reverse box (There should be NO tick in the box)<br />Save the entry and proceed to do the same for any other entries within the batch > Click Close after you have finished amending the entries.<br />Post the batch > After the batch has been successfully posted, re-open the posted batch<br />Select the wrong entry > click Reverse<br />Click New icon > Type/amend the batch & entry description as required<br />Click Process<br />Click Close when the message window appears<br />Click Close to close the ‘Reverse Journal Entry’ window<br /><br />Select the next wrong entry and repeat the above process (except you do not have to create a new batch, you can select the batch you have previously created above e.g. Batch #002336)<br /><br />After completing all the reversal entries, open the Reversal Batch > General Ledger > G/L Transactions > G/L Batch List > Open the Reversal Batch<br />At the Currency field > amend the USD currency to the home currency of the database you are in (e.g. AsiaPac = NTD, Thailand = BAH, etc) for both detail lines<br />Click Save > Repeat for all entries you have generated the reversal entries > Click Close<br />Post the Reversal batch.<br /><br />This steps should eliminate the ‘recurring revaluation entries’ even though there is no source balances. When you run the next period revaluation, these entries should no longer recur.<a href="http://tinyurl.com/3dn8qv"><br /></a>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com30tag:blogger.com,1999:blog-8558386.post-21753063334498554992007-01-28T16:32:00.002+08:002008-06-16T12:21:13.591+08:00Year End Processing<p>Cashbook Year End Procedure<br /><br />At the Clear Reconciled Entries function there is a Year End option. If you wish to run the Year End Option, toggle this option on. This option will:<br /><br />1. Update your fiscal calendar to the next year.<br />2. Re-set the batch number to 1 (this can also be performed when clearing your batch status report). Take note that if you reset your batch number to 1, you will not be able to see your posted batches.<br />3. Move the current balances in your Cashbook G/L accounts to the previous year. (If not interfaced to ACCPAC)<br />4. Move the year-to-date totals in your miscellaneous file to the previous year.<br /><br />Set the clearing date to 01/01/1980 if you do not want to clear any transactions.<br /><br />AP <a href="mk:@MSITStore:E:/ACCPAC50/HELP/AP50AENG.chm::/AP_perd/F_year_end_fld_lst.htm"></a><a href="mk:@MSITStore:E:/ACCPAC50/HELP/AP50AENG.chm::/AP_perd/F_year_end_fld_lst.htm"></a>Year End Procedure<br /><br />Use the Year End form to:<br />· Reset batch numbers, so that the next batch you create of all types will use number 1.<br />· Move vendor activity statistics for the current year into the previous year, and zero the totals for the new year.<br />· Reset to 0 (zero) the Total Invoices Paid, Number Of Checks, and the Total Days To Pay fields in the Vendor Activity Statistics tab, in the Vendors form.<br />Before you start<br />For the year you are closing:<br />· Post all outstanding batches.<br />· Create all outstanding general ledger batches, and print the G/L Transactions report.<br />· Print all unprinted posting journals and use the Clear History form to clear the data for the posting journals.<br />· Close all other ACCPAC Accounts Payable forms and ask other users to leave Accounts Payable.<br />Tips<br />You can use the Year End form at any time of year if you need to reset batch numbers. However, you must first complete all the steps listed in the preceding section, "Before You Start."<br />We recommend that you clear activity statistics and the Total Invoices Paid and Total Days To Pay totals only at the end of your fiscal year.<br />To use the Year End form<br />1. Select the options you wish to use.<br />2. Choose Process.<br /><br />AR <a href="mk:@MSITStore:E:/ACCPAC50/HELP/AR50AENG.chm::/AR_perd/F_year_end_fld_lst.htm"></a><a href="mk:@MSITStore:E:/ACCPAC50/HELP/AR50AENG.chm::/AR_perd/F_year_end_fld_lst.htm"></a>Year End<br />Use the Year End to:<br />· Reset batch numbers, so that the next batch you create of any type will use number 1.<br />· Move customer and national account activity statistics for the current year into the previous year, and zero the statistical totals for the new year.<br />· Set recurring charge Amount Invoiced To Date totals for the year to zero, so that you can resume invoicing the charges in the new year.<br />· Reset to 0 (zero) the number in the Total Days to Pay and Total Invoices Paid fields in customer and national account activity statistics.<br />Before you start<br />For the year you are closing:<br />· Process all billing cycles.<br />· Post all outstanding batches.<br />· Print all unprinted posting journals to a file or a printer, then use the Clear History form to clear the data for the posting journals.<br />· Create all outstanding general ledger batches (if you do not use the option to create the batches during posting), then print the G/L Transactions report.<br />· Close all other ACCPAC Accounts Receivable forms and ask other users to leave Accounts Receivable.<br />To use the Year End form<br />1. Select the options you wish to use.<br />2. Choose Process.<br />Tips<br />You can use the Year End form at any time of year if you need to reset batch numbers or clear recurring-charge amounts. However, you must first complete all the steps listed in the preceding “Before You Start” section.<br />We recommend that you clear activity statistics only at year end.<br /><br />GL Year End Procedures<br />At the end of a fiscal year, you must close the income and expense accounts for the old year, and open them for the next fiscal year. To maintain clear and complete accounting records, there are other procedures you may also wish to follow at year end.<br />To prepare for year-end processing:<br />· Post outstanding batches for the year you are closing.<br />· Print and clear all outstanding posting journals.<br />· If desired, print financial statements and the other reports you require for your records.<br />· If desired, consolidate posted transactions.<br />· Make sure you have specified the number of years you want to keep fiscal sets and transaction detail (on the Posting tab of the G/L Options form), and the retained earnings accounts to which you will close income and expense accounts.<br />· If you use multicurrency accounting, update exchange rates and revalue account balances, if needed.<br />· Back up data.<br />To complete year-end processing:<br />1. Use the Create New Year form to:<br />· Create and post transactions to transfer the balances in the income and expense accounts to retained earnings.<br />· Enter the opening balances for the General Ledger accounts for the new year.<br />2. Print and clear the Batch Status report and the posting journal created by Create New Year.<br />3. Back up data.<br />4. Use the Period End Maintenance form to delete inactive accounts and prior-year fiscal sets and transaction details that have been kept for the number of years specified on the Posting tab of the G/L Options form.<br /></p>DeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.com2