We create a Scheduling Agreement with reference to Purchasing Contract.
Several of the Contracts have pricing scales behind the material, based on quantity ordered and these scales are also required behind the Scheduling Agreement.
Our problem occurs when we goods receipt; the valuation of goods is taken from the total amount being ordered rather than the quantity received e.g. The delivery schedule has a total scheduled quantity of 500KG; the price for 500KG = £3.50 per KG. We have the first scheduled delivery of 250KG and a second to follow in 3 weeks. The price for 250KG = £4.50 per KG. The goods receipt of 250KG is valuated at £3.50 per KG but the vendor invoices us at £4.50 per KG.
Is there a way to valuate the goods receipt in accordance with the price for the quanity received rather than the total scheduled quantity?
We are using version 4.7.