How to import into Bank Reconciliation Transaction Entry (BR_Transaction) using Visual Integrator for Sage 100

Description

How to import into Bank Reconciliation Transaction Entry (BR_Transaction) using Visual Integrator

Disclaimer

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions.

Resolution

Background:
Bank Reconciliation Check, Deposit and Adjustment Entry has two methods of data entry split into two separate tabs.
The first tab for checks, and the second tab for deposits or adjustments to the account.
The two imports share some key fields including BankCode and DocumentType, therefore it is necessary to import into either one or the other using separate or chained import jobs.
To import into BR_Transaction, Check Entry:

Design an import into BR_Transaction using the following fields in the order listed below:
- BankCode
- DocumentType (set to C for checks)
- CheckNo
- EntryNo
- CheckDate
- ReferenceNo
- CheckPayeeName
- CheckAmt
- ClearedBank
Note: Entry Number can be set as an incremental assign, making sure to note a default (starting) value in the import properties window for that field

To import into BR_Transaction Adjustment, Deposit Entry:

Design an import into BR_Transaction using the following fields in the order listed below:
- BankCode
- DocumentType (set to A for adjustments / deposits)
- TransactionDate
- EntryNo
- AdjustmentType
  - A = Adjustment
  - B = Bank Charge
  - D = Deposit
  - I = Interest
  - N = NSF
  - W = Withdrawal
- DocumentAmt
- ClearedBank
Note: Entry Number can be set as an incremental assign, making sure to note a default (starting) value in the import properties window for that field
Note: If importing the DocumentDate field; the DocumentDate and TransactionDate fields need to be the same dated column in order for the DocumentDate field to properly populate

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.