GENAJ USD Purchase missing from Bank Reconciliation to mark?

Question

Hello, 
 Our bank 3 which we use for USD has a wildly inaccurate balance. We've noticed that several GENAJ journal entries showing withdrawal from bank 1 (CAD) and deposit into bank 3 (USD) is missing a mark number on the bank 3 line, and when we try to search for it in bank reconciliation to mark and reconcile it, it does not exist in the lines to be marked. 
 Here is a screenshot of the GENAJ journal entry lines, showing the two movements, where account 10100 (BANK 1) has a mark number and account 10120 (BANK 3) does not 
 
 Here is a screenshot of the 10100 line in a bank reconciliation statement 
 
 However, upon opening BANK 3 for reconciliation, the matching entry from the first screenshot does not exist. In fact, none of the missing entries with "USD purchase" type are showing. 
 
 Any help would be appreciated, thank you 
 Zoey

Tracy B. · Accepted Answer

Good morning, Zoey. 
 Verify that the entries have not been reconciled with other Bank Reconciliation (BANREC) statement or another Bank 
 Verify that the entries are posted for both banks/currencies by looking at the Account or Account Balance inquiry 
 It is possible the payment maybe assigned to another bank, so it does not show in the Grid. 
 -Tracy

Sage X3

GENAJ USD Purchase missing from Bank Reconciliation to mark?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING