Working with Advanced Prepay Categories

You can copy and modify advanced categories. You can export the setup information for either the Active Table or All Tables for a specific What If scenario to a CSV or a Microsoft® Excel® file. You can also delete a category or scenario.

Use the category list to select a category to review or modify. Only one category can appear in the table at a time.

Any setup change to a category affects all accounts that are linked to it. If you delete a category, then the Prepayments setting for any affected accounts on the Chart of Accounts page is changed from Prepay Tables to None.

  1. Navigate to Setup > Prepay Tables > Advanced Tables.
  2. Select a What If scenario.
  3. Select a situation and follow the corresponding steps.
    Situation Steps
    Copy a Category
    1. Select the category that you want to copy from the category list.
    2. Select Copy..
    3. Enter a unique Table Name for the new category.
    4. Select Save.

    The new category becomes the active category. You can modify the new category as needed.

    Modify a Category
    1. Select the category that you want to modify from the category list.
    2. Change the Table Name of the category.
    3. Change the Time Periods fields.
    4. Select Save.
    Note: If you choose to show fewer time periods, prepayment speeds in periods that no longer appear are lost. When Annual is changed to Monthly, or vice versa, all prepayment speeds are cleared since they are no longer valid.
    Delete a Category or Scenario
    1. Select the category that you want to delete from the category list.
    2. Select Delete. for the category or scenario that you want to delete.
    3. Select Delete on the confirmation dialog box.

    You can only delete one item at a time. The system enforces the following restrictions:

    • You cannot delete the Flat Rate scenario.
    • If you try to delete a category that is assigned to an account on the Chart of Accounts page, then the application informs you but allows you to continue.
    Export Setup Information
    1. Select Export.
    2. Select what you want to export:
      • Active Table
      • All Tables
    3. Select the type of file that you want to export:
      • CSV
      • Excel
    4. Select Export.

    When you select one of these options, the system sends you a notification, and the exported file appears in the Reporting > View Reports grid.