My client want to have a report in which they can see cost details production order wise. To make it clear All production orders (for all products) for a given period (better if dates can be given and the cost components can be drilled down) should come in rows and all cost components should come in columns. Sample is given below:
Production order Material Qty produced Cost comp1 Cost comp2 Cost comp3 Cost comp4 Cost comp5..............
300005 ABC 1000 20000 5000 6000 7000 8000
300006 XYZ 1000 30000 4000 5000 6000 7000
300007 ABC 1000 20000 5000 6000 7000 8000
This all they want on single hit. Through order summarisation reports I can see order wise for a product at one time but not orders and products altogether. Actually this way they want to see how the costs have been used for production.
With thanks in anticipation and high regards