How to Manage Quarterly Item Price in Purchase Order.

Summary:

Below is the Steps/scenario for which we are looking for suggestion/ solution/ Best Practice which we can follow.

Requirement Background :- We are maintaining the purchase price for an item on quarterly basis for finished good based on final discussion with Our Buyer and Supplier commodity team. Whatever the unit price agreed with Our Buyer and Supplier, that price is apply when we receive the shipments from our supplier.

Please see the below scenario.

Assuming Buyer is planning to purchase a finished good "100-04617" @unit price of $3000 for Q1. so buyer has created a requisition.

1. Requisition Number#1234

2. Requisition Line Num#1 Item - "100-04617", Quantity - 100, Unit Price $3000, Requested Delivery Date - 25-March-2023. (i.e. in Q1)