Creating an NSF import

  1. Select Billing > Payment > Create NSF Import.
  2. Specify the name of the file that contains the NSF information.
    When you click the popup button for the Import File field, Infor Public Sector shows the DirectorySearch dialog box. By default, this dialog box shows the directory specified in the File Path field. You can then select a file in this directory, or you can browse to a different directory.
  3. Select the template you're using from the Import Template list.
    The template is an XML file that indicates how data from the import file is mapped to the Infor Public Sector database. The data is identified based on a set of keywords that are first defined in the Keyword Manager. You can set a default template in NSF Import Setup.
  4. Select Use default return code for unmatched reversal reason codes found in file to use the default return reason code for any payments in the import file with codes that aren't found in Infor Public Sector.
    You can set a default code when you define return reason codes in Lookup Payment Reversal Reason. Each payment in the import file will have a code indicating the reason the payment was returned, which should match a return reason code in Infor Public Sector. If any of the return codes in the import file aren't found in Infor Public Sector, the default code can be used instead.
  5. Check Add unmatched return code in system with default reversal reason code values if you want to automatically add any return codes in the import file that aren't found in the database.
  6. Click Run Run button.
    Infor Public Sector imports the NSF information and attempts to match payments in the import file to payments in the database.

    See Matching NSF payments.

    The results of the import are displayed on three tabs. The Resolved tab shows payments that were successfully imported and reversed. The Unresolved tab shows payments that couldn't be reversed for some reason, such as an account number mismatch. The Exceptions tab, finally, shows payments that were imported with exceptions. You can use these tabs to review exceptions or unresolved payments, and to rerun unresolved payments once the problems have been addressed.