Location
Tools >> Setup >> Financial >> Advanced Bank Reconciliation >> BAI Format Options
Layout
Overview
The BAI Format Options window is used to define additional parameters for use when importing BAI files. Some of these parameters are also used for .CSV import files as indicated below.
Fields
Import Check Number From – Specifies where the check number is located in the BAI file (See appendix for more information). Options are:
- Bank Reference
- Customer Reference
- Text Reference
Note: When Text Reference is selected, the Check Number Start Position and Check Number Length fields are enabled. These fields are used to define the position of the Check Number within the Text Reference string in the BAI file.
Store Number Processing – Enables the ability to extract store number information from the BAI file. (see details below under Store Number Translation)
Bank Account Import Filter – Enables the ability to extract specific bank account information from the BAI and CSV import files. This functionality is useful when a single file from the bank contains data for multiple companies. (see Bank Account Import Filter for more details)
Specific BAI Options – Trx 455 Reference Update – When this is selected, different reference information will come in by all transactions with the Type of 455.
Store Number Translation
When Store Number Processing is enabled, this window is used to define relationships between an ID Number (found in the BAI file) and a Store Number from Dynamics GP.
Fields
ID Number – The ID Number found in the BAI file. During the Bank Statement Import process, if the characters “ID:” are found in the reference field of the BAI file, then the ID number is extracted as all of the numeric characters that follow “ID:” The ID number is then compared to the values setup in this window, and if it exists, the corresponding Store Number is inserted into the bank statement transaction Reference field.
Store Number – The Store Number that is used in the Reconcile window. This is determined by the last 5 characters of the account number in the GL transaction being extracted, and is appended to the front of the Reference field when processed by the GL Extract routine.
Bank Account Import Filter
When Bank Account Import Filter is enabled this window is used to define specific Bank Account Numbers and
Routing Numbers for the specific company’s bank statement imports. This is defined for each Company database.
Fields
Bank Account Number – A bank account number imported from the Customer Account Number field in a BAI or CSV file. Routing Number – The routing number imported from the Originator ID field in the BAI or CSV file.
Button
Default – Clicking this button will populate the grid with the Bank Account Number(s) and Routing Number(s) associated to the Bank ID’s currently setup in this GP company.
