| 1. Transfer from Cashbook to GL failed. | Top |
|---|---|
| Question: When transferring the Cashbook transactions to General Ledger I receive the following error message: "Cashbook batch has not been updated to GL because it has failed the GL verification process. Transactions will remain in the GL Listing." | |
|
Answer: In Cashbook you can select to create G/L Transactions During Posting or On Request Using Print G/L Transactions. When Cashbook updates the ACCPAC General Ledger we do it through ACCPAC's views. The views will do it's own verification before updating the General Ledger batch. If the transactions from Cashbook fail the view verification, the General Ledger batch is deleted and the transactions are placed back in the Cashbook. You will then be able to view the transactions in Cashbook Print G/L Transactions. To correct the transactions to enable you to update the General Ledger do the following: Activate the PereSoft MUDEBUG utility before you do the transfer to G/L. The debug will return an error message to you indicating why the data failed the view verification. You can then use the PereSoft Edit Data utility or MS ACCESS to correct the entries in the GL Trans Detail table and once corrected transfer to General Ledger. Once the transactions have been successfully created in General Ledger the Cashbook General Ledger Transaction table is cleared automatically. The reason we do this automatically is to prevent the same entries from being sent through to the General Ledger more than once. |
|
| 2. Activation Issues | Top |
| Question: I receive an error message "Activation code is not correct for XXX" when I install Cashbook. | |
|
Answer: 1. Check that the Company name been entered correctly? The company name must be exactly the same as on the activation form sent by PereSoft. (This only applies to a Cashbook install). Ensure: 2. If you have already set up the Cashbook and you have selected the 30 Day Grace Period during installation and now want to activate the Cashbook permanently. When you receive your valid activation code and serial number you can register the product by selecting Versions|License Information|Register in the Cashbook for Windows Server. |
|
| 3. Locked Batches | Top |
| Question: When I open a batch I receive an error message "Batch is currently being used/edited by another user" | |
|
Answer: To remove the lock you need to run the integrity check from within Cashbook it will then inform you it has found a locked batch and prompt you to unlock the batch. MULOCK is a new addition to the PereSoft Maintenance Utilities. |
|
| 4. User Security Issues | Top |
| Question: I receive an error message when trying to access Cashbook outside of ACCPAC with any other user except ADMIN. The error message is 'You do not have sufficient rights to use this program'. No error when running Cashbook within ACCPAC. | |
|
Answer: In Cashbook 5.2A and later when you run Cashbook from within the ACCPAC menu structure there is no need to setup the user in Cashbook when you have created a new user in ACCPAC because the user is automatically added in Cashbook. The User password in ACCPAC is however not updated to the Cashbook User.mdb file as we can not obtain this password because ACCPAC encrypts it. Therefore if you want to access Cashbook outside of ACCPAC you need to update the Cashbook User password with the same password the User has in ACCPAC. You need to do the following: 1. Access the Cashbook Sample Company with User ID ADMIN. 2. Once in Cashbook from the File menu select Security then Users. 3. Enter User ID ADMIN and enter ADMIN in the Current Password field. 4. In the New Password and Confirm Password field enter the Password of your ACCPAC Admin User. 5. Do the same for each of the ACCPAC users you have setup. For the ACCPAC users you have created in ACCPAC you need to leave the current password field blank as this field would not have been updated with any value when creating the user in ACCPAC. In the New Password and Confirm Password fields you need to enter the ACCPAC Password for the User. Once you have followed the above process you will be able to access the Cashbook Company linked to ACCPAC from outside ACCPAC. |
|
| 5. ACCPAC Security for Cashbook User. | Top |
| Question: What are the minimum security authorizations required in ACCPAC for Cashbook to function correctly? | |
|
Answer: Common Services Modify Company Profile - for Cashbook Posting only. Bank Services Reconcile - for Retrieving from Other Systems and Cheque Reversals. Reverse Customer Cheques - for Customer Deposit Reversals. General Ledger Journal Entry - for Transfer to General Ledger. Setup Maintenance - if all ACCPAC G/L Source Codes are not correctly added to General Ledger. These source codes are entered in the Bank Maintenance Bank tab in Cashbook and must be added to the General Ledger Source Codes in G/L Setup. Accounts Payable and Accounts Receivable Batch Entry - for Posting to AP and AR |
|
| 6. AR & AP Reversals not found in Bank Services to reverse through to AR & AP. | Top |
| Question: When I reverse a transaction in Cashbook the entry is not reversed in Accounts Payable and Accounts Receivable. | |
|
Answer: When doing a reversal Cashbook will check in Bank Services for the cheque entry and if found will call the Bank Services reversal function to reverse the cheque in Accounts Payable/Accounts Receivable. If Cashbook does not find the cheque entry in Bank Services it will display a message" Cheque not found in Bank Services" at the point when the user is trying to reverse the entry and the cheque will not be reversed in Accounts Payable/Accounts Receivable. The reasons for the cheque not being in Bank Services can be because the Bank Services entries have been cleared or the payment/receipt batch is unposted in Accounts Payable/Accounts Receivable and Bank Services will only be updated once the cheque has been posted in Accounts Payable/Accounts Receivable. |
|
| 7. Retrieval of AR Receipts into Cashbook | Top |
| Question: I have posted transactions in Accounts Receivable but can't retrieve them into Cashbook. I receive a message "No transactions were found to retrieve." | |
|
Answer: Check the following: 1. Are the deposit entries in Bank Services? The transactions must be present in the BKDEP file. 2. Can you view the posted receipt batch when you view the transactions in Customer Activity in ACCPAC? Cashbook also uses the posted receipt batch. Therefore if the user clears the batch status report in ACCPAC, Cashbook will not be able to retrieve the receipts. The first time you retrieve from AR all the Receipt entries in the BKDEP file will be retrieved, this stands to reason as the receipts have not been retrieved into Cashbook before. Once the first retrieval is completed the BKDEP file 'Deposit Description' field is updated with "Retrieved to 167-00002" (167 being the Cashbook batch number and 00002 being the entry number). On your subsequent retrievals when selecting to include "New Deposits" only receipts that were not previously retrieved will be retrieved. In other words only receipts that do not have "Retrieved to xxx-xxxxx" in the BKDEP file 'Deposit Description' field will be retrieved. |
|
| 8. Migrating LanPacs from one Database Format to Another. | Top |
| Question: I want to change my Cashbook database format from MS Access to MS SQL but when I install the Cashbook MS SQL LanPacs I receive an error message indicating I can not install 2 different LanPac types. | |
|
Answer: Do the following: 1. Delete the license file LC52A.LIC from ..\Winacct 2. Copy the CB52A.LIC file from ..\Winacct into ..\Winacct\Profile renaming the file to profile.ndb 3. Install the new LanPac. |
|
| 9. Data Corruption | Top |
| Question: I receive the following error message in Cashbook "Unrecognized database format 'X:\XXXX\XXX\XXX\XXX.MDB'." | |
|
Answer: The DataManager Integrity Check must always be run before rebuilding a database as this will verify that the structure and keys of the database is in tact and remove any blank records thereby compressing the database. If the DataManager Integrity Check reports errors which can not be fixed, rebuild the database using the PereSoft Convert utility called: MUCNVT.EXE. When using the PereSoft Convert utility the data is copied into a new database and the database keys and structure will be recreated. Note: MUCNVT.EXE is part of the PereSoft Maintenance Utilities. To run MUCNVT.EXE: 1. Create a new Database. 2. Initialize it. 3. Run MUCNVT.EXE copying the old database to the new database. 4. Once complete, rename the old database to .bak and the new database to the old database name. |
|
| 10. ActiveX Component Can't Create Object. | Top |
| Question: When I attempt to access Cashbook I receive an error message "ActiveX Component can't create object." | |
|
Answer: Download the relevant version of PereSoft Maintenance Utilities and run the MUDIAG.EXE utility Connect test to establish whether the objects have been registered correctly, if necessary run the Register function to re-register the object. |