Customer Payment Report with Amount Paid and Discount Taken

Post date: Apr 13, 2015 9:15:26 PM

A known challenge in NS is obtaining a customer payment report showing amount paid and discount taken. I was able to create this report with a transaction saved search and type equal to payment.

The trick I found is to use 'Applied to Link Amount' and 'Line Sequence Number'. I found that 'Line Sequence Number' is 1 when 'Applied to Link Amount' is equal to 'Amount Paid' and 2 when it's equal to 'Discount Taken'. Hence, using a formula field with SQL I was able to create separate columns for 'Amount Paid' and 'Discount Taken'.