Filtering zero Balances in Aged Accounts Receivables Report

Fariraishe_Shumba

Hie Guys

How do I filter Zero balances so that they don't appear on the Aged Accounts Receivables Report?
Can someone help me.

Regards

ara3n

on customer tab. select field balance and filter enter 0

Fariraishe_Shumba

Thats working but then I find out that the Total is different if i filter using that method from the total before i filter.isn't it that these totals must be the same?

ara3n

Are you running aging as of today? The balance due column should be the same, other columns will differ.

Fariraishe_Shumba

If I run as of today The Total(LCY) is the same whether or not I filtered zero balances but if i run as of 31-12-11 then comes the difference

ara3n

The point of Aging is to run as a certain date. When you filter on customer balance = 0 you are filtering balances as of today.

Fariraishe_Shumba

What I want is to filter out the balances which are zeros as at (Aged as of) given date,does the balance column on the report indicate the customer balance?

ara3n

You have to make a modification. Add an boolean field on the option tab. So that the user can checks the field.

In Code check the array and see if all the values are zero for the 4 columns and if they are do not print the section.

Fariraishe_Shumba

ok let me try that

Fariraishe_Shumba

Hi,
I have been able to add a boolean and a checkbox to my request form but,
I m failing to lacate where exactly in the code to put my code, should it be in one of the functions InsertTemp or UpdateCurrencyTotals and also the variable that prints the balance to the temp table

ara3n

which version are you working on.

The report has changed several times.

Fariraishe_Shumba

I m working in Classic 2009 R2

ara3n

Standard NAV will not print the customer if you have applied all the invoices to payments and they have zero balance.
Is there a reason why you are not applying customer ledger entries to each other?