Good evening everybody, 

 

I am creating an invoice system with 2 tables: the 1st one contains the product lines that are sold and the 2nd one includes the invoices. Both tables are related.

 

Anyway, I created a layout to print the invoices that has a header for each invoice, a portal where are shown only associated products with each one and footer with the final amount (with VAT included and not).

 

The problem is that some of those invoices have more than 30 sold products and I don´t get to do a layout that allows printing it in multiple sheets keeping the header and footer. 

 

I am now doing a new layout, but listing products sold. The problem is  that all products are shown but unfiltered. 

 

Could anyone help me? 

 

Thank you very much, 

Wardiam

You almost always want to print from the child table (line items). Not sure what you mean by "unfiltered".

Hi Comment,

 

I will try to explain it. For example, if I have 3 invoices with 5 products sold in each one, in the table "invoices" I have three records (one for each invoice) and in the table "line items" I have 15 records in total. In both tables, there is a field "idInvoice" that relates both tables.

 

I want to print an invoice with only associated products (items). If I do a layout with a portal, I get this result but whenever the number of items does not exceed the size of the portal. The second option that I tried was to replace the portal for a list of items (in list mode) but in this case I don't get to show only the related products to each invoice (I cannot filter the products) and the 15 products are shown.

 

How could I get to print only the associated items?

 

Thanks,

Wardiam

If you're printing one invoice at a time, start by:

Go to Related Record [Show only related records; From table: “LineItems”; Using layout: “PrintInvoice” (LineItems)]

Thanks Comment,

 

perfect, it works now with your suggestion.

So if I'm right, you never start your lay-out from you invoice table, but form the invoice-items? 
Have the same challenge right now. ;-) 

This question is about printing, and as I said above:

On 10/14/2014 at 2:11 AM, comment said:

You almost always want to print from the child table (line items).

 

I have this right now. 
It kind of works, but I can't access the field of the invoice itself. 

I need them to make a summary ofcourse. Or am I totally wrong here? 

 

Have a look at the demo here:
http://fmforums.com/topic/63425-auto-fill-one-field-with-text-from-two-fields/#comment-300150
Specifically, at the PrintInvoice layout.

3 hours ago, thijswostyn said:

I have this right now. 
It kind of works, but I can't access the field of the invoice itself.

The invoice fields are not on the layout because you did not put them there.

Put them there.

Put the invoice (parent table) fields on the layout.

Screenshot from converted Comment file.

 

Edited May 24, 20169 yr by BruceR

OMG you guys helped me out like A LOT.