So here's my dilemma. We've got a business process that we've married to the Sales Order to Invoice process. My desired outcome is that I want to use a single Sales Order record and use the data recorded on there to generate a multiple page PDF. We've got our employees putting lines onto a sales order and sort of grouping them together using the description and subtotal items. So for a single sales order we'd have Area A, a few line items, Subtotal. Area B, a few line items, Subtotal. As of now it's fine to invoice this out to the customer as is. In fact, we prefer to have all the items consolidated into a single invoice like this.
The problem comes in that we want to be able to take only the lines from Area A and print it out to a PDF, the lines from Area B on a separate PDF, etc. It doesn't even have to be a PDF. Just ... something that chunks these areas out separately so they can hand the information to our installers and send them on their way.
I tried to get a report built and that ended horribly (no surprises). Right now I've got a custom saved search linked up from the Sales Order form that will spit out the lines of the transaction so we can export to Excel and manually page break it out. But this is unnecessarily messy and I'd love a one click answer for them.
I was wondering if there was a BFO function that I could use that when it sees a certain line item (I could make a custom description item that would be the trigger) that would perform a page break for me? Then I could setup header information to repeat on every page and page break it out on areas using the custom item? Problem is I have no experience with BFO so I'm clueless as to if that's even a possibility. The data I need is pretty simple, 6 or 7 fields in the header and 3 columns to report in these areas.
We had discussed just making multiple sales orders to break the information into physical areas, but the problem comes to billing them out in that we can't get an invoice that shows all the sales orders billed on one document, which is important for our customers. If I'm missing something with this option that would be a better route, please advise...
Thanks in advance for your help guys.