Menu

#54 Zero Rows problem

Next_Release
open
Reports (29)
9
2006-05-02
2004-07-30
JT Moree
No

When running multiple years on the cash flow report
certain Account rows are missing even though the total
includes the numbers. For example, running a 5, 6 year
report has account 10020 missing in the years where
there should be activity but the activity does show in
the total. In other words. if you add up the rows
that should be in the total, they dont match. Run
report for 1999 thru 2004 by year to recreate. ledger
code 32.

Other accounts having similar problems: 10065.

It seems like these rows both net to zero when going
across columns but that should not stop them from
showing up. Are you checking the total column for 0
values and using that to not display rows.

Discussion

  • JT Moree

    JT Moree - 2005-09-20

    Logged In: YES
    user_id=236631

    What did we decide on this? we talked a little but I see no
    response here. please respond

     
  • JT Moree

    JT Moree - 2006-05-02

    Logged In: YES
    user_id=236631

    Changed summary from Missing Rows on Cash Flow Report to
    Zero rows problem because I think this same code is causing
    another problem. On the activity reports, rows of type
    beginning or ending balance with zero totals show up even
    with display zero rows turned off. To be fair this might
    have started when I tried to make changes to fix this bug.
    I was unsuccessul and would need to revert back to the older
    code to test if this bug was introduced. I'd prefer that we
    just fix the code to eliminate all problems.

     
  • JT Moree

    JT Moree - 2006-05-02
    • summary: Missing Rows on Cash Flow Report --> Zero Rows problem
     
  • JT Moree

    JT Moree - 2006-05-02

    Logged In: YES
    user_id=236631

    the balance types on the activity reports seem to be
    selecting rows of 0 instead of only selecting activity.
    when this happens the zero rows code sees activity and so it
    displays the row. There are now two issues to be resolved.
    balance rows are selecting too much data and zero total
    rows are not looking for activity within the columns.

     

Log in to post a comment.

MongoDB Logo MongoDB