How to exclude Prepayment Type in Customer Statement (AR641500) ?

@manikantad18 and @dilys ,

I have the same issue that @dilys was having, and in addition to filtering out Prepayments I also want to filter out Voided Payments.  I see from the above Prepayments are ‘PPM’ and I’ve queried the table and the Voided payments are ‘RPM’.

My setup for the statement report is the same as @manikantad18 has displayed and the Prepayments are still not being excluded from the report. 

Here is a screen shot of how I have set it up:

I initially had a parameter set up exactly as @dilys, but removed it once I saw the solution @manikantad18 offered.

Any thoughts on why my report isn’t filtering with this same solution? Below is a screen shot of the Table Relationships for the ARStatementDetailInfo table in the Build Schema. Perhaps something there is amiss?

One final thing - here is the code for that field on the report:

Any help would be appreciated.

Patrick

Awesome! Thank you for sharing your solution with the community @patrickACA !

I am having this same issue - there is no variable that contains only prepayment amounts, and the totals along the bottom are populated by AgeBalance00, AgeBalance01, etc fields on the DAC. There’s no corresponding prepaymentn DAC field.

Currently I’m trying to extend the DAC and calculate the prepayments by attaching to the processing function for the customer statement screen. I’ll try to update here how that goes.