E-mail invoices with a smarter dynamic Print management setup


Setting up the Print management for sending documents by e-mail is a very manual process in most implementations I’ve seen. It takes a user quite a lot of steps to set up a the system for sending documents on e-mail and getting it wrong has grave consequences (It actually stops your sending the invoice process, while still having the invoice posted!). I’ve dove down in to some data and found a smart way to dynamically set this up so that you only have to tag a e-mail address on the customer with a role and you’re done. This will also work with other documents like packing slip or customer statement and should eliminate the setup issue.

Let me show you how to do it!

Step 1: Set up a new contact purpose for the document.

You could use the default ones, but in my experience you should differentiate pr. document type.
Go to: Organization administration > Setup > Global address book > Address and contact information purpose

Add a new type and tick both Contact information and Postal address check boxes.

einvoice_newPurpose.png

Step 2: Set up the Print Management

So selecting what customers should receive require you to specifically trigger the customer either by filtering by a parameter or setting it up by hardcoding the customer level print management setup. My idea is to dive down to see if the customer has a contact e-mail that is tagged with the “Invoice” role (Step 1) and trigger based on that.

To set up general print management settings, go to:
Accounts receivable > Setup > Forms > Form setup | Print Management

Create a new print setup

Click the original node and setup the default printer settings and then add a new node on the original node.

einvoice_newProperty

Give the node a name (Like “E-mail”) and set up a condition for the query/filter. When the filter is true the invoice follows this setup. If not it will default back to “Original” setting.

einvoice_selectConditions

The query needs to be extended to get the required data available. You extend the query by right clicking the node and select a 1:n or n:1 relations.

einvoice_extendQuery

  1. n:1 > Customer
  2. n:1 > Global address book
  3. 1:n > Party location relationship
  4. 1:n > Locations
  5. 1:n > Communication details
  6. 1:n > Contact information and role relationship
  7. n:1 > Roles

That should give you a query like this.

einvoice_Query

Then add the “Roles” table, “Type” field and select the desired Criteria (Like “Invoice”). Click OK to close the criteria dialogue.

Setup the print to e-mail

Now set up the printing settings by selecting the arrow at the end of the “Destination” and select “Printer setup”.

einvoice_setupPrinter.png

Notice that you can add a preferred footer for the invoice.

Select “E-mail” in the left column. Then on the “To” line select the “Edit” and in the Customer purpose field select the role you created in Step 1 (Like “Invoice”).

einvoice_printSetting

Now add a subject and select the desired format (I prefer PDF).

Click OK on the Print destination setting and close the Print management form.

Step 3: Setting up a customer

This is the final step and the only one you need to repeat when you now want to add a new customer to be emailed the invoices.

Create a new email address or use an existing one on a customer.

einvoice_email1

Now select the “More options” menu and select “Advanced”.

einvoice_email2Select the “Invoice” role (or another if you created a different one in step 1) on the “Purpose” drop down. You can even have multiple roles selected if you want, so if you do a multiple setup with different documents you can add multiple roles/documents to one e-mail address.

einvoice_email3

Setup is done!


So now all you have to do is to remember to tick the “Use print management destination” check box when posting an invoice and all customers with this role on an email will get an email instead of going to print.

einvoice_posting.png

Oh… You’re welcome!

 

 

12 thoughts on “E-mail invoices with a smarter dynamic Print management setup

    1. Hi there,
      The functionality is written about many places. The thing I tried to convey was the query and how this simplify the setup. You don’t have to do all the work under “Do the same procedure for the Customer invoice purpose:” in your post…
      Without the query you would still face the issue of a customer being tried to email and the printing process crashing, leaving you with many unhandled (but still posted) documents.

  1. Hi,

    Thanks for the post.

    I wanted to use this functionality to send out Vendor Payment Advice. Is there a way in OOB, to configure email body also on the email sent to the vendor.

    Thanks in advance!
    I wanted to use this functionality to send out Vendor Payment Advice. Is there a way in OOB, to configure email body also on the email sent to the vendor.

    Thanks in advance!

  2. Hi,

    Thanks for the post.

    I wanted to use this functionality to send out Vendor Payment Advice. Is there a way in OOB, to configure email body also on the email sent to the vendor.

    Thanks in advance!

    1. Hi Hanne,
      I think you might. I don’t think you can directly in the execution, since this is per document, but you can aggregate multiple transactions into one document by setting summary update correctly.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s