Versions Compared

Key

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

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue
  • Bank Reconciliation Manager auto-match processing is not matching AP or PR checks
  • BAI Import file Customer Reference includes leading zeros 


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext
  • Bank Reconciliation Manager
  • BAI Import


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

The Customer Reference Number does not match the Munis Reference Number (Check Number) due to leading zeroes. The number of leading zeros cause the Customer Reference to exceed current expectations for the zeros to be automatically stripped when imported.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution
  • MUN-408454 is currently open with Development to correct the auto match query so Customer Reference values with leading zeros will strip the zeros on import and checks will match and clear. based on the remaining field values.
  • In order for the Auto-Match process to be successful, the Customer Reference Number and the Munis Reference Number (Check Number) must match exactly. To resolve, the leading zeroes must be removed from the BAI file prior to importing.It is recommended to reach out to the Bank that is providing the file and have them update the file format. This will avoid manual manipulation of the files prior to importing. 
  • Currently, the work ticket MUN-298837 is set to allow for leading zeroes in the Auto-Match process. This work ticket is set to be released in a future version of Munis.


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