Invoice Extract

[amanpreetkaur1]

Hello,

Can anyone please let me know how to extract the payment/invoice file (Standard_Payment_Request_Accounting_Extract) from Concur Invoice? 

I created a test invoice which is fully approved and is in 'pending payment' status. 

Thanks!

[KevinD]

@amanpreetkaur1 when you are signed in to SAP Concur, click Home. Select Invoice under Applications. Your screen should look like this:

Click Payments and select Payment Manager. From here you should find what you are looking for.

[JovitaM]

Hi Kevin,

I have the same question in regards of  how to extract the payment/invoice file (Standard_Payment_Request_Accounting_Extract) from Concur Invoice? 

I created a test invoice which is fully approved and is in 'pending payment' status. 

But we don not use Payment Manager ? Is there any options extraxt invoice and see the file not txt ?

Thanks ,

Best regards,

Jovita 

[PoojaKumatkar]

Hi @JovitaM ,

You can extract the invoice from Import/Extract Administrator or Import/Extract Monitor Section as shown below. To extract the invoice you must run the job first and then extract. However, please note that extract will be available in .txt format only. Later you can convert/copy that file data into payment extract template for your easy understanding.

Role Required: Import/Extract Administrator or Import/Extract Monitor

If this answers your query, then please mark solution as accepted.

[JovitaM]

Hi @PoojaKumatkar ,

Thank you for your responce.

I have the roles ant I know that option.

My question is , is there any other option than this one, to extract file not in txt ?

Best regards,

Jovita

[PoojaKumatkar]

Hi @JovitaM ,

With reference to below article, only two formats can be set either .txt or .csv.

May I know in which format you need extract and purpose?

[JovitaM]

Hi @PoojaKumatkar ,

It would be nice if file would be in xml format.

Purpose of my question , we need to know where each invoice field pointing at in order to map fields correctly in ny ERP system. 

Best regads,

Jovita

[PoojaKumatkar]

Hi @JovitaM ,

With reference to the article screenshot provided in my previous response, I don't think so we can extract invoice in .xml format otherwise they would have clearly mentioned in the response.  @KevinD  - Can you please confirm on this point. 

Regarding your purpose, you need data into .xml format for field mapping purpose. You can still do that by converting .txt file into excel format, do the Concur field mapping against ERP system and once mapping is done you can do the further testing. 

How we usually do field mapping is as follows:

1. Extract .txt file from Concur and convert/copy paste data into excel format (convert comma into columns). Refer screenshot below.

Note - You can take Concur provided excel formats for every import/exports. You can download these templates from Invoice technical Deployment toolkit. It will have all the specification details. 

https://assets.concur.com/concur_services/technical_consulting/technical_document_portal.htm

Open Headers and other Tool folder >> Open "Header - Pymt Request Confirmation Import v2.xlsx" file. 

Note - Below is the sample screenshot from my Invoice project. Adding here for your easy understanding.

2. With the help of this you will be able to understand which value refers to what and then you can map that field to the ERP field. 

For initial study, whichever columns (Concur fields) are important for you for the financial postings against that column you can note down ERP field name and later provide those inputs to the integration team for the mapping purpose. 

I hope this will help you to understand the mapping process.

[KevinD]

@PoojaKumatkar I'm pretty sure the only options are what you have listed in the article you referenced. Most likely it's only these two files because they are the easy to convert to other formats.