Setup to schedule import of BAI file

Owned by Knowledge Assistant
Last updated: Feb 21, 2024
Description of Issue

How to setup the system to schedule the import of the BAI file in BAI Import?

Context
  • BAI Import
  • Bank Reconciliation Settings
Cause

Specific setup required to schedule BAI import

Resolution
  1. Create two unique directories (one for the Import file and one for Archive files) on the Munis ERP Application server
    1. OnPrem clients:
      1. On the EERP server, navigate to <MUNDRV>\musys
      2. Create two new folders and name as desired. If thee are questions or issues regarding this process, please reach out to our TSM team for clarification/assistance. 
        1. Ex: <MUNDRV>\musys\BAI_Import and <MUNDRV>\musys\BAI_Archive
      3. Place a copy of the BAI file in <MUNDRV>\musys\BAI_Import
        1. NOTE: Only one import file should exist in the import directory at a time
    2. SaaS clients:
      1. Contact TSM SaaS Support to have the directories created and to assist with placing a copy of the Import file in the appropriate location
      2. Files can be sent from the bank to the server using FTP with the assistance of TSM SaaS
    3. In either instance, the directories should only begin receiving files after the scheduled job has been created to process these imports. Inclusion of more than one file in the directory will result in a failed import.

Once the directories above have been created, follow the steps below. Note that enabling the Move bank file on import option will require that all imports are processed via the scheduled job. If you have a backlog of files that need to be manually imported, process those imports prior to having the Bank Reconciliation Settings updated.

  1. Enable Move BAI file on Import in Bank Reconciliation Settings (Requires assistance from a Tyler employee such as your Implementation Consultant, Project Manager, or Munis Financial Support)

    1. From the Munis ERP menu, navigate to Financials > Cash Management > Bank Reconciliation > Bank Reconciliation Settings

      1. Click Update
      2. You will need a Tyler Employee to enter the password for Munis Employee Password
        1. Please contact your Implementation Consultant, Project Manager, or Munis Financial Support for assistance
      3. Click OK
      4. Check Move bank file on import
      5. Click Accept
  2. From the Munis ERP menu, navigate to Financials > Cash Management > Bank Reconciliation > BAI Import
    1. Click Define
    2. Change Schedule Import to At a scheduled time
    3. Enter Import Path and Archive Path (from the server steps above)
    4. Select options below (if applicable):
      1. Import ZBA transactions
      2. Create ZBA transfer journals
      3. Match checks during import
      4. Match deposits during import
    5. Click Accept
  3. Munis Scheduler screen should open. Update Description if necessary.
    1. Recur
    2. Populate recurrence settings (run Daily, weekly, monthly etc.)
    3. Ok
    4. If necessary, select Notify to change users that are notified when job is started, completed, and/or expires
    5. If necessary, select Output to change where the BAI Import report is printed or saved
    6. Ok
    7. Ok (to confirm the setup of the job - this will provide the job number)
  4. To confirm the job is scheduled to run, navigate to System Administration > Scheduler Administration > Scheduler Queue 
    1. Look for the job number listed on the Queue tab

Once the job has been scheduled, it's important that exactly 1 file exists in the import directory prior to the first scheduled run. If there are no files, or more than 1, the job will fail.

Additional Information