R12 the average cost update has been enhanced so that it can transferred IPV to items that are in in

Hi

I have a question regarding Invoice Price Variance.
The program transfers the variance posted to GL from the PO/Invoice match to inventory. The variance is always transferred to invetnory even though the items have been issued out of inventory and charged to Cost of Goods sold.

 

We would like to only transfer the variance to items that are still in inventory. And the remaining IPV that is not tranferred  to inventory should be transferred to Cost Variance.

Example:

Goods receipted are matched to invoice, and create an invoice price variance of $20 ($10 per item).one of the items has already been shipped as part of an order and becomes Cost of Goods Sold, BEFORE the purchase receipt is matched to the invoice.