When expenses or invoices must be loaded from external systems you can use CSV flat files to upload them by SFTP for processing by Coupa. Process and pay expense and invoice CSV flat files by SFTP transfer.
The Payments Import process accepts both expense and invoice CSV files transferred by way of SFTP to any of the following endpoints:
Expense files must have an
Expense Report Id and invoice files must have an
After receipt, these files are moved to the archive folder located at
./Archive/Incoming/InvoicePayments/ before being processed in alphanumeric order. In the standard integration, a validation routine determines whether a payment has already been applied to an invoice by comparing the payment date, check number, 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 supplier name or number.||TRUE*||FALSE||string(255)||any|
|Invoice Number||Invoice Number (null if the record is an expense)||TRUE||FALSE||string(40)||any|
|Expense Report Id||Expense Report Id (null if the record is an invoice)||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.