As of version 15.1, additional reports were added in Accounts Payable Reports, Lien Waivers:

• LW Cond Final by Pmnt (CR) (report file name: Compliance - Lien Waiver Conditional Final by Payment (CR).rpt)
• LW Cond Partial by Pmnt (CR) (report file name: Compliance - Lien Waiver Conditional Partial by Payment (CR).rpt)
• LW Uncnd Final by Pmnt (CR) (report file name: Compliance - Lien Waiver Unconditional Final by Payment (CR).rpt)
• LW Uncnd Partial by Pmnt (CR) (report file name: Compliance - Lien Waiver Unconditional Partial by Payment (CR).rpt)

For versions 12.1, 13.1, and 14.1, you may use the following workaround:

Download the attached .zip file: Lien Waivers printed by Vendor\Job\CheckKB536317-not QA tested.zip.

These reports are provided as a possible solution to your issue. They were not reviewed by Quality Assurance. You may need to modify them to meet your reporting needs or adapt them for use with future releases of the software.

Note: Due to the database structure, these are Crystal reports.

What has been modified in each report:

1. Created a formula named @GroupbyVendorJobCheck. The contents of this formula is:{JCM_MASTER__LIEN_WAIVER.Primary_Vendor}+{JCM_MASTER__LIEN_WAIVER.Job}+StringVar text := Totext({JCM_MASTER__LIEN_WAIVER.Payment_ID},0,"")
2. Changed the grouping from JCM_MASTER__Lien_Waiver.Lien_Waiver_ID to new formula @GroupVendorJobCheck.
3. Created a formula, @SumWaiverAmtByGroup, to sum the group. The contents of this formula is: Sum ({JCM_MASTER__LIEN_WAIVER.Lien_Waiver_Amount},{@GroupByVendorJobCheck}).
4. Changed the formula @Lien Waiver Amount to Words to:
   // First Letter Cap
   Local StringVar WaiverAmount := ToWords({@SumWaiverAmtByGroup });
   UpperCase(WaiverAmount[1]) + Mid(WaiverAmount,2);
5. Removed JCM_MASTER__LIEN_WAIVER.Lien_Waiver_Amount from report design and replaced it with the newly created @SumWaiverAmtByGroup.
6. Formatted the new field, SumWaiverAmtByGroup .
7. • Bold
   • Show currency symbol
   • Changed size and position to reflect the same location as the previous field.
     X: 6.020
     Y: 3.580
     Width: 0.940
     Height: 0.160