This content has been marked as final. Show 3 replies
If you want to talking about PO buyer at PO header level, then just try in TEST instance .
Run the SQL.
set agent_id = < new buyer id >
where org_id = <operating unit >
and agent_id = < old buyer id >
old/new Buyer id you can get from :select * from PO_AGENTS_V
My requirement is replacement for all items for that specific buyer to another buyer for all those items.
For the query you have given... probably we have direct front end form to do the same.
Can any one advise on this.
Sanjay, you can run the "Mass update of buyer name on purchasing documents" request instead of a backend update of purchase orders.
However there is no request to update the items.
You will have to run a sql.
update mtl_system_items set buyer_id =&newid where buyer_id=&oldid
The other option is to use the item master api/interface.
Edited by: Sandeep Gandhi, Independent Consultant on Sep 23, 2010 3:24 PM