Rich, Nice to know you found the reason why the report is off. However, this is where one of my previous questions might become a major item. The debit side as we now know was an orphaned A/R entry.
Normally, the credit belonging to that orphaned A/R entry would end up somewhere in sales (hardware and such) or turnover (billed hours). Since I did not hear you mention the balance totals being wrong, it just MIGHT be that somewhere along the line you overstated the billed hours. Thereby overstating the turnover and year result as well. All not nice, but the worst is yet to come: if you did, you paid too much taxes as well. Now how to get that back from the Tax Collector... (whistling Beatles "Tax Man" as hint) Cheers, Paul 2010/6/7 Rich Shepard <[email protected]> > On Thu, 3 Jun 2010, Rich Shepard wrote: > > This discrepancy has existing a long time and I'd like to resolve it ... >> if I can, that is. >> > > Armaghan found the problem rows in the ar table. When I was struggling to > learn how to handle a retainer project (paid in advance, and bill off that > amount, send statement to client each month) I inadvertently left orphaned > ar transactions with no client ID. > > Rich > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
