Display Sum of Two Custom Columns in Invoice Using Basic PDF Layout

There are instances when the sum of two Custom Columns needs to be printed on an Invoice using Basic Transaction PDF Layout. This article shows how to achieve this using a Saved Search and Transaction Body Field. In this scenario, the two columns are named Commission Amount and Net Amount.

1. Create a Saved Search
2. Navigate to Lists > Search > Saved Searches > New
3. Click Transaction
4. Search Title: Enter Total Commission Amount Search
5. Click Criteria 
6. Click Standard 
7. Filter:
8. Note: Always click Set and Add once Field is selected and adjusted as needed.

• Select Type
• Type: Select Invoice

1. Click Results 
2. Click Columns 
3. Field:
4. Note: Always click Add once Field is selected and adjusted as needed.

• Select Commission Amount
• Summary Type: Select Sum

1. Click Available Filters 
2. Click Filter 
3. Filter:

• Select Internal ID
• Click Add

1. Click Save
2.  
3. Create another Saved Search
4. Navigate to Lists > Search > Saved Searches > New
5. Click Transaction
6. Search Title: Enter Total Net Amount Search
7. Click Criteria 
8. Click Standard 
9. Filter:
10. Note: Always click Set and Add once Field is selected and adjusted as needed.

• Select Type
• Type: Select Invoice

1. Click Results 
2. Click Columns 
3. Field:
4. Note: Always click Add once Field is selected and adjusted as needed.

• Select Net Amount
• Summary Type: Select Sum

1. Click Available Filters 
2. Click Filter 
3. Filter:

• Select Internal ID
• Click Add

1. Click Save
2.  
3. Create a Custom Transaction Body Field 
4. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
5. Label: Enter Total Commission Amount
6. Type: Select Currency
7. Store Value: Remove Checkmark
8. Click Applies To

• Sales: Enter Checkmark

1. Click Validation & Defaulting

• Search: Select Total Commission Amount Search

1. Click Save
2.  
3. Create another Custom Transaction Body Field
4. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
5. Label: Enter Total Net Amount
6. Type: Select Currency
7. Store Value: Remove Checkmark
8. Click Applies To 

• Sale: Enter Checkmark

1. Click Validation & Defaulting 

• Search: Select Total Net Amount Search

1. Click Save
2.  
3. Edit the Transaction Form PDF Layout
4. Navigate to Customization > Forms > Transaction Form PDF Layout
5. Preferred Invoice PDF Layout: Click Edit
6. Click Add Custom Element
7. Choose Element(s): Select Total Commission Amount
8. Click OK
9. Click Add Custom Element
10. Choose Element(s): Select Total Net Amount
11. Click OK
12. Click Save