Mistake Proofing

Let said you have lot of transactions, and you create Type 'R' transactions from time to time to ensure that your balance always correct. For example (Bank account, CDM=cash deposit machine),

Date    TxnType Description Amount  Balance (let said previous balance=10)
10Jan08 Normal  CDM         RM 150  RM 160
20Jan08 Recon   Statement   RM   0  RM 160 (User amt=Rm 160)
10Feb08 Normal  CDM         RM  80  RM 240
20Feb08 Normal  CDM         RM  80  RM 320
28Feb08 Recon   Statement   RM   0  RM 320 (User amt=Rm 320)
10Mar08 Normal  CDM         RM  80  RM 400

One day, you want to create a new transaction for 02Apr08, deposit at CDM, RM 400, the date, you suppose to enter is 20080402xxxxxx, but you accidentally entered as 20080204xxxxxx. Now the transaction listing like this:

Date    TxnType Description Amount  Balance (let said previous balance=10)
10Jan08 Normal  CDM         RM  150  RM 160
20Jan08 Recon   Statement   RM    0  RM 160 (User amt=Rm 160)
04Feb08 Normal  CDM         RM  400  RM 560 <- User wrongly enterred
10Feb08 Normal  CDM         RM   80  RM 640
20Feb08 Normal  CDM         RM   80  RM 720
28Feb08 Recon   Statement   RM -400  RM 320 (1) - readjusted
10Mar08 Normal  CDM         RM   80  RM 400

Above just a simple example, imaging there are a lot a lot more transactions in between each transactions above. Then, where is your newly created transaction? You hardly find it, so what you can do? Due to the wrongly created transaction, it is for sure, the type 'R' transaction after the newly created transaction will be adjusted accordingly. (Look at (1) transaction, the amount changed from RM 0 to RM -400, due to newly created transaction at 04Feb08, which is wrong). So what you can do now is, go to Menu->Reports->Recon Transaction With Non-Zero Adjustment Report, put in the account code, and leave the 2 date fields empty, and go! The report will listed all type 'R' transaction with value not equal to Zero. Thus the (1) transaction will be listed, and know you know the date of the type 'R' transaction, you can go back the transaction listing, find the type 'R' transaction, and the transaction that you wrongly created will be of course, listed before your type 'R' transaction.

After rectification, your account now look like below, which is correct!

Date    TxnType Description Amount  Balance (let said previous balance=10)
10Jan08 Normal  CDM         RM  150  RM 160
20Jan08 Recon   Statement   RM    0  RM 160 (User amt=Rm 160)
10Feb08 Normal  CDM         RM   80  RM 240
20Feb08 Normal  CDM         RM   80  RM 320
28Feb08 Recon   Statement   RM    0  RM 320 (User amt=Rm 320)
10Mar08 Normal  CDM         RM   80  RM 400
02Apr08 Normal  CDM         RM  400  RM 800 <- rectified

p/s: The other way to find the latest created transaction is to go to the View: Transaction List (All) by Transaction ID at Transactions Menu.