Using Import to Create Payment Application Records

You can export a CSV or Microsoft Excel template that includes the upper form and detail form fields as columns. The template includes the header fields from the upper form and the line item SOV fields from the detail form, including the detail line item fields defined in Integration.

The Reference Number field exports as a column for Payment Application business processes (BPs) that use individual line items. The Reference Number field does not export as a column for Payment Application BPs that use Group by CBS.

You can modify the exported CSV or Excel template and import it to create the upper form header and the detail form line items for a new BP.

Note:

The system supports import of Payment Application records and line items through CSV, Excel, and REST APIs.

Export the Template

To export a copy of the Payment Application BP template:

  1. Navigate to the Payment Application BP log.
  2. From the toolbar, select Actions, and then select Export to CSV Template or Export to Microsoft Excel Template.

Depending on your browser, the template downloads automatically, or you are prompted to download it manually.

Modify the Template

To modify the template:

  1. Open the exported CSV file or Excel file in Microsoft Excel.
  2. Enter the BP information into the spreadsheet.

    Each upper form header record must begin with H. Each line item must begin with D. For multiple tabs, enter the appropriate tab name in the Tab Name column.

  3. Enter data in the required fields and any non-required fields as needed.

Important Information

  • Data for formula-based columns is ignored.
  • If you provide auto-populated data, the system imports the value and does not override it, except for fields auto-populated by Base Commit, Change Commit, or SOV.
  • If a data element (DE) is set to auto-populate from a Base Commit, Change Commit, or SOV, the auto-populated value takes precedence when a zero value is sent for that DE in CSV, Excel, or the REST API. Any value specified in the input request is ignored.
  • Any line items with an amount of zero are not imported.
  • SOV locking is enforced.
  • Use this process to add new BP records only. Do not use it to modify existing BPs.
  • For data to import correctly, you might need to change some cells in the CSV file to text type. For example, if you have a CBS code of 1-1, Microsoft Excel can interpret the entry as a month-day combination and reformat it to Jan-1. In this case, the data import fails because the CBS code is invalid.
  • If the Integration design for the BP includes a Description field for line items, and the associated SOV sheet also contains a Description field, the description from the SOV sheet is imported and the line item description is not imported.

Import the Payment Application BP Template

To import the template:

  1. Navigate to the Payment Application BP log.
  2. From the toolbar, select Actions, select Import, and then select From CSV Template or From Microsoft Excel Template.
  3. Browse to select the file to import, and then select Next.
  4. Add any attachments to the import.
  5. Select Upload when you finish.

    If any import errors occur, open the CSV or Excel file, correct the errors, and import the file again. If any row contains an import error, the system imports no records.