Create Invoices using multiple Lines 追蹤

0
Avatar
Michael Dunstall

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 

 

3 意見

0
Avatar
Pete Thane
評論操作 永久連結

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
Avatar
Mike Wright
評論操作 永久連結

I would use a SQL query with a pivot. The Pivot combines 2 rows into 1

0
Avatar
Art Onings
評論操作 永久連結

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

登入寫評論。