Hello all,

I'm running BR 9.3A (201230), and first off I just want to say how much of an improvement BR 9.3A is over 9.2, love it.

I am having one issue with the link to Payables that I'm working around the long way but would like to stream line.
If I create a manual batch, and create a cash invoice for a vendor, it flows thru to Payables as a Cash batch and the cheque detail shows up in Payables. The transaction flows to GL from BR and AP, in and out of the clearing account, all perfect.
If I create an excel import I don't get the same flow. The entries will show up in my BR batch, it will show the vendor, it will show the cash invoice batch details, the appropriate accounting is all there. But when I post in BR, it doesn't create a batch in AP, and in GL, it only has credit bank, debit AP clearing account. As the entry in the BR batch looks exactly as the entry I would manually create I'm a bit stumped as to why it doesn't create the AP batch.

Am I missing something?

Hi Jesse,

What I've found out recently is that if you want to import cash invoices to AP vendors, you should be doing this in Payables and not BankRec. One other site ran into this very scenario. Importing Payments in BankRec is designed only for misc vendors not in Payables. Apparently there is code built into BankRec that posting imported Payments batches writes particular accounting information.

I believe the vendor number that is available in Import Payments in BankRec was put there to allow reading the vendor name from the master record. But my suspicion is that this has led to problems such as what you have wrote here. From what I found, the next release of BankRec (whenever that will be) will have the vendor number removed from the Import Payments template, so you won't run into this situation again.

This is what I know from R&D.

Thanks support, I'll split my batches apart for the ones I want to show up in vendor history and import that part into AP instead of BR.