Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! 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