Update Buyer across many parts

[Jeff_Owens]

Hi folks,

I found this post in 10.x regarding this subject:

Updating Buyer on all Parts by Vendor UBAQ

I’m trying to allow our Buyers to change who is assigned to Parts for each Vendor. i.e. they want to shift all parts assigned to a specific vendor to a different Buyer. There isn’t any native way in Epicor to assign a Buyer to a Vendor, at least as far as I’ve found, so I’m trying to do this with a UBAQ to update the Buyer on all relevant PartPlant records at once. I’ve got one that’s working for myself, but it doesn’t seem to work for another user, who is a Security Manager, so I don’t think…

…but we have thousands of parts that need to shift. Does anyone know if/why there’s not a way to change a buyer in mass native in v11 yet?

Thanks!

[Ernie (Ernie Lowell)]

This looks like a job for DMT…

[JChappell (Jeff Chappell)]

Agreed. We used a BAQ to pull the relevant PartPlant records we wanted to convert into Excel, mass updated the buyer field to the new employee, and then DMT’d the change in.

[Eric_Howell]

Possible idea is to use a UD field on supplier to set BuyerID.
Then create a uBAQ to calculate on part plant level based on Primary Supplier to determine the BuyerID for a part.
Then via BPM directive set that value on the get list call, map the calculated field to the Buyer field.
I would set this on a schedule via the export BAQ process.
We do this for a couple of different tables to run logic and update values.

[Jeff_Owens]

This is a clever thought @Eric_Howell . Not sure why something like this doesn’t already exist native in the client though. People change roles all the time, Epicor!

[Eric_Howell]

You could also tie in Part Class where you can set a BuyerID as well to add another level of complexity.