Number of separate Vendor line items on EFT Payables file

(0) Share

Report

Posted on by Community Member

In Dynamics GP 2015, we have a situation where multiple items/invoices are selected for payment via EFT for Vendors. Some Vendors will show one Amount on a single line, but others will show one line item per Invoice. What is it that drives whether or not there is one or more line items per Vendor in the EFT file?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

26P2ER 1,775 on at

Like (0)

Report

Hello John:

When you build the EFT batch via select checks etc if you pick the drop down One Check Per Vendor - That typically sends all invoices for a given vendor to one check, likewise if you choose one check per invoice, that usually sends one individual check for each vendor invoice.

I can verify this today with vGP2010 and have attached a picture of the same.

Best of luck

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

We received the following from our Dynamics Partner:

When you enter a voucher in Payables Transaction Entry, or a shipment/invoice or invoice match on a Purchase Order, the Remit-To address set up in the Vendor Maintenance will default onto the transaction, but you can change it to specify a different Address ID’s that you want to use as the Remit-To. This was designed for large vendors that have multiple Remit-To addresses so that you can use the same vendor but a different address to mail checks depending on what the vendor’s invoice instructions for remitting are.

When you print the checks for the vendor, GP prints one check per remit-to address. Microsoft carried this functionality into the EFT process because the EFT information is set up at the Address ID level, not at the vendor itself. So you could have one vendor with multiple address IDs and each address ID would have different EFT banking information.

It sounds like in your situation, for the vendor in question, you have multiple address IDs and each one has the same EFT information. GP will not combine this into a single EFT because it is only looking at the Remit-To Address ID assigned to the vouchers that are being paid. It doesn’t go deeper into the EFT details to see if those are the same and then combine based on the EFT info.

So, when the Invoice is initially entered in GP 2015, that is where the Remit-to Address is being used. When there is more than one Remit-to Address, the A/P person need to know that they control how this is processed.

Was this reply helpful? Yes No