I did a series of reports (for one customer) focused on the sales side (component requirements), with multi-layer bills, and can say it was 100% impossible without SQL Views to deal with the data complexity.  If you only have single-layer bills, I suppose a sub-report could pull in the open PO details for whatever shape of main report you are starting with.

I did a series of reports (for one customer) focused on the sales side (component requirements), with multi-layer bills, and can say it was 100% impossible without SQL Views to deal with the data complexity.  If you only have single-layer bills, I suppose a sub-report could pull in the open PO details for whatever shape of main report you are starting with.

Thanks for your quick reply. I'm going to look into this tomorrow.  Should I assume that you're a SAGE consultant? or user?

Hover your mouse over my picture, and you can see that I am a Sage partner / consultant.