Solved

How To Print Multiple Invoices Into Single PDF File

  • 25 August 2020
  • 3 replies
  • 1801 views
william.klotz
Rank
Userlevel 7
Badge +21

Hello Everyone,

 

We currently generate one invoice per customer order and email the customer a PDF of the invoice during the invoicing process.  Some of our customers have requested we send them just one PDF containing multiple individual invoices.   The customers want a separate invoice number for each order which we believe rules out using collective invoices.  Finance would like to have IFS basically print each invoice into a PDF and merge each new printed invoice into the same PDF so when a customer opens the PDF they’ll see multiple invoices within the same file.

 

Thank you,

William Klotz

icon

Best answer by william.klotz 20 October 2020, 15:58

View original

3 replies

cperdue
Rank
Userlevel 6
Badge +14

William-

Have you tried create collective invoice by order option?

I believe this should create one invoice per order.  

Respectfully-

Christy

Best- Christy
william.klotz
Rank
Userlevel 7
Badge +21

Christy,

 

Thank you for your reply but we do not think the collective invoice will work for this customer because only one invoice number is generated for all the orders.  While the collective invoice does produce one report which contains all the invoiced orders it would appear all the orders use only one invoice number. 

 

The customer wants a separate invoice number for each customer order but wants us to deliver a PDF containing multiple invoices in a single PDF.  What we’ve been doing is printing the invoices to a PDF then using Adobe to merge the individual PDF’s into one consolidated PDF that we send the customer.

 

We’d like to be able to produce the consolidated PDF from IFS to reduce the manual labor involved with merging the PDF’s together.  This is a high volume customer that has a lot of invoices each day.

 

Thank you,

William Klotz

william.klotz
Rank
Userlevel 7
Badge +21

From @CallumW ,

 

There is no easy way to just merge PDF’s together using any IFS Features or Oracle tools.

 

Although no easy way, it isn’t impossible… (But both require adding in some Java files to your database)

  1. You can google for PL/PDF which is a paid for solution which has a toolkit to merge PDF’s via Oracle. 
  1. Alternatively if you are technical you could look to create your own customization using tools such as iText to merge PDF files via Oracle.
  • You could then create some PL/SQL code to merge the PDF’s together and print out / email

 

As you have stated the invoices are only really used for backup purposes - I personally do not use report designer so cannot comment on that - however if I were looking to implement a solution I would create a Crystal QUICK Report and the steps would be as follows: 

  1. Create a custom Menu Item on customer invoices screen - ‘Print Special Invoices’
  2. Highlight multiple invoices and pass the invoice no’s as parameters to the report.
  3. Split the parameters upon entry in crystal and add in data connections via sub report in details section to CUSTOMER_ORDER_IVC_REP to get the latest printout for each invoice and pull the desired information from CUSTOMER_ORDER_IVC_REP. (You would need to run the RMB before the reports are removed from the archive)

 

Callum

Reply


Terms & ConditionsCookie settings