Aged Accounts Receivable Filters

supp85

Hello all,

When running the Aged acc receivables report applying a filter on Balance to show customers with <0 balances within a period altho the output of the report is mostly negative balances, it does show some customers with a positive balance and misses off some negitive balances.

Can anyone explain why this is?

DaveT

Hi,
I suspect that you are running the report for a day different than today. The filter will only apply to the current balance and not the balance as at the report date. To do this you will have to add some code.

supp85

Thank you for your reply, would i need to place the code within the Cust. Ledger Entry data item?

DaveT

Hi,

The easiest place to put the code is in the OnPreSection in the Section designer (i.e. Currreport.Showoutput) - but be careful of the totals.