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

Batch update vendor expense type

I have 25K vendors and I want to identify their expense type as invoice.  When I select all, it only lets me update one page at a time (25 vendors), and I have 486 pages.  Is there an import feature that would allow me to update all the vendors to expense type "Invoice" because right now they're all undefined.  Thank you!

1 Solution
Solution
cjmarimo
Super User
Super User

Hello @DN1313 

 

I found the following link in the official SAP Concur documentation, which I think may help you: Configuring Vendors


This document indicates that vendors can be updated through bulk import, which appears to be the most appropriate solution for a volume of 25,000 vendors.

It also states that a single import supports up to 12,500 records per file, so for 25,000 vendors you would likely need to split the update into two separate import files and perform two imports.



✔️Hope this helps! Let me know if you have any questions✔️

  Best Regards,

  CJ

View solution in original post

1 REPLY 1
Solution
cjmarimo
Super User
Super User

Hello @DN1313 

 

I found the following link in the official SAP Concur documentation, which I think may help you: Configuring Vendors


This document indicates that vendors can be updated through bulk import, which appears to be the most appropriate solution for a volume of 25,000 vendors.

It also states that a single import supports up to 12,500 records per file, so for 25,000 vendors you would likely need to split the update into two separate import files and perform two imports.



✔️Hope this helps! Let me know if you have any questions✔️

  Best Regards,

  CJ