---
title: "How Do I add Sales Invoices as attachments to my Collection Letter email?"
slug: "how-do-i-add-sales-invoices-as-attachments-to-my-collection-letter-email"
updated: 2026-10-29T13:44:02Z
published: 2026-10-29T13:44:02Z
canonical: "kb.lasernetgroup.com/how-do-i-add-sales-invoices-as-attachments-to-my-collection-letter-email"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.lasernetgroup.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How Do I add Sales Invoices as attachments to my Collection Letter email?

End result: An email to the customer with the collection letter, the invoices mentioned in the collection letter should be attached in the email.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-9NSV6314.png)

In our collection letter it mentions 2 sales invoices - we want to ensure that they are the ones added to the email as attachments

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-ZJD2H4SB.png)

We will be picking the invoices up from Lasernet log, so ensure that archive is added on the sales invoice report.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-5OVNQQMB.png)

## **Add CustInvoiceJour Table to CustCollectionJour Query Wizard**

The reference table in which the archived invoices files are stored must be added to the **CustCollectionJour** report.

From the ribbon, click **Query wizard** and add the **CustInvoiceJour** table to **CustCollectionJourTmp**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-4TG2JF7M.png)

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-J9NGBMYF.png)

I like to add the invoiceId as well for xml visibility - but its not required for adding the invoices as attachements

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-0FFIVM13.png)

Click **Finish**

## **Attach the Sales Invoice to the Collection Letter**

1. Navigate to **Lasernet** > **Reports**, find the **Collection letter**, and click **Attachments**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-FS3D55WV.png)

1. Click **New** to create a new line.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-NABNT4BX.png)
2. Add the **Attachment reference table** (in this case, the **CustInvoiceJour** table) and setup as below:

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-7NH8Q8IB.png)

The sales invoices archived will now be attached to your **CustCollectionLetter** emails as follows:

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-3WV2QF01.png)

## Related

- [How Do I Add Sales Invoices to CustCollectionLetter Using Document Handling?](/add-salesinvoices-to-custcollectionletter-document-handling.md)