Invoice Payments Import

Overview

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.

Keys/Validations

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.