Question:
Hi
I have a reporting scnario where we would like to know the cost per tonnes for each line and for the sales order in total.
The costs are created for different legs and one leg could be split into multiple deliveries (costs could come from different vendors (like leg B in this example)).
The quantity for the sales order is 1 TNE – the transportation is split into 3 different legs.
Summation of Cost/t (correct sub-totals – wrong total):
Cost (EUR) Delivery quantity (TNE) Cost/t
Leg A 200 1 200
Leg B 50 0,5 100
Leg B 50 0,5 100
Leg C 100 1 100
===============================================
Total 400 500
However we could add a ratio (Delivered quantity divided by sales order quantity), and this would give a correct total, but wrong sub-totals for the lines (cost/t = Cost / delivered quantity x ratio):
Cost (EUR) Delivery quantity (TNE) Ratio Cost/t
Leg A 200 1 1 200
Leg B 50 0,5 0,5 50
Leg B 50 0,5 0,5 50
Leg C 100 1 1 100
===============================================
Total 400 400
Is there any std. feature that you can use to handle this requirement or do you have to use two seperate colums in the report?
Appreciate all creative input
Cheers,
Tom
Answer:
Probably Exception Aggregation could help you.
Also otherwise, you can implement this at update rule level....Can you modify ur update rule/InfoCube?
Regards,
Parin
_________________
Regards,
Parin