When doing bank reconciliation of bank accounts, accounts with Amountshowing 0.00 have values showing on the Amount (Foreign Currency) column greater than 0.00.

The cause of the discrepancy is thatAmount (Foreign Currency)in theBalance Sheetreport is translating the transactionAmountwith theExchange Rate. However, in the case ofAdvanced Intercompany Journal Entries, this type of transaction should be usingExchange Rate (Line).

1. Go toLists>Search>Saved Searches>New
2. ClickTransaction
3. Search Title:EnterTitle
   Example:Bank Account Reconciliation
4. ClickCriteria
5. ClickStandard
6. Filter:
   • SelectAccount
     1. Account:Selectis-any affected account-
     2. ClickSet
   • SelectSubsidiary
     1. Subsidiary:Selectis -affected subsidiary-
     2. ClickSet
   • SelectAccounting Period fields...
     1. Accounting Period Filter:SelectEnd Date
     2. End Date: Selecton or before-any date-
        Example:31/05/2022
     3. ClickSet
   • SelectPosting
     1. Posting:SelectYes
     2. ClickSet
7. ClickResults
   • Sort by:SelectExchange Rate (Line)
   • Descending:EnterCheckmark
   • Consolidated Exchange Rate: SelectNone
   • Show Totals:EnterCheckmark
8. ClickColumns
9. ClickRemove All
10. Field:
    Note:For every required field use the drop-down menu to select it and once adjusted click Add if needed.
    • SelectType
    • SelectDocument Number
    • SelectAmount
    • SelectAmount (Foreign Currency)
    • SelectExchange Rate
    • SelectFormula (Currency)
      • Formula:{fxamount}*{linefxrate}
        Note:This is the should be amount for Advanced Intercompany Journal Entry, since this is the only type of transaction that can have different exchange rates per line.OnlyAdvanced Intercompany Journal Entrieswill have values in this column.
    • SelectExchange Rate (Line)
      Note: Only Advanced Intercompany Journal Entries will have values in this column
    • SelectFormula (Currency)
      • Formula:case when {linefxrate} <> {exchangerate} then ({linefxrate}*{fxamount}) else ({fxamount}*{exchangerate}) end
      • Custom Label:CorrectAmount (Foreign Currency)
        Note: This is the correct translation of all transactions.This is your expectedAmount (Foreign Currency)amounts
11. ClickSave and Run