Topic Options
#34391 - 12/17/12 11:48 AM Error Retrieving AP batch into BankRec
MountWashEH Offline
New Guy

Registered: 05/25/09
Posts: 5
Loc: Mount Washington, BC
I have retrieved a batch into BankRec from AP but am unable to post it due to an error. The error message is "the batch bank code is incompatible with the vendor's control account set." I am not sure what this means. As far as I know we haven't changed anything concerning the vendor's control account set. Any idea what may have caused this?

Thank you in advance,

Top
#34392 - 12/17/12 12:01 PM Re: Error Retrieving AP batch into BankRec [Re: MountWashEH]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11570
Loc: Vancouver, BC Canada
Hi MountWashEH,

There is an optional setting in the Adagio Payables company profile to require that the bank code on a payment batch be equal to the bank code attached to the vendor control account set record. This setting is called 'Include bank in control account set' and I presume it is enabled for your Payables company data. The net effect of this option is to force payment to a vendor from a specific bank. You can view the control account sets in Payables to see which bank is assigned.

With the current version of Adagio BankRec 8.1D, I can confirm that entry of BankRec batches adheres to this option and will prevent creating a payment for a vendor to the wrong bank.

What versions of Adagio BankRec and Payables are you running? How are you creating your payments in BankRec for retrieval into Payables?
_________________________
Regards,
Softrak Tech Support

Top
#34409 - 12/17/12 02:59 PM Re: Error Retrieving AP batch into BankRec [Re: Softrak Support]
MountWashEH Offline
New Guy

Registered: 05/25/09
Posts: 5
Loc: Mount Washington, BC
We are running Adagio Payables 8.1C and BankRec 8.1B. The payments are created in Payables and retrieved in BankRec. Once the check register or manual cheque batch is posted, it is ready for retrieval into BankRec. I retrieve the batch from the option on the Maintenance menu.

I have since tried to apply an automatic withdrawl onto a vendor account in BankRec (as I usually would) and I am receiving the same message.

Top
#34410 - 12/17/12 03:21 PM Re: Error Retrieving AP batch into BankRec [Re: MountWashEH]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11570
Loc: Vancouver, BC Canada
Thanks for the update. I mis-read the original post and thought the batch was entered in BankRec, then retrieved to AP.

The same logic still applies, where Payables manual check or system check payments will not allow entry/posting of a check related to a bank different than the one assigned to the vendor's control account set, if the option has been enabled in the company profile. Can I assume then that you were allowed to enter/post the check(s) in Adagio Payables, but are getting an error message when attempting to post the retrieved batch in BankRec?

With current versions of Payables 8.1E and BankRec 8.1D, I cannot replicate this scenario - entry and posting is halted in AP, before the batch is posted and retrieved into BankRec.

To see what is happening, in BankRec highlight the batch you retrieved from AP and click the Rename button. Note the Bank Code assigned to the batch - is it the one you expected? If not, then you should investigate how your BankRec Bank codes are defined, specifically which AP bank codes they are mapped to. It is possible that you have multiple BankRec bank codes assigned to the same AP bank, and the batch was retreived to a bank you didn't expect. Or a BankRec bank code is mapped to the wrong bank that you aren't expecting. Edit the BankRec bank record and the Interface tab.

If the correct BankRec bank code is assigned to the retrieved Payables check batch, and each BankRec bank code is assigned to a unique AP bank code, then the likely problem is the AP control account sets and the banks assigned. Perhaps somebody enabled the 'Include bank with control account set' option when it should not have been.

You'll probably need to get your Adagio consultant involved with this question, so they can look at your company setup (banks, batches, etc) with you.
_________________________
Regards,
Softrak Tech Support

Top
#34426 - 12/18/12 08:25 AM Re: Error Retrieving AP batch into BankRec [Re: Softrak Support]
MountWashEH Offline
New Guy

Registered: 05/25/09
Posts: 5
Loc: Mount Washington, BC
Thank you for your assistance. It appears that the 'include bank in control account set' had been selected in error. We are now back up and running.

Top


Moderator:  Softrak Support 
Who's Online
1 registered (1 invisible), 84 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14482 Topics
70726 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31