Printing Multiple Invoices

[spiritchaser126]

Hi, I apologize for this dumb question. I have a line item db which consists of cust #, inv #, date of inv, item code, item description, amount. There is an invoice layout with a subsummary.

If I manually select each inv #, I can print the invoice without issues.

My boss wants to enter one invoice date in a find, which would return a large group of records, and print all invoices based on inv #.

Currently, all found records (based on the date) print on the invoice, regardless of inv #. Within the found date, how do I tell FM to print all the line items associated with that invoice #, then move on to the next, and the next?

[bcooney]

There are two ways, but with your setup I bet that all you need is to build a looping script, "Print Invoices Found."

The script would look something like:

Go to Layout Invoice List

Go to Record First

Loop

Perform Script [Print Invoice}

Go to Layout InvoiceList

Go to Record Next [Exit after Last]

End Loop

[spiritchaser126]

Thanks for your quick response! How do I omit the records that are not associated with that invoice # each time during the loop? Or am I missing something within the find itself?

(in other words, invoice #12345 may have 5 records - find all records that match invoice #12345, go to layout invoice, perform script "print invoice"... find all invoices that match #12346.. print... find all invoices that match #12347.. print...)

[bcooney]

I messed up, I didn't realize that you didn't have two tables: an Invoice table and an Invoice Line Items table. I thought that you could print from the Invoice table via a loop.

If you're printing from the line item table, and you've sorted by Inv# with a page break on each occurrence in the subsummary by Inv# part, I think you'll get a page per invoice.

[spiritchaser126]

You are a Goddess, thank you so much!

That worked, as well as alleviated an entire afternoon of frustration.

[bcooney]

Oh I'm so happy that worked! Good for you. I'll remind my husband that I'm a goddess B)