Filtering zero Balances in Aged Accounts Receivables Report

Fariraishe_Shumba · 2012-03-20

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 · 2012-03-20

on customer tab. select field balance and filter enter 0

Fariraishe_Shumba · 2012-03-21

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 · 2012-03-21

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

Fariraishe_Shumba · 2012-03-21

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 · 2012-03-21

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 · 2012-04-02

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 · 2012-04-02

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 · 2012-04-02

ok let me try that

Fariraishe_Shumba · 2012-04-02

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 · 2012-04-02

which version are you working on.

The report has changed several times.

Fariraishe_Shumba · 2012-04-03

I m working in Classic 2009 R2

ara3n · 2012-04-03

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?

Filtering zero Balances in Aged Accounts Receivables Report

Comments

Categories