Information Systems:Missing cash book transactions after manual G/L entry

Accounting will sometimes report that after a manual G/L entry (i.e. entering in a GLC for the occasional purchase of funds to load the US bank account), the cashbook is missing some of the correlating transactions. So far, the past few reported instances have involved transactions missing on the Canadian side of a transaction involving US currency i.e. there is a cash book transaction in the US bank for the amount in USD, but not the Canadian one.

When this occurs, entries are indeed missing in the cashbook table, SROCBA, while the GL will be fine. The best solution is to have Accounting reverse their transaction and try again. This is a base ASW process, so the root cause is likely a system glitch, which simply means the entry has to be re-tried. In one instance, the process of trying to make a corrective entry (reversal) fixed the issue before they were even able to go through and complete the reversal i.e. Nancy signed on as FINADMIN and was playing around with creating another entry but did not complete it. She then noticed that the missing transaction was now visible, and the table confirmed a record registered by FINADMIN.