Mark Nelson 10/14/2015 2:52:24 PM

Importing AP invoices with multiple distribution lines

We are seeking to streamline processing of vendor ach payments drafted from our account.  Specifically lease payments.  We have multiple vendors and a growing number of leases.  One vendor we have drafts 250+ invoices on the same day each month.   We are provided information of the lease number, invoice number and amount and an upload is prepared for all invoices.  Unfortunately, this vendor also has special payments that are keyed directly from invoices (advanced payments, property tax payments, end-of-lease expenses, etc.).  AP staff cannot simply select all open invoices and mark them as paid to post the bank draft.

 

Is there an upload that would allow both the posting of the invoice and the recording of a payment at the same time, or is there an upload process to mark payment of multiple invoices? Currently there can be multiple purchase distribution accounts per invoice, but only one AP trade account.

 

I’ve attached the upload provided last month.  The first tab comes from the vendor, MHR adds the coding.  Gail uploaded the .CSV tab last month then checked each invoice (269) as paid

 

Currently we have an AP Invoice integration, however it is not meeting the specific requirements.

Version: GP 2010
Section: Integration Manager


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3