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.