Filtering zero Balances in Aged Accounts Receivables Report

Fariraishe_ShumbaFariraishe_Shumba Posts: 44Member
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

Comments

  • ara3nara3n Posts: 9,141Member
    on customer tab. select field balance and filter enter 0
  • Fariraishe_ShumbaFariraishe_Shumba Posts: 44Member
    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?
  • ara3nara3n Posts: 9,141Member
    Are you running aging as of today? The balance due column should be the same, other columns will differ.
  • Fariraishe_ShumbaFariraishe_Shumba Posts: 44Member
    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
  • ara3nara3n Posts: 9,141Member
    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_ShumbaFariraishe_Shumba Posts: 44Member
    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?
  • ara3nara3n Posts: 9,141Member
    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_ShumbaFariraishe_Shumba Posts: 44Member
    ok let me try that
  • Fariraishe_ShumbaFariraishe_Shumba Posts: 44Member
    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
  • ara3nara3n Posts: 9,141Member
    which version are you working on.

    The report has changed several times.
  • Fariraishe_ShumbaFariraishe_Shumba Posts: 44Member
    I m working in Classic 2009 R2
  • ara3nara3n Posts: 9,141Member
    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?
Sign In or Register to comment.