Create Invoices using multiple Lines Follow
Essentially what we are wanting to do is create an invoice for our customers using bartender, the Document will have the Reference number, Delivery address and the Item and item description which is read from each individual line.
Although using the SQL query that we have it pulls back three separate lines for each item
The first 2 Lines are customer 1 and the second line is customer 2.
Line 1 - CP1Address1,CP1Address2,CP1Address3,CP1Address4, CP1Postcode, Item1, Item1 Description, Reference
Line 2 - CP1Address1,CP1Address2,CP1Address3,CP1Address4, CP1Postcode, Item2, Item2 Description, Reference
Line 3 - CP2Address1,CP2Address2,CP2Address3,CP2Address4, CP2Postcode, Item1, Item1 Description, Reference
How can we create a document where Line 1,2 are on the same document and a separate documents is create on Line 3 for its own separate Invoice.
We have tried using the page template to create multiple labels on one page but we are unable to separate the third line onto a new document.
Any recommendations would be highly appreciated.