Forum Questions and Answers

ACCPAC Security for Cashbook

Can you please explain what the minimum security rights that are required by ACCPAC for Cashbook to work correctly.

The following authorizations are required:

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

Convert to SQL Server	Is there anywhere a document explaining how to convert our data from access to SQL server 7 to make better use of the speed that SQL 7 gives over access? I know I can create a database and import the access database into it. I just need to know for sure what names Cashbook 4.1A is expecting.
	The PereSoft development team have written a utility to convert the database from MsAccess to SQL 7. This will be available once you have the CBW 4.1.
Cannot create ActiveX......	On a workstation when trying to access Cashbook for Windows I receive the message. "ActiveX component, cannot create object" What is the problem?
	The icon in the Cashbook for Windows startlist folder is not pointing to the correct executable. Make sure that the target path is as follows: c:\winacct\wa41a\walogin.exe /cbbankrx Replace the c:\winacct with the correct install path of Cashbook.
	Doesn't this have to do with an incorrectly installed MDAC By reinstalling MDAC (the latest is version 2.5) it should solve the problem. MDAC can be found at www.microsoft.com/ado.
	No it does not. Although CBW is compatible with MDAC 2.1 or higher, this message relates to a bug with Microsoft and creating a com object across a network. Because WALOGIN creates the objects directly this option works.
Unable to execute program	I have loaded cashbook 4.1 demo on two PC's and both have not load successfully. I am unable to execute the program on both of the PC's, I receive the following error messages: OpenRS - Object variable or With block variable not set Object variable or With block variable not set. Contact your dealer. OpenDB - Connection error:provide=Microsoft.Jet.OLEDB.4.0;Persust Security Info=False;Data Source=c:\program files\winacct What is the problem?
	Cashbook for Windows 4.1 uses the latest technology MDAC (Microsoft Data Access Components). This needs to be installed on the workstation, this can be installed from the INSTALLTOOLS directory on the Cashbook Windows CD Rom or the Demo Download Zone.
Variable uses an Automation type	I have installed Cashbook for Windows 4.1 on my server, I am now busy with the workstation installation which ran correctly but now when I try to access Cashbook from the workstation I receive the following error at the initialization box: "Variable uses an Automation type not supported in Visual Basic"
	This particular error is due to DCOM98 not being installed correctly or certain of the DCOM98 files have been overwritten by another program (which seems to normally be the case). Besides the standard install which installs some DLL's you need to have DCOM 98 installed on the workstation. This can be installed from the INSTALLTOOLS directory on the Cashbook for Windows CD Rom by running DCOM98.EXE. If you are running NT, please ensure that Service Pack 4 or higher is loaded.
VBA Hosting	You know that ACCPAC 4.1 is hosting VBA. We are providing solutions to clients with such tools. Is CBW 4.1 going to be made accessible by the AI's VBA? Is there any 'View'/ Object like Accpac, which allowing us to get access into the database - not true (back door) MS-Query.
	At the moment CBW 4.1A does not have an interface to VBA but Cashbook is written in VB exposing the latest Com Object technology. By calling the Cashbook's server you are able to get access to our database's via our interface. If you require more info on this I suggest you email me. . At the moment we do not support the concept of views.
Crystal Report Used in 4.1	During Version 3.0 we have to reserve at least 2 - 3 workstations for Cyrstal Report Designer. CBW 3.0 is supporting Crystal Ver 5 (16-bit), Accpac 4.0 using Crystal Ver 6, Accpac 4.1 supporting Crystal 7.0 . I wish I could drop 5.0 and 6.0 because of the restriction on functionality. Advise me what version of Crystal Report are you guys supporting in CBW 4.1 . If still at 5.0/6.0 , then lets forget about upgrading to 4.1.
	Cashbook for Windows 4.1 uses Crystal 7.0 32 bit.
CB 3.0 spec not working	I created a receipt and depost slip which my client used previously with CBW 3.0. They have no upgraded to Cashbook for Windows 4.1 and the spec no longer prints. Can you let me know what the problem is?
	As there were file layout changes between Cashbook for Win 3.0 and 4.1, you need to open the report in Crystal 7.0 and choose to "Verify database". This will refresh the report with the latest field and allow it to print with your 4.1 Database.
Is CBW 4.1 going to run from within Accpac	Is Cashbook going to run as part of Accpac 32 bit interface? What Access version is being used now?
	Cashbook for Win 4.1 will run within Accpac for Windows menus. MsAccess 97 is now the new database version.
How can I create all CBW icons in Accpac 32-bit	How can I create all icons in Accpac. Is there a faster way besides adding one at a time?
	You can install PereSoft's Maintenance Utiities that is on this Promotional CD which allows you to run your Cashbook menu options from within the ACCPAC For Windows menu structure.
Windows2000 Compatible	Is version 4.1a Win2000 compatible or not?
	Yes Cashbook version 4.1A is Windows 2000 compatible.
Interface to AccPac	If we upgrade to version 4.1a (which we will) and convert to SQL Server (which we most likely will also). Do we then have to upgrade our AccPac to SQL server also? I would prefer if it could be donein stages CB first to SQL server, if things work OK then AP to SQL server. Is that scenario possible?
	Yes, you should not have problem converting Cashbook to SQL Server (by purchasing the SQL Lanpacs) first and at a later stage converting your ACCPAC for Windows modules.
Version 4.1 Installation	I realise it is how you can see what users are in but what else is its functions. Of Course I have read my manual front to back (Not), please refer me to where your documentation is so I can familiarise myself with this. I have some clients where I know we must not have set this up right as some users can get in and others don't. I know your response will be RTM, please just save me some time and tell me what page.
	The information you need is in Chapter 2 of the Addendum (if you have upgraded from an earlier version of Cashbook for Windows) and in Appendix H of The Cashbook for Windows Manual (if you have upgraded from DOS or have purchased a full product). Cashbook 4.1A verifies the User Name and Password set up in Cashbook, to the User Name and Password that has been set up in ACCPAC for Windows. Please ensure that your User Names and Passwords in Cashbook are the same as the ones you have setup for ACCPAC for Windows. This might shed some light on your problem where some users can log in and others not.

Unapplied Cash	I have a client entering a AR Receipt into Cashbook 32-bit with latest patch. They enter one detail line through system and click on allocate and apply this to the ar invoice. They then add another detail line through for same entry and then goto select unapplied cash, but the second line will not let you select the ALLOCATE Button to get to the unapplied area.
	Your client should do the full allocation through one detail line. There is no need to add a second detail line to the entry. Once they have applied against the invoices they can leave the remaining unapplied amount and save the entry. Cashbook will automatically post the amount that was unapplied to the Customer Account as Unapplied Cash.
Multicurrency Version	Client has purchased Accpac for small business with the multi currency add on. My question is will they have to purchase cashbook corporate series or will small business cashbook be o.k?
	They will have to purchase Cashbook Corporate Series.
Can't Open: corruption	Trying to open cashbooks, we get a message that the microsoft database is corrupted or missing. there is a utility somewhere that fixes this. Does anyone know what it is?
	Have you tried running the integrity check in Datamanager? If that does not help, there is a utility called JETCOMP.EXE which resides in the directory \winacct\installtools on the install cd of Cashbook.
Prepayments	I am trying to post cash that has been paid in advance that has no invoice number to post against, how is the best way of dealing with this?? I have tried to allocate it in Prepayment area and state the doc numer as PREPAY but it did not accept this. Also I went to post a cheque payment that also had been overpaid by $112 I tried allocating this $112 off another invoice therfore reducing the balance but it has thrown it into an error batch stating Invalid Input. Document No does not exist for this customer?
	Are you entering the full cash amount paid in advance as an entry and in the allocate screen applying the full amount to Prepay with Prepay as your document number? If so your entry should definitely be accepted. If you are splitting the amount of one entry between Invoices outstanding and prepay the, entry will not be accepted, as Cashbook will take the full amount of the entry into prepay when prepay is selected. After you have allocated against invoices outstanding and you still have an unapplied amount, leave the unapplied amount and save the entry. The amount that was unapplied will automatically be applied against the Customer account as unapplied cash. “Document No does not exist for this customer.” Can you check in ACCPAC Accounts Receivable to see whether the Document No you applied against, does exist in the Customer Account.
Cashbook Server	They have no need to add Lanpaks, as some of the users are only in CB for a couple of hours a week. The problem is... if they go in, the CB server starts up, and doesn't seem to release the license when they leave without them manually 'killing' it. Which locks a more frequent user out of the system.
	The latest PTF allows the user to automatically logout the Cashbook Server.
Cashbook Reconcile	Cashbook recon is great. But my clients have to reconcile again in Bank Service - Recon. Isn't it double work?
	We felt that it would be easier if the user reconciled a range of entries in Bank Services when they wanted to clear the Bank Services transactions. This could be done quarterly or something to that effect. It is recommended that you only do the above when you are sure that you do not want any entries to be reversed at a later date. You would therefore want to keep the info available to be reversed correctly. There are so many extra problems that come up when trying to run two cashbooks in sync that we felt it was not worth it.
Recexpress	I have a client using 32-bit Cashbook with latest patch and they have advised the following; "I have run into a problem with using RECXPRESS in our new cashbook. When I attempt to upload my bank statement info into ReCExpress there is no longer an option to choose the file type. Previously a list of bank formats was available on a pull down menu. This no longer exists and I assume as a result the upload and match up does not work. When i look at recexpress details of the match ups it appears to be getting confused and is putting for example the date in the reference field, the account number in the amount field etc. I assume this is because I can no longer tell it that my file is an ANZ Online banking file as i used to be able to. Is there a patch or something?"
	Your client must upgrade their RecXpress to version 4.1A ? It is part of maintenance as long as they have purchased a maintenance contract when they purchased the product. Also check that their maintenance contract has not expired, if it has they can purchase an upgrade
USD Default Creating CB	Why can't I change the default currency code when creating a Cashbook
	Cashbook will only let you change the currency code if it is standalone. If CBW is interfaced to ACCPAC it will use the currency code from ACCPAC's company profile. If Cashbook cannot read the company profile it defaults to USD. To make sure it is reading the company profile correctly in ACCPAC, switch on the debug feature in Cashbook and see if no error messages are being generated. In Cashbook 4.1 we are now using the xApi to communicate and interface with Accpac for Windows, the users that login to Cashbook have to be valid users in Accpac as well, ie: I login to Accpac as Sue and my password is 1234 then in Cashbook I must be setup with the same User ID and password.
RecXpress MSSQL	Do you have a RecXpress MS SQL version 4.1?
	RecXpress version 4.1A is available, there is only one RecXpress for Windows module that will interface to Cashbook Small Business, Corporate and MS SQL. RecXpress does not work with ACCPAC Disconvery Series.
Roto error when using finder on gl accounts	When using the finder on a GL Account i get a roto error that freezes the screen.
	Cashbook is loading ACCPAC's finder and I am sure it is conflicting with some dll's in either ca_appsw or runtime. Although I have submitted this error to AI to see if they can shed some light on this, I have not yet received a reply. At the moment the work around is to install the programs locally.
Multicurrency	I have a situation where a client wants to set up the following: Home Currency of Company: $AUD Vendor Currency: $AUD Bank Account Currency: $USD The client wants to leave the Vendor in AUD currency but at time of payment, pay with the $USD bank account. They would be making this payment in Accpac and retrieving in Cashbook. This was never allowed in Version 3 as the bank account currency had to be the same as the vendor's currency. However, Version 4.1A seems to allow it. The problem however, is when the batch is retrieved in Cashbook it is doing the mutlicurrency conversion all over again. What it does, is that it picks up the USD payment amount and applies the conversion to that. Can this method just not be used or is there a problem? Is there an alternative? The client needs to be able to change the currency rate at time of payment.
	Please load the latest PTF as we have done a lot of work to allow the Vendor to be paid in any currency. Cashbook when posting the batch automatically separates the currencies and creates the relevant batches in AR and/or AP.
Discounts	CB4.1 does not except discount amounts when paying invoices and receiving cash from debtors in the discount column. In CB30 it was not a problem. Is there a solution for monies remaining after you applied payments or receipts.
	This was addressed and fixed in the latest PTF.
16bit Accpac 4.1 with CB 4.1	I have a client who has accpac 4.1 in 16 bit they have various mods etc, it is not suitable for them to upgrade to 32 bit. How can we get them to work with cb41a 32 bit?
	You can install the SM/GL/AR/AP 4.1 (32-bit) and point to the same database. This will work for CBW 4.1. What you need to do is the following: 1. When you install your ACCPAC for Windows program files you need to install both the 16Bit and 32Bit versions. 2. In Cashbook you need to point to the ACCPAC for Windows 32-Bit program files and to the ACCPAC for Windows 16Bit data files.
Retrieve from other system	Using Cashbook 4.1 and when trying to "Retrieve from other system" error message : 1. No transaction were found to retrieve. 2. xApiViewPut - Internal error:Bank Check. Attempt to change read-only field 'Check Reference'.
	When Cashbook retrieves the Cheque information from Bkchk.dat, Cashbook writes back to Bank Services to specify that it has received the Cheque information. Bank Services then checks in Accounts Payable for the payment information, if it does not find the cheque information in Accounts Payable, it will lock the file and the ACCPAC view will return an error message: 1.“No transactions were found to be retrieved.“ 2. xApiViewPut - Internal error:Bank Check. Attempt to change read-only field 'Check Reference'. 2. Error(s) Printed. When Cashbook retrieves the Cheque information it retrieves all the Cheque information available (that has not been retrieved before) old and new. You need to remove the Cheque information of the Cheques that have been cleared from Accounts Payable from the Bkchk.dat file before you retrieve the cheques into Cashbook. There is no way of telling which transactions have been cleared from AP. This is normally rare and does not often occur but if it does we cannot just track it that simply. The only other way to check is to see on which entry(s) it stops and reconcile that entry. You should then clear Bank Services to remove the entry. Cashbook will only retrieve entries that have been generated in AP and not enties that have been sent to AP via CB. Once CB has retrieved the entries, it updates a reference field with the words 'Retrieved to Cashbook'. No other flag is updated. If the words are 'Retrieved from Cashbook' these entries will not be retrieved as they were sent from CBW via an AP batch and should already be in CBW.
Print report and forms	Everytime I try to print the reports I get this error wapropt.exe Application Error The exception unknown software exception (0x0eedfafe)occured in the application at location 0x77f1d493
	Make sure you have loaded the CRW install for 7.0 from PereSoft's web site.
tion	I have install Cashbook 4.1 to integrate with ACPPAC 4.1 32 bit but in setting up the database to integrate I receive a message to check the autoexec and that the SITE file could not be opened. I have tried the path c:\program files\accpac\runtime and other drives. Does Cashbook only need a path a path to RUNTIME? (I did also try adding one to CA_APPSW to the statement. What exactly is Cahbook looking for to hook up with A4W because my autoexec seems to say exactly what it should.
	Cashbook needs a path to ACCPAC's runtime and ca_appsw directories. When you install Cashbook this path should have been placed into your autoexec.bat file. To make sure it is there, go to your DOS prompt and type SET. You will then see your path settings that were picked up from autoexec. ACCPAC 4.2A will in future install this information into the Autoexec.bat file.
Converting Cashbook from DOS to Windows	I have seen references in the CB41A Manual (Appendix B)of a utility included on the CD that will convert CB DOS data to Windows. This utility is required to be installed in Plus System Manager. My problem is that I am unable to identify this utility and thus been able to install it.
	The product, Cashbook for Windows Dos upgrade, is shipped with a conversion disk from Dos to Windows. This disk is not shipped with the full product. Please contact PereSoft to obtain the conversion disk.
Installing 4.1 from another CD ROM	I have a client that has not got a CD ROM an each machine so I have tried to install Cashbook 4.1 discovery to the machines by using the servers CD ROM. I get to the first screen which asks you if you would like to install cashbook ar view cd or read me file. I click on the install cashbook line and then get taken to the initialisation screen (setup is preparing for instal) but then once the blue line has got to the end I am taken back to where I started.
	You must make sure that you map a drive on the workstation with no CD Rom to the Server CD Rom via Explorer - Map network Drive. The installation of Cashbook will not be successful without the proper mapping.
Closing Cash Book and Creating a new user	Cashbook for windows v3.0 upgraded to 4.1a, program files installed on NT4 Server and cashbook workstation on NT4 Workstations. When logging on as a user and then exiting cashbook it give's the following error: "Runtine error '453' can't find dll entry point fgetshutdown Sw in wafunc32.dll" Also when I try and create a new user it gives the following error: xApigetview Key - as0003, viewcall failed"
	Copy the file wafunc32.dll from the windows\system directory you installed the ptf on into each of the windows\system (winnt\system32) workstations. The date of this file is Jul-11-2000. The viewcall failed error is normally when Cashbook cannot find the ACCPAC API. Make sure you have installed ACCPAC 32bit on each of the computers and that you have given the correct security rights to the user logging in.
Microsoft Data Access	After installing cashbook program files to the server from a workstation it then installs Microsoft Data Access, is this installed on the server or the workstation and when I install cashbook workstation on another pc does Microsoft Data Access need to be installed?
	When running setup or workstation setup Cashbook Setup will automatically install MSADO (used for MS Access and SQL Server) on each workstation.
Retrieve AP cks from ACCPAC	Using CB V4.1a w/PTF July 14/00 - A4W 4.1a 32 bit fully patched. When using the function to retrieve checks from AP: "xApiViewPut - Internal error: Bank Check.Attempt to read-only field 'Check Reference' Tried to retrieve previous cks as well and same result. I reveiwed the clients o/s cks in A4W Bank Services and they appear to be fine ( all entries had ck #')
	When Cashbook retrieves the Cheque information from Bkchk.dat, Cashbook writes back to Bank Services to specify that it has received the Cheque information. Bank Services then checks in Accounts Payable for the payment information, if it does not find the cheque information in Accounts Payable, it will lock the file and the ACCPAC view will return an error message: XApiViewPut - Internal error:Bank Check. Attempt to change read-only field 'Check Reference'. When Cashbook retrieves the Cheque information it retrieves all the Cheque information available (that has not been retrieved before) old and new. You need to remove the Cheque information of the Cheques that have been cleared from Accounts Payable from the Bkchk.dat file before you retrieve the cheques into Cashbook.
	Does this mean if I have imported cks directly into my bank services ( they have a source application of BK rather than AP ) that this will cause the same error?
	Cashbook only retrieves cheques from Bank Services of type AP, UP (US Payroll) and CP (Canadian Payroll).
Error opening profile database	I am getting "error opening profile database" Two new PC's give this error message when trying to load Cashbook after doing a workstation setup When the Cashbook (WAlogin.exe)icon runs, this message immediately comes up. The path to Accpac runtime is set....Workstation setup appears to have run correctly, Accpac & Pervasive work fine on these new workstations. Other Workstations on the same network run cashbook OK. Workstations are Win982nd edn.. running assorted Office apps and groupwise. Novell 4.11 Network..
	Run the CD's workstation install and point it to the correct program directory on the network. If this does not help run the normal install from the CD but select Custom Install and then only toggle on the Winacct section (the first option on the selection list). Also make sure that the desktop icon is "d:\winacct\wa41a\walogin.exe /cbbankrx"
Cashbook Workstation Setup	I installed Cashbook 4.1A Discovery Series to an NT server sp5 with no problems. Setup the first workstation using the worksation setup from the server with no problems. However going onto the second workstation I got the error "The company name cannot be blank in D:\WINACCT\PROFILE\PERESOFT.INI". So I looked in the PERESOFT.INI and found that yes, the company name was blank. I put the company name in and saved. I was then able to setup the second workstation. However the same thing happened on the third workstation setup. I have pointed the programs and shared data to the same place onto the server on each workstation. Why does this file get changed after every workstation setup back to blank fields?
	This has been addressed in the latest PTF.
Import Sample Files	Do you have any sample import files that I could compare with those that I am trying to import.
	We uploaded the Cashbook Sample Import File plus a readme file at ftp://ftp.peresoft.co.za/files/cbimp41.zip
Cashbook Import overwrites dates	I am importing batches into Cashbook 4.1A. The file imports successfully, but cashbook does not use the date that I specify in the import file, and overwrites it with the import date. Can you please tell me how to rectify this?
	The date in the import must be the same date as per your regional settings, depending on the format the import could be creating an invalid date which CBW then corrects. For example: Import batch dd/mm/yy = 23/07/2000, workstation set at mm/dd/yy therefore 23/07/2000 would be an invalid date.
Cheque Printing	When printing cheques, additional invoice details from other vendor accounts are included on the remittance?
	Check under your Groups in the report that you have specified by batch and by batch entry and not only by batch entry.
Amount search in Batch entry lookup	1. If I do a prepayment to a vendor, the transaction do not post through to AP. It goes through to the GL. (I've loaded the latest PTF) 2. When trying to find a particular amount using the finder in the batch entry field, I get the error message: "Object variable or With block variable not set".
	1.The prepayment issue has been addressed in an earlier PTF, please check that your cbpost.exe residing in your \Winacct\cb41a directory has been updated correctly. 2.We have replicated your problem with the finder and a fix will be incorporated in the next PTF, please send me your email address to mikem@peresoft.co.za and I will ensure that you receive the fix in the meantime.
Cheque Printing	When trying to print cheques I get an error: Cannot open report. I:\WINACCT\ENG\SQLS\CBCHPCB3.RPT This spec was done in crystal version 5.0. I did open the spec in Info 7 and ran verify database. The spec can be previewed in Info 7 but I cannot seem to print the report. I have loaded the latest patch 7/8/2000. I also loaded the latest SQL patch.
	Cashbook needs all the 7.0 dlls installed. Because Accpac only installs CRPE32.DLL there are several others that CBW uses to work with Crystal. These extra files can be installed using: ftp://ftp.peresoft.co.za/files/crw7rt.zip
Incorrect Lanpac for Accpac SQL	When I try to access Cashbook for Windows 4.1, I receive the following message: "You are not running the correct version of PereSoft Lanpac for ACCPAC SQL" I cannot get past this error, I have Accpac for Windows Pervasive SQL installed.
	When Cashbook is initialized it checks the datatype format of the ACCPAC data that you are interfacing to via the xAPI. The problem that is being caused is due to the incorrect information being supplied to CBW from the Accpac for Windows software. This has come about due to an update that was released to correct a PIB error. This update contained two files A4WApi.dll and A4Wsem.dll. To temporarily correct the problem, the A4wapi.dll file has to be replaced with a file prior to installing this update, we are looking into with Accpac International.

Top Of Page | Index