Versions Compared

Key

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

NR Automated EFT Transfers:
Automated EFT transfers will be reflected in NR system by scheduling the process using iProcess. iProcess will be installed along with Notes Receivable application.
For scheduling the process one time setup needs to be done in iProcess application.

  1. Double click on the iProcess icon on the desktop.

Image Added

  1. iProcess application will be opened

Image Added

  1. In the Left side tree menu, expand "Object Setup"  "Database Servers"  "Add New". Double click on "Add New"

Image Added

  1. Data Servers screen will open. Here we need to fill in the Database server details in which Notes Receivable database is present.

Image Added

  1. Fill in the required details

Image Added

  1. To set the Database setup, navigate to "Database Connector" Add New. Double click on "Add New" menu.

Image Added

  1. Database connector screen will be opened.

Image Added

  1. Fill in the required Database details and click on "Save" button on the top left corner.

Image Added

  1. Close the Database Connector form and open again. Now click on "Test" button on the top left section.

Image Added

  1. On the "Database Connection" screen click on the "Execute" button on the top left corner.

Image Added

  1. On execution, date should be displayed in the grid below the SQL Statement.

Image Added

  1. If there is any issue with the connection, date will not be displayed. Instead an error message with the cause of error will appear.
  2. To setup the Schedule, navigate to Schedule Setup  Add New. Double click on the "Add New" button.

Image Added

  1. Schedule form will open up.

Image Added

  1. Fill in the required information and click on the "Save" button. Schedule will be created which can be used in further steps.

Image Added

  1. To create a process which will execute the EFT Transfers process automatically, navigate to Process Setup  Add New. Double click on "Add New".

Image Added

  1. Process setup page will open up.

Image Added

  1. Fill in the Process title and description and select schedule created earlier. Click on Save button.

Image Added

  1. Once the process is saved successfully, Process Workflow area will be displayed with the record save message.

Image Added

  1. In the Process Workflow area double click on the Add New link.

Image Added

  1. Process Step Definition form will open.

Image Added

  1. Fill in the Step Title. Step Description will be filled automatically same as Step Title. You can change the description as per your requirement. Also Action list will be enabled.

Image Added

  1. From the list select "Execute External Program" record and click on "Configure/Edit Selected Action" button.

Image Added

  1. Execute External Program form will open.

Image Added

  1. Click on the Open Folder button besides Program Directory text area in Action Parameter section.

Image Added

  1. Browse to the Notes Receivable – Server folder from "C:\Program Files (x86)\iRely" and click "OK" button

Image Added

  1. Respective path will be loaded in Program Directory text area. Next click on the Program Name button highlighted in the below image.

Image Added

  1. "Select File" dialog will be opened for the program directory. Select the AutoNRSchedule application from the files as highlighted in below image.

Image Added

  1. Click on "Save" button.

Image Added

  1. We are now all set for the Automatic execution of Automatic Notes Receivable EFT process.


EFT Process

  1. EFT process will process all the notes which are of scheduled invoice type.
  2. This process will be executed daily in the midnight based on the schedule setup.
  3. For each note, expected payment date, Number of Days prior note be generated and other late fee details will be retrieved.
  4. If the current date is equal to the note generation date,
    1. Schedule invoice will be upd
      Anchor
      _GoBack
      _GoBack
      ated as generated which will be reflected in the schedule history of the note.
    2. GL notes receivable account will be credited by Principal portion of invoice
    3. Interest Income account will be credited by Interest portion of invoice.
    4. Scheduled Invoice GL Account will be debited by total of Principal and Interest portion.
  5. If current date is equal to the expected payment date EFT payment transaction will be initiated,
    1. Payment transaction entry will be done automatically on the note for the amount of scheduled invoice.
    2. Cash account will be debited for the total of Principal and Interest.
    3. Scheduled Invoice GL account will be credited for the total of Principal and Interest.
    4. Scheduled Invoice will be updated as paid which will be reflected in the scheduled history of the note.
  6. If payment is pending and passed over grace period, late fee will be processed,
    1. Late fee will be calculated based on the late fee settings of the note.
    2. Scheduled Invoice Late fee account will be credited for late fee amount
    3. Scheduled Invoice GL account will be debited for late fee amount
    4. This will just apply late fees to the scheduled invoice. Payment of late fees should be done manually using Receive Payment screen.