Excellent. Will try it.
Why were on the subject of header and lineitems, I have a problem with the Report. In the Detail section I created a table to read the detail lines of the invoice. FIND LineItems WHERE LineItems IN InvoiceHeader.LineItems.
I have:
- Query of Invoices with Multiple checked
- Have button to print selected invoices
- Have Document template which has the header and footer info, and the table for the lines items mentioned above.
What happens is if I print 1 invoice it works fine.
If I print two invoices, it prints the correct header, it prints the table linesitems from the first invoice, and right under it, it prints the table for the second set of line items. Then under that it prints the totals for the second invoice.
Like:
Invoice 1
ABC customer Inv 1
Date inv 1
Product, Price, Quantity, Amount (Table header)
Widget 10.00 4 40.00 (inv 1)
Hammer 5.00 3 15.00 (inv 1)
Product, Price, Quantity, Amount (Table header)
Widget 2 10.00 3 30.00 (inv 2)
Hammer 5.00 4 20.00 (inv 2)
Then the comment prints: but it is the comment for invoice # 2
Then the total prints - And its 50.00 which is the total for Inv # 2.
So its like it reads the lines, skips the footer info, jumps to the next set of lines, and then it seems its on that invoice so it prints the totals of the last invoice in this case # 2.
My understanding is if I use a query and multiple is checked, it should process one invoice at a time and my query should be correct for the detail? FIND LineItems WHERE LineItems IN InvoiceHeader.LineItems.
Thanks for any feedback. Mark
