Apart rom that, i'd suggest to look into the fact that the diffference can be divides by 9. That often points to a typo, like 81 i.s.o. 18 or 72 i.s.o. 27
2010/6/4 Armaghan Saqib <[email protected]> > On Thu, Jun 3, 2010 at 2:02 PM, Rich Shepard <[email protected]> > wrote: > > This discrepancy has existing a long time and I'd like to resolve it ... > > if I can, that is. > > > > When I view Reports -> Trial Balance my checking account balance is > amount > > 'A'; when I click on that account number and look at the transactions in > > that > > account I see the current balance at the bottom is 'B'. Amount 'A' is > > exactly $18,000.00 greater than is amount 'B'. > > > > Ledger check shows no orphaned transactions or ledger entries. The > > checking account reconciles with the bank statements. What might cause > this > > discrepancy in displayed amounts? > > > > When I asked awhile ago about this the dollar difference between the two > > displays was much greater than it is now. But I could not find any > entries > > that would show a different total on the trial balance view than on the > > account transaction register view. All other accounts on the trial > balance > > agree with their individual account transaction registers. > > Hi Rich, try the following query: > > SELECT * FROM acc_trans WHERE trans_id IS NULL; > > and see if you get any rows. > > Regards > Armaghan > _______________________________________________ > 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
