The Invoice Payments Import process read files from the
./Incoming/InvoicePayments/ in SFTP. These files will be moved to the archive folder located at
./Archive/Incoming/InvoicePayments/ before being processed in alphanumeric order. In the standard integration, validation routine will determine if a payment has already been applied to an invoice by comparing the payment date, Check # and Amount fields to the payment record.
Void/Check Cancelations: The Coupa Integration does not support deleting or voiding a check directly. The best practice in this scenario is to create a new 'payment' for negative the amount of the check to cancel. The Check # can be the same or have a string such as 'Void' appended.
- Supplier Name
- Supplier Number
Note: invoice payments can't be updated via integration.
Invoice Payment Columns
|Column Name||Description||Req'd||Unique||Type||Allowable Values|
|Supplier Name||Supplier Name. Include at least the suppler name or number.||TRUE*||FALSE||string(100)||any|
|Supplier Number||Supplier Number. Include at least the suppler name or number.||TRUE*||FALSE||string(255)||any|
|Invoice Number||Invoice Number||TRUE||FALSE||string(40)||any|
|Expense Report Id||Expense Report Id||FALSE||FALSE||integer(11)||any|
|Paid||This is the paid field on the invoice header. It's set to a true or false value.||FALSE||FALSE||boolean||true,false/Yes,No/Y,N/T,F|
|Paid-in-Full Date||Paid-in-Full Date||FALSE||FALSE||datetime||YYYY-MM-DDTHH:MM:SS+HH:MM|
|Paid-in-Full Note||Paid-in-Full Note||FALSE||FALSE||string(255)||any|
|Check Amount Paid||Check Amount Paid||FALSE||FALSE||decimal(32,4)||any|
|Check # / Note||Check # / Note||FALSE||FALSE||string(255)||any|
|Check Payment Date||Check Payment Date||FALSE||FALSE||datetime||YYYY-MM-DDTHH:MM:SS+HH:MM|
* One of Supplier Name or Supplier Number is required.