Skip to Content
0
Former Member
Oct 12, 2015 at 10:08 AM

Info record with quantity scales

54 Views

Dear expert,

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?