How to Import Transactions into Sage MAS 90 MAS 200 Bank Reconciliation

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