Not sure if this is the same problem, but we have seen errors in the reconciliation when two transcations are identical on the same bank account eg Bank Charges on the same day (same date, amount, details etc). In these cases, one transaction appears, the other does not in the reconciliation. We are still looking at this amd will advise if we find a pattern etc (other than the obvious one)
Regards Jean-Pierre _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Jean-Pierre Guillou Director DCDM Management Services Ltd Tel PABX : (230) 202 3000 Tel Direct : (230) 202 3057 Fax : (230) 208 0086 eFax : (44) 7006 030 893 Web :www.dcdm-ms.com ******************************************************************** Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivering the message to the intended recipient), you should not read it, nor copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply E-mail. Opinions, conclusions and other information in this message that do not relate to the official business of any member firm of the DCDM Organisation shall be understood as neither given nor endorsed by the firm. On 24 July 2011 17:01, Rich Shepard <[email protected]> wrote: > On Sun, 24 Jul 2011, Rolf Stöckli wrote: > > Now it is maybe better you don't look too deep inside the database tables. >> Of course everything is in the database, but as Reed said correctly, the >> relation between the entries is made in the Perl scripts. You have no hint >> how for example acc_trans, ar, ap and invoice are related to each other if >> you only look at the database structure. >> > > Rolf, > > That's why I won't be looking. > > However, I will see if I can find where the account discrepancy originated > as time allows this week. > > Thanks, > > Rich > > ______________________________**_________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/**mailman/listinfo/sql-ledger<http://lists.ledger123.com/mailman/listinfo/sql-ledger> >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
