Filtering zero Balances in Aged Accounts Receivables Report

Fariraishe_ShumbaFariraishe_Shumba Member Posts: 44
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 Member Posts: 9,255
    on customer tab. select field balance and filter enter 0
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Fariraishe_ShumbaFariraishe_Shumba Member Posts: 44
    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 Member Posts: 9,255
    Are you running aging as of today? The balance due column should be the same, other columns will differ.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Fariraishe_ShumbaFariraishe_Shumba Member Posts: 44
    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 Member Posts: 9,255
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Fariraishe_ShumbaFariraishe_Shumba Member Posts: 44
    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 Member Posts: 9,255
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Fariraishe_ShumbaFariraishe_Shumba Member Posts: 44
    ok let me try that
  • Fariraishe_ShumbaFariraishe_Shumba Member Posts: 44
    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 Member Posts: 9,255
    which version are you working on.

    The report has changed several times.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Fariraishe_ShumbaFariraishe_Shumba Member Posts: 44
    I m working in Classic 2009 R2
  • ara3nara3n Member Posts: 9,255
    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?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.