|
Type: Informational
Product:
Sage MAS 90 ERP
Sage MAS 200 ERP
Sage MAS 200 ERP - SQL Server Edition
Application: Visual Integrator
Version Reported: 4.10 and later
Note: These procedures require proficiency with Visual Integrator. Please contact us for assitance with the creation or modification of Visual Integrator import jobs.
The Bank Reconciliation 'Check, Deposit and Adjustment Entry' function has two methods for 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
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
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.
Resolution ID: 495577 |
Online Support Center 
