Create a Report to View Undelivered Billing Emails

Overview

Once the Billing PDF emails have been sent, you will receive a summary email with the Billing email results. If the results indicate that one or more emails were undelivered, you can create a custom report to view those emails.

Note: For information about automating the email Billing process, refer to the Automate Email Billings knowledge article. 

Note: For information about setting up an Org Wide email address, refer to the Create an Organization Wide Email Address section of the Configure Standard PDF Formats knowledge article. 

Create a Report to view undelivered Billing Emails

1. Click the Gear icon and select Setup.
   
   
   
   
2. From the Quick Find search textbox, enter Report Types.
3. Select the Report Types hyperlink.
   
   
   
   
4. Click Continue.
5. Click New Custom Report Type.
   
   
   
   
6. Complete the following:
   1. From the Primary Object drop-down list, select Billings.
   2. Enter Billings with Bounced Emails in the Report Type Label. Then, press Tab to display the Report Type Name.
   3. Enter a Description.
   4. From the Store in Category drop-down list, select Other Reports.
      
      
      
      Note: Since this report is in the process of being created, for now you want to leave the In Development radio button selected. Once the report is completed and you want to make it available to other users, you can select the Deployed radio button, which is in a step at the end of this article.
      
      
7. Click Next.
8. Click Save.
9. From the Fields Available for Reports section, click Edit Layout.
   
   
   
   
10. On the right portion of the screen, click the Add fields related via lookup hyperlink.
    
    
    
    
11. Click the Shipping Contact hyperlink.
    
    
    
    
12. Select the following fields to include on the report:
    1. Email
    2. Email Bounced Date
    3. Email Bounced Reason
    4. Full Name
    5. Is Email Bounced.
       
       
       
       
13. Click OK.
14. Click Save.
    
    Return to top
    
    
15. To create a report based upon the new Report Type, from Accounting Home, under Reporting, select Management Reports.
16. Click New Report.
    
    
    
    
17. In the Lookup search textbox, enter Billings with Bounced Emails, which is the name of the new Report Type that you created.
    
    
    
    
18. Select the Report Type and click Continue.
    
    
    
    
19. Click the right arrow to expand the Fields panel.
    
    
    
    The added fields display at the bottom of the Fields list.
    
    
    
    
20. In the Add Column search textbox, enter the name of each new column to add to the report.
    
    
    
    
21. Click All Billings and All Time.
    
    
    
    
22. Click Filters to add a new filter.
    
    
    
    
23. To view undelivered emails only, add a filter for Shipping Contact: Is Email Bounced and leave the default as True.
    
    
    
    
24. Click Apply.
    Note: Any emails that were undelivered (bounced) will display on the report with the Billing Number, Email address, Full Name, Email Bounced Date, and Email Bounced Reason.
    
25. To view the most recent undelivered emails, click Outline to group rows by Shipping Contact Email Bounced Date. Click the up arrow to change the sort order to Descending.
    Note: Group by Rows instead of Columns.
    
    
    
    
26. To save the new report, click Save or Save & Run.
27. Complete the Save Report dialog box, including selecting the folder where you want the report to display. Then, click Save again.
    Note: When you run the report, a Billing number hyperlink displays for each undelivered email, which you can click to review Billing Contact information and update, as necessary.
28. After the custom report has been configured in accordance with your needs, to make the Report Type available for other users, return to the Report Type and deploy it. Complete steps 1-4 above to access the new Report Type.
29. Click Edit.
    
    
    
    
30. Click the Deployed radio button.
    
    
    
    
31. Click Save. The new Report Type is now available for other users to run.

Return to top