Can I print every invoice as a new pdf with invoice number as file name?

[devingray_2000]

What would be the easiest way to create a pdf of all or select group of invoices and have it create a new pdf for each one and name the pdf with the invoice number.
Right now we just print a date range of invoices and print and send them. But i want to be able to email individual ones to email to customers and for them to be in a folder on the network for any employee to be able to grab it and send it on the fly.

[devingray_2000]

Re: Can I print every invoice as a new pdf with invoice number as file name?

to be clear i dont want to have to insert every invoice number.

[Stan Mathews]

Re: Can I print every invoice as a new pdf with invoice number as file name?

to be clear i dont want to have to insert every invoice number.

How do you want to indicate the invoices you want to print? A query/filter?

In AlphaSports this saves to c:\temp an invoice in pdf format for each invoice where the invoice_header date month is July (7).

inv_list = table.external_record_content_get("invoice_header","alltrim(invoice_number)","invoice_number","month(date) = [COLOR="#FF8C00"]7[/COLOR]")
invcs = w_count(inv_list,crlf())
for qx = 1 to invcs
	report.SaveAs("Invoice","[COLOR="#0000CD"]PDF[/COLOR]","invoice_number = "+quote(word(inv_list,qx,crlf())),"","[COLOR="#FF0000"]c:\temp[/COLOR]"+chr(92)+"Inv_"+word(inv_list,qx,crlf())+".pdf")
next qx

The invoice is saved in the format Inv_000029.pdf.

[devingray_2000]

Re: Can I print every invoice as a new pdf with invoice number as file name?

Thanks for your reply and example code.
long term i would like both, one for asking user input for range (date and or number range) and one to be a script to run daily to save and update all inoices

[devingray_2000]

Re: Can I print every invoice as a new pdf with invoice number as file name?

Lets say we start with a filter

[Stan Mathews]

Re: Can I print every invoice as a new pdf with invoice number as file name?

My example uses a filter.

[Ray in Capetown]

Re: Can I print every invoice as a new pdf with invoice number as file name?

Thats really neat Stan.
To automatically generate the invoice behind the scenes helps me with a problem I was working on.
But what I want to know is how you read the question, thought over it, wrote a script and posted a working reply in 12 minutes flat?

[Stan Mathews]

Re: Can I print every invoice as a new pdf with invoice number as file name?

Practice.

Devin,

If you want some specific help you are going to have to provide more details and possibly a sample of your database.

Lets say we start with a filter

Advising how to use what I gave you for a sample would require table names, field names, the invoice report name, the path where you want to save the pdf files, and at least a description of what your filter should do.

[Tim Kiebert]

Re: Can I print every invoice as a new pdf with invoice number as file name?

Thats really neat Stan.
To automatically generate the invoice behind the scenes helps me with a problem I was working on.
But what I want to know is how you read the question, thought over it, wrote a script and posted a working reply in 12 minutes flat?

He must Have been having a slow day. ;-)

EDIT: Rereading my post it comes across as he did not have much else to do. What I meant was he took longer than he usually does.

[MoGrace]

Re: Can I print every invoice as a new pdf with invoice number as file name?

Perhaps he keeps a daily backup of his brain..

[Al Buchholz]

Re: Can I print every invoice as a new pdf with invoice number as file name?

And here I'm wondering how Stan was able to write 19077 posts in one day.

Boy am I off base of the question..