Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
What am I doing wrong with my quantity totals in Multilevel Reports?
For example, I have an assembly 400.asm. Within it are (4) 300.asm's, that each have (6) screws 100.prt and (1) plate 101.prt.
So the multilevel report should show (1) 400.asm, (4) 300.asm's that consist of (6) 100.prt's and (1) 101.prt's.
Instead the report shows (1) 400.asm, (4) 300.asm's, (24) 100.prt's, and (4) 101.prt's.
This will result in a magnitude increase in parts required. Specifying the (4) 300.asm's will naturally bring along (24) 100.prt's and (4) 101.prt's.
How do I get the multilevel to stop multiplying the items wty required by their owner's qty required?
TIA
