Hello Tim

Cashbook is compatible with AP6.1a, so there is no concern there. Possibly you have not prepared AP yet for using it with Cashbook as per the instructions in your Cashbook manual. I can assure you that if there was a bug with the integration between CB and AP, we would know about it by now.

Here are some guidelines that you can use as a checklist to ensure you are setup correctly...
1. In CB, Company Profile (4th screen) - do you have the 'Interface with' Accounts Payable option set to [Y]? This would be the most important thing to check at this point.
2. Was CB installed AFTER AP? I would assume that this would be the case, but if you have installed CB, then reinstalled AP for any reason (or installed an AP ptf), then you would need to reinstall CB afterwards.
3. The most effective way to process AP manual checks, is to enter them first into Cashbook as a 'normal' type batch. When entering the transactions, specify 'Accounts Payable' as the Detail Type. This will update AP with a new Manual Check batch which you can then post to get the AP Vendor information up to date. (This method also ensures that duplicate check numbers do not get generated.)

System check runs from AP automatically get sent to CB after you have said Yes to clearing the Check Number Audit List, after printing this report.

More information on these procedures can be found in the CB manual, as well as the 'Questions and Answers' Addendum that ships with it.

You may also want to check your Cashbook, AP and Payroll Company Profiles, to ensure that the G/L account codes being used are setup for use with Cashbook, to avoid duplicate entries being posted to the G/L accounts...

This information can be found in Chapter 3 in your Cashbook manual. Pages 3-36 ~ 3-42.

USING CASHBOOK WITH ACCPAC PLUS MODULES
(How to setup the G/L accounts in each module so as to prevent double posting in the General Ledger)

Accounts Receivable:
The Bank account used in AR must correspond to the 'AR Clearing account' set up in the Cashbook (and in your GL).
AR Bank Account Code = Cashbook AR Clearing Account.

In AR:
6. Housekeeping
3. Add/modify/delete control account sets
Select the account set and change the 'General Ledger' Bank Account to the AR Clearing Account.
Do this for each account set used in conjunction with the Cashbook.

In CB:
5. Housekeeping
1. Edit company profile -
2nd Screen: Bank account details ?V enter the proper GL Bank Account used in conjunction with this Cashbook. (This would be the same bank account used to deposit your A/R payments on account.)
4th Screen: Under G/L Clearing Accounts: - Accounts Receivable, enter the AR Clearing account as it appears in your G/L.

When this has been setup properly, these offsetting transactions should post to your GL:

From the Cashbook:
Cashbook Bank Account DEBIT (GL Bank Account)
Cashbook A/R Clearing Account CREDIT (GL AR Clearing Account)
From Accounts Receivable:
A/R Clearing Account DEBIT (GL AR Clearing Account)
A/R Control Account CREDIT (GL AR Control Account)

The result is that the Clearing Account nets out to a zero balance, leaving the transaction balances in the G/L at the correct amounts.


Accounts Payable:
The Bank account used in A/P must correspond to the A/P Clearing account set up in the Cashbook (and in your GL).
i.e. A/P Bank Account Code = Cashbook A/P Clearing Account.

In AP:
7. Housekeeping
1. Edit company profile - 3rd Screen
Change the General Ledger 'Bank' account to be the AP Clearing Account that is setup in your G/L.

In CB:
5. Housekeeping
1. Edit company profile -
2nd Screen: Bank account details ?V enter the proper GL Bank Account used in conjunction with this Cashbook. (This would be the same bank account used to issue checks to your Vendors from.)
4th Screen: Under G/L Clearing Accounts: - Accounts Payable, enter the AP Clearing account as it appears in your G/L.

When this has been setup properly, these offsetting transactions should post to your GL:

From the Cashbook:
Cashbook Bank Account CREDIT (GL Bank Account)
Cashbook Payment DEBIT (GL AP Clearing Account)
From Accounts Payable:
A/P Bank Account CREDIT (GL AP Clearing Account)
A/P Control Acct DEBIT (GL AP Control Account)

The result is that the Clearing Account nets out to a zero balance, leaving the transaction balances in the G/L at the correct amounts.

Hope this all helps you with a successful implementation!

Regards,
Softrak Support

[This message has been edited by Softrak Support (edited 12-17-2001).]