How to condense a material that exists on multiple lines into a single summed qty line

3 weeks ago 6

I person a semi unsocial request and I cannot look to find a station that addresses directly.

In summary, we presently usage quotes and orders, but are adding inquiries arsenic well.  Inquiries volition incorporate an AVC BOM that has aggregate levels utilizing phantom items arsenic an assembly.  So an punctuation presently could look like:

Item #Material #QtyItem CategoryHigh Level ItemType of Matnr
10AVC_MATERIAL1ATAM0AVC Material - 0004
20   AVC_MOD11ATAM10AVC Level 1 - Module 1 - 0004
30      MAT_PHAN150ATAM20Phantom BOM - 0004
40          MAT_125AGB30TAN Material - NORM
50   MAT_225AGB10TAN Material - NORM
60   AVC_MOD11ATAM10AVC Level 1 - Module 1 - 0004
70      MAT_PHAN100ATAM60Phantom BOM - 0004
80          MAT_115AGB70TAN Material - NORM
90   MAT_225AGB10TAN Material - NORM

And what we are trying to bash is get the NORM's to rotation up into a azygous enactment for each material, leaving retired each the configurable materials.  Currently trying done a pricing regular but it is not astatine each consecutive forward.  The lone different enactment I thought of was to measure the punctuation (Pro forma) and lone see the point cats one want.

Item #Material #QtyItem CategoryHigh Level ItemType of Matnr
10MAT_140AGB0TAN Material - NORM
20MAT_250AGB0TAN Material - NORM

Has anyone ran crossed this?  

Read Entire Article