Dear Experts,
I have a Sales BOM in the INV1, I would like to create stationary that groups the all the child items sums up the quantities to the parent item. I want to hide the child items and sum up the total quantity to the father item code. This report can only focus on the INV1 since on the OITT and ITT1 table the child items can always be changed even though a transaction has been done against the BOM. Hence they cannot be relied on for historical data.
The challenge is creating a grouping mechanism to group the related parent and child since there is no obvious like between the parent and child in INV1.
Has any one ever come across this before ?