Updated Address now 2

[jgeracie]

Hello,

I recently updated the address for two of our vendors and now both the old address and the new address shows in the system.  How do I get rid of the old one?

[KevinD]

@jgeracie what are the vendor names? I'd like to take a look. 

[jgeracie]

We just updated another vendor and the same thing happened to that one now too.  Is there a setting that says to add the address instead of replace the address in Concur?

[jgeracie]

WE Energies and Wisconsin Public Service

[KevinD]

@jgeracie I see what you are saying where the vendor is listed twice now. I'm asking internally how this can be avoided or what you should do. Stay tuned. I'll let you know when I hear something. 

[KevinD]

@jgeracie I was told that the best option is to simply deactivate the one showing the old address. 

[jgeracie]

It did not as we aren't sure how we can deactivate the old address in the system.  Head of the dept was talking about deactivating  and then uploading the spreadsheet again, but we haven't done that to see if it works.

[jgeracie]

I upload via a spreadsheet and that spreadsheet ONLY has the new address on it.

[KevinD]

@jgeracie when you imported, it created a new Address Accounting Code which then sees this as a new vendor. Just deactivate the vendor with the old address. 

[PoojaKumatkar]

Hi @jgeracie ,

If you want to replace existing old address with new address without creating new vendor then you can do below things:

1. Extract the old vendor using 'send to excel' option and replace "Address 1, address 2, address 3, city, state province, country" and upload it again.

Note - Please do not update 'Address Accounting Code' field. If you do so, then system will create new vendor record with the new address. 

You need to understand here below logic:

1. 'Vendor code' and 'vendor address code' these 2 fields make vendor record unique. If you try to update new address against old vendor code and vendor address code, then system will replace old vendor address with the new address without creating new vendor record.

2. If you update vendor address code and update new address, then system will create new vendor record with new vendor address code and address. Meaning 2 records for the same vendor will be displayed which should not happen. This is your current issue. 

Testing Result:

Sample Old vendor with old address:

Import the vendor with updated address.

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

[jgeracie]

That didn't remove the second account.  I have tried to upload with the accounting code matching both with the old code and the new code.

[PoojaKumatkar · Accepted solution]

Hi @jgeracie ,

If you want to delete the second account then extract that vendor first and under 'delete vendor' column pass 'Y' and upload. Once uploaded it will delete the vendor. 

The solution which I have suggested in my previous response below is to update existing vendor address.