>
>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
