cancel
Showing results for 
Search instead for 
Did you mean: 
davidk101
Occasional Member - Level 1

Concur Invoice

I'm creating invoices with sometimes 50-100 itemizations. Is there a way to upload this using an excel spreadsheet?

4 REPLIES 4
PoojaKumatkar
Frequent Member - Level 1

Hi @davidk101 ,

 

As per current invoice module design, there is no import itemization option available. However, you can copy any existing invoice which has 50-100 line items and do the necessary changes in copied invoice. 

PoojaKumatkar_1-1720681043930.png

Also, if multiple line items contain same set of information, then you can use bulk edit option. For that you need select those respective line items and click edit. It will give you pop-up window, fill in the required information and save. 

PoojaKumatkar_0-1720680918661.png

 

Thanks!
Regards,
Pooja
PaulaO
Occasional Member - Level 1

I looked at this option but I don't see an option to update the Line Description. Is there a way to add this field to use the bulk Edit options?

StacyH
SAP Concur Employee
SAP Concur Employee

Hi @davidk101

 

Yes, there is an excel spreadsheet to import itemizations. The invoice must first be open, then you can select one or more invoice lines which you want to import itemizations for, & click Distribute > Import Distributions. 

StacyH_0-1723742683713.png

 

From there you can download the template for your site's configuration. First enable editing, then click the triangle between Column A & Row 1 to select all cells, & right click to format all cells as Text to preserve any potential leading 0's you might be importing & alleviate any potential formatting issues. The itemizations, or distributions, will need to be the code for your company's cost objects, rather than the name. Enter in the Excel spreadsheet either the amount or the  % you want to apply for each distribution, then when you upload the file you will need to indicate if you are distributing by amount or percentage. 

StacyH_1-1723742724921.png

I hope that helps!

 

Thanks,
Stacy

Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
LShumway22
Occasional Member - Level 1

Is there a number users can call for support to help navigate this website? The number listed to help answers a few questions you're allowed to choose from, but there are no options to reach a person for Tech/Support help.