Vendor Id

Terri Milburn

Is there a way to manually assign a vendor id in webview? We have certain vendors we add using a specific id to match our other records. We were able to manually assign vendor numbers in database view but it does not seem to be an option in webview?

Kevin Brazell

@Terri Milburn
There is, it's under Payables, Settings, Vendors. The top items are setting a sequential numbering system so when you add a new one FE assigns it the next number.

Dan Hout-Reilly

@Terri Milburn Hi Terri. I need this option as well in NXT. I need to be able to enter a specific vendor ID for some vendors, which I currently can do in DB view. I do not see this option in NXT. (For our other vendors, the sequential ID is sufficient).

Terri Milburn

@Dan HoutReilly It is very frustrating for sure. The only way I can figure out a solution is to change the sequential number in Settings to the one I need, add the vendor, and then change the number in Settings back to the next sequential number.

Terri Milburn

@Kevin Brazell We do use sequential numbering for most of our vendors but there are some that require a special number that does not follow the sequential numbering system. We have been able to manually add those numbers on the vendor record when setting up the vendor in database. Now it looks like I will have to do a work around by modifying the sequential number when adding one of these unique vendor ids and then changing it back after adding it.

Alex Wong

@Terri Milburn
FE NXT does not currently allow this as you are aware. Might want to check the Idea bank to vote or add a new Idea on this.

I also checked the SKY API and it seems you cannot edit the vendor id after the vendor record is created also. You CAN specify the vendor id at the time of creating a new vendor using SKY API only.

Laura Hofstrand

@Terri Milburn This will also cause us problems as we import invoices from another system and they are linked on VendorID. We manually change our vendorID to match what the other system shows.

Michelle Nielsen

@Terri Milburn thank you all for the information, we have the same issue for some of our vendors. i will instruct staff on the removal of the sequential numbering for those vendors.

Carolyn White

@Alex Wong Voting on ideas is getting frustrating when things in Database view are important to different companies for different reasons. We need to match one type of vendor to another system but sequential is fine for other types of vendors. Very frustrating and time consuming.