This content has been marked as final. Show 2 replies
HiTypical workaround..don't know whether it will fit you
Is it possible to link a manually created purchase order with a PR in database?
What we do here is..we go to auto create select the requisition which we want to add to exiting standard PO then go to PO delete the line(cancel PO line) which was original available in the PO..so we left with the requisition line which we copied from the auto create..which is been referenced now..
But this requisition will not be viewed from PO summary..as this is not the one which is originally created from auto create
I think it can be done via updating backend tables....
Edited by: 843237 on Feb 20, 2012 3:37 PM
Edited by: 843237 on Feb 20, 2012 3:39 PM
Please refer the below MOS Note : How to Get the Purchase Order (PO) Number From a Requisition Number Via the Tables (Doc ID 169095.1)
To get a PO number from a Requisition number via the tables, run the following
SELECT poh.segment1, pol.line_num, poll.shipment_num
FROM po_headers_all poh, po_lines_all pol,
WHERE porh.requisition_header_id = porl.requisition_header_id
and porl.line_location_id = poll.line_location_id
and poh.po_header_id = pol.po_header_id
and pol.po_line_id = poll.po_line_id
and porh.segment1 = ####;
If you check the above query, you will understand- how they are linked.
porl.line_location_id should be equal to poll.line_location_id.
However, I wont suggest you to manually create the link, as it may cause few problems:
The approved requisition will have separate entry in Supply tables (mtl_supply) and PO will have separate entry . (ideally, if it is autocreated - it should have a single entry).
If you have encumbrance enabled, it might cause other issues with requisition encumbrance and po encumbrance
If you cancel the PO, not sure whether the backing requisition too will get canceled without any issue.
Personally i feel, it is not the good practise to establish the link manually.