Print Invoice and packing slip
The database tables are set up as follows,
Table 1 have the customer information. customer's name, address, etc.
Table 2 have the general invoice information. Invoice number, ship date, PO,
Table 3 have the invoice lines information. Item code, Item description, price, quantity, etc.
I did create a table object where it gets the information from the invoice line.
But where I am getting stuck is at the header and only to print the items under the same invoice on one page.
How do i brake when field change in the database? For an example In the database one column has the invoice number, so I want when the invoice number changes it should start on the next page.
Thank you
-
Assuming the data in your tables has a unique record on each line then you may need to have a look at your join condition to make sure that you have the correct links so that it pulls out the correct unique record from each table
Have you tried adding a Database filter/query or similar where you have to select the invoice you have to print?
0 -
The join I did and its okay. But I am looking to print with out any prompt just everything that is in that table. and it shuld print multiply invoices at a time.
0 -
Not sure why this popped up as a message in my inbox today but I think this is what you are actually looking for
Setup up your template and page template as required and amend the Page Break as above. At print time you should then get something like this, where 001 and 002 are the invoice numbers and the 1111 & 1112 and 1111,2222 & 3333 are the products on each invoice
0 -
Solved page brake based on data.
But how do i set up that the header should match to the invoice lines? for example the invoice number and customers name should get changed in the header after a page brake.
0 -
Enable the Page Template and then select the Page Template tab and add those fields to the that rather than the labels
0
Please sign in to leave a comment.
Comments
5 comments