There is a scenario for trading goods.
when buy 20 KG of product A, price = 50 per KG
subsequently add order 20 KG, we have cheaper price from vendor, 45 per KG
Therefore, we would like the PO appears as below:
item 1: quantity 20 KG, unit price = 50, total amount = 1000
item 2: quantity 20 KG, unit price = 45, total amount = 900
total amount for PO = 1900
info record scale with scale type B (To-scale) had been maintained:
quantity to price
20 KG 50 per KG
40 KG 45 per KG
but it fails to adopt the price as required.
Any idea on how the info record scale should be and is that possible the info record price adopt accordingly into PO?