Create Invoices using multiple Lines
Hello,
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.
Lines Example
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.
Thanks
-
If you only add two rows on your Page template then records 1 and 2 will print on the 1st page and record 3 on the second, such as
0 -
I would use a SQL query with a pivot. The Pivot combines 2 rows into 1
0 -
Goedemorgen Mike,
het combineren van rijen is rijen ed is mij wel gelukt, wat ik wil is, als ik een palletlabel wil uitprinten dat in een vakje het palletnr ingeef dat ik dan alle artikelen op een label krijg en uit print.
gegroet Art
-1
Please sign in to leave a comment.
Comments
3 comments