Hi All,

I've got a Bank Rec difficulty that I'm hoping is as simple as my forgetting to check or uncheck a box.

I'm integrating Bank Rec 8.1B with Receivables 9.0A, Payables 8.1B and Ledger 9.0C. I have (I hope) properly set up the A/R and A/P clearing accounts in all three sub-ledger programs, but when I wrote a test invoice and check payment, the BR batch correctly included the A/P clearing account, but the Payables batch did not. I tried two test batches where the invoice was paid off in either Bank Rec or Payables and got the same erroneous result. Nowhere in the integration section of Payables is the main bank account linked, so I have no idea how this happened.

Have I missed an option or something? Anything helps and thank you as always.

Matt

Hi Matthew,

When Adagio BankRec is integrated with Payables, the bank codes in Payables must be configured with the Bank GL Account using the Clearing Account, not the real GL bank account. If the AP bank records have the real GL bank account assigned, then this will cause double-posting to this account.

You probably have the BankRec bank codes configured properly, with the real bank and clearing accounts assigned.

Similarly for Receivables integration, the Control Account Sets in AR need the AR clearing account, not the real GL bank. I believe the label for the field changes to mention BankRec, so it is easier to see what is happening.

Found it. I had properly integrated the Payables Company Profile, but not the Bank settings. Thanks for your help.