PO Pricing need based on Receipt date or ASN shipment date :

Hi,

We have need to have PO price based on the receipt date or ASN shipment date, as our prices are changing  frequently and there is big lead time to reach material from the supplier to location to our plants ( 6 to 8 weeks), the problem we are facing is Supplier wants the price to be ship-date price ( ASN creation time, they input the shipment date)and invoice to be generated based on the ship-date but not the need by date.

We have GBPA and standard Purchase Orders are getting released from ASCP ( the flow is totally automated, no manual interference in this process), Oracle's standard functionality picks the price from need by date.  We can use the pricing custom hook , when ASN is created but the problem is we need to revise the PO and the complexity there is if there are partial receipts are done at different dates this will create variances in PPV or IPV with wrong price.