Sage 100

Does anyone have a solution to creating a customized report (Crystal, SI, extended solution, etc) for BOMs with Options? I've spent some time trying to get a report to work but there isn't a good way to link BM_BillOptionHeader with BM_BillOptionCategory. The end goal is to have a report that the user can select the Bill, choose option 1 and the corresponding option codes. Choose option 2 and the corresponding option codes, etc. Has anyone found a way to do this?

What about the BM Picking Sheet?

Can you start with a canned report as Therese suggested? That might be the easiest way.

I used the Single Level BOM Report

The single level report doesn't let you select the options though. If Kate is trying to get at a listing with selected options, the picking sheet lets you do so. She could also modify it if it isn't what they are looking for exactly.

Using the pick sheet is going to work like a charm! I like it when a canned report gets you going in the right direction. Thanks @ThereseLogeais !!

@ThereseLogeais knows her Crystal forms......