Aged Accounts Receivable Filters

supp85 · 2009-03-03

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 · 2009-03-03

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 · 2009-03-03

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

DaveT · 2009-03-03

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.

Aged Accounts Receivable Filters

Comments

Categories