>

* For crsMLE
>>PartNum QtyPer TotalOnHand QtyRequired NetQty CurQty
>>100000    2        100          20        80    10
>>100001    1        100          10        90    10
>>100002    3        100          30        70    10
>
>* For crsCNT
>>PartNum CurQty PartDesc
>>102031    10   Assembly 101
>>100001    10   Assembly 102
>>100002    10   Assembly 103
>
>* For crsPM2
>PartNum PartDesc ....
>100000  Part A
>100001  Part B
>100002  Part C
>

>crsPM2 is the Part Master list. crsMLE is the data gathered after Bill of Material Explosion per assembly. crsCNT came from Sales Order. The PartNum in crsCNT is the Parent Part number of the assemblies and the CurQty is the total number of order per assembly.

And the desired result from these values?