Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution
  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
  2. the Munis ERP Application
      1. the EERP server, navigate to <MUNDRV>\musys
      2. Create two new folders and name as
  3. desired 
      1. 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
      2. 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
    1. 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
    2. 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.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information

When this job has been scheduled, the scheduler should be disabled in non production environments. In instances where the scheduler is running in non prods, a refresh will copy the scheduler information over and can result in a non prod importing and archiving the file which causes the live import to fail.

If scheduler shows any status other than than Online, contact TSM Support (On-Prem clients) or TSM SaaS Support (Hosted clients) for further assistance.

See also: BAI Import Scheduled Job Fail Error Message - Client File does not exist

Schedule Import option not available in the BAI Import program