I had a case a couple of weeks back, where the customer wanted to filter the transactions shown on a Receivables Management Statement. There was one type of transaction that they did not want included on the statements sent out to the customers. The transactions to be excluded could be identified by a particular value on the Description field on the transaction. The partner had already modified the report to add a Restriction onto Report Definition window to exclude the transactions based on the Description, for example: RM_Statements_TRX_TEMP.Description ” ” This worked fine to exclude the transactions, but left the report with one problem…. The totals in the aging buckets still included the now excluded transactions
Read more:
How to calculate Aging Buckets based on documents shown on a Receivables Statement