Can any one help in the following issue.
I am having 2 line items in the PO
Mat Qty Price Total value
xxx 100 50 = 5000
yyy 10 100 = 1000
At the Header level i had given condition type FRA1 with 100Rs
Now i want the system to divide the freight at the item level based on the weighted moving average.
At item level system should display as
For material xxx 5000+83.33 = 5083.33
For material yyy 1000+16.77 = 1016.77
Tota l = 6100
What settings should be made to divide freight amount based on the weighted moving average.
In the condition type definition (SPRO->Materials Management->Purchasing->Conditions->Define Price Determination Process->Define Condition Types), please make the following settings for the condition type:
(1) Group Condition: Checked
(2) Scale Basis: B(Value Scale).
Hope this helps.