Vendor Master in one DB and Employee Master in another

3 posts / 0 new
Last post
dhuffman63
Offline
Joined: 07/18/2019 - 11:20
Vendor Master in one DB and Employee Master in another

I'm trying to detect if I have in my ERP database vendor master file (Great Plains) employee names that reside in a different database (Vista/PDS).  I tried joining the two on address ID but that didn't work very well.  Is there another way to do something like this?

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Sounds like you should be doing a fuzzy match.  If you have 11.1 go to the IDEA Lab and check out the Fuzzy Match script (there is also a video  on how to use it).  If you are using an older version here is a video on how you might want to do it manually - https://www.youtube.com/watch?v=Lu3mwVqE-G4

dhuffman63
Offline
Joined: 07/18/2019 - 11:20

For some reason I can't get it to extract but it does sound exactly like what I need.  I am in 11.1.  WFH so that could be the hold up.  Not a prioroty right now though...thanks!