Update PO price with relevant Quotation price
Hi
We have a requirement in Purchasing where users will have different quotations for same supplier-item combination based on Project and Task. Users will raise requisitions with relevant Project and task. When standard Purchase Order is created from these requisitions, price from latest quotation for that supplier-item is being copied in the Purchase order and not considering project and task while deriving the price.
We tried to achieve this requirement by modifying the hook script PO_CUSTOM_PRICE_PUB.GET_CUSTOM_PO_PRICE. But the issue is that the parameter po_line_id is having latest quotation line id. Hence, we could not derive correct price using this package.
We have a requirement in Purchasing where users will have different quotations for same supplier-item combination based on Project and Task. Users will raise requisitions with relevant Project and task. When standard Purchase Order is created from these requisitions, price from latest quotation for that supplier-item is being copied in the Purchase order and not considering project and task while deriving the price.
We tried to achieve this requirement by modifying the hook script PO_CUSTOM_PRICE_PUB.GET_CUSTOM_PO_PRICE. But the issue is that the parameter po_line_id is having latest quotation line id. Hence, we could not derive correct price using this package.
1