Payment Confirmation Import For Invoices

[Lou_at_ACE]

We pay our Concur invoices in Sage Intacct.  Can I use the Payment Confirmation Import to upload payment information to our invoices in Concur (Pro)?

The import template looks like it's specifically for Expense, as it requires a Request Key and has no column for Vendor ID.

Is anyone able to successfully import invoice payment details?

Thanks.

[PoojaKumatkar · Accepted solution]

Hi @Lou_at_ACE ,

Yes, you can update payment status using payment request confirmation import template. You can take import template from Invoice technical deployment toolkit. 

As per template, only request key (payment request key) field is required and other fields are optional. However, you should still provide minimum and necessary information such as request key, Invoice amount, payment status, payment status date etc. so that payment will get updated. 

Note - Currently I am working on Invoice project, and we are updating payment status through interface using below template.

Payment Confirmation Specification Guide: 

Step 1: Creating the Import Data File | SAP Help Portal

[Lou_at_ACE]

Thanks Pooja.

I did find the Request Key field and mapped it to the Reference No. field on Bills in Sage Intacct.  That enables me to generate the payment detail to populate the import template.

Appreciate your help.