I have to export a payment file to import into another system which imports on Vendor ID, so I have to do a VLOOKUP every week to input that information into the file. Seems simple enough to add that column?
Thanks!
I have to export a payment file to import into another system which imports on Vendor ID, so I have to do a VLOOKUP every week to input that information into the file. Seems simple enough to add that column?
Thanks!
Hi Brett,
We have the exact same situation. I created a custom field under vendor settings. I am able to bring that field into my CSV export. You have to stay vigilant though because any time you create a new vendor in Ramp you have to go to their vendor profile and put their ID from the source system.
Good luck!
Thanks Sarah! I did the same thing, however there are two different areas that you can export from, Accounting and Bill Pay. It exports from the Accounting area, but not Bill Pay, which is what I need to be able to capture payment #s for our scholarship system and I am just not seeing it there, but could be I am missing something.