How can i write a view to get manufacturing finished product, min(QOH(components of finished product)), sum(cost*quantity in bom
For example i have bom : Product: p1 components: c1 quantity=2,c2 quantity=3,c3 quantity=4. cost of c1=rs 10, c2=rs 20, c3=rs 30. c1 QOH=10, c2 QOH=12 c3 QOH=13. I need a view like:
p1, min(10,12,13) , sum( 10*2,20*3,30*4). Please help me..
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/6/14, 9:41 AM|
|Seen: 459 times|
|Last updated: 3/16/15, 8:10 AM|