I need some help understanding the best way to handle something that is causing many issues.

Scenario:

Team place an Order for Qty 10 x Keys

Order is placed from Work Order Requisition and Converted to a PO

PO is placed with Supplier

Before delivery, it is noted that we now only require Qty 6 x Keys

PO Change Order is done to reduce Order Qty to 6 and Supplier Updated.

Work Order Requisition still shows Purchase Qty as 10

Work Order Required Materials still shows Qty 10

Qty 6 x Keys delivered by Supplier

Receipted and Issued to Work Order

Required vs Issued shows difference of 4

Planned Costs vs Actual shows the value difference of 4

How do we handle this so that the Work Order Requisition and Material Line Qty’s are reduced to the qty in the Purchase Order? We cannot change the Required Qty in the Material once the PO is created and we cannot Cancel the PO as it has been satisfied?

What would be the best way to handle this? Would it be to cancel the PO, reopen the PR, Delete the PR, Delete the Materials and then place a new order for the reduced qty? 

Is there a way to change the Planned Qty on the Work Order?

We have this issue frequently and it is starting to cause an issue with reporting and management of the parts.

Thanks in advance,

Lisa