Hi All,

When I reverse a check in AP under the check reconciliation function, do I also have to reverse that check in bank rec (when i'm reconciling the bank)?

Thanks!

we are using AP 8.1A and BR 8.1B

Actually, you should reverse the cheque in BankRec and it will flow back to Payables.

Hi All,

I'm trying to import payments into bank rec to do the take on procedures.

What needs to be in the Hdr-Record Type (H) and Det-Record Type (D).

They are all payments (checks) from payables that i need to enter as per the take on instructions.

Thanks!

To answer your questions, the values are 'H' and 'D', respectively. This assumes you are using the 'Header/Detail' format for importing, rather than the 'Detail only' method (which is more suited to an Excel-style layout).

You only need to do this import if you want to handle all outstanding transactions in BankRec now.

It is much simpler to deal with outstanding payments in AP and use BankRec for any new transactions. In this case, all you have to do to set up a bank is to set a bank balance of 0.00. When it comes time to do your first reconciliation, your balance will be off by some amount - just post a single batch entry (receipt or payment) for the net amount of the difference before you finish the reconciliation.

Hi All,

When I reverse a check in bank rec (as per the bank rec manual) it is not reversing in payables.

We are using BR 8.1B and AP 8.1A.

I noticed in the manual, on page 123, it says to also go into payables and reverse the check so that the invoice will be set up for payment again.

Is there anyway to avoid having to reverse a check in two places?

Thanks!

Reversing a cheque is a 2-step process as you've discovered. First the BR module, then AP module.

It can be made simpler by configuring your Bank in the BR module. Edit the Bank, go to the "Interface" tab and under "Update Payables Check Reconciliation", select "Pending Status".

Now when you Reverse a cheque in BR, the cheque in AP will automatically be marked as "O->R". You still have to go to AP and post the Check Reconciliation but it's easier.

Note that the act of Clearing a cheque in BR will now also update the status of the cheque in AP.

Hopefully a future version of Bank Rec. will perform this function in one step.