Using Import to Create Payment Application Line Items

You can export a template that includes the detail form fields as columns for a specific business process (BP). These fields include the SOV data and the detail line item fields defined in Integration.

The Reference Number field exports as a column for Payment Application 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.

If the BP is designed with multiple tabs for line items, the tab columns are included in the export. The data on the Standard tab exports. The data on the other tabs does not export.

You can modify the exported template and import it to create line items for the BP. The exported template contains SOV record information.

Note:

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

The Payment Application of Summary Payment Application SOV type supports record, line item, and cost allocation creation through CSV and Excel integration.

If the line items exist in the Standard tab, you cannot import line items through CSV or Excel.

When you import Summary Payment line items for Payment Application BPs, the system uses the values that the user provided for auto-populate data elements (DEs) if the fields were editable. Otherwise, the system uses the values from Base Commit line items or Change Commit line items.

Export the Line Item Template

If the BP has multiple tabs for line items, only the data in the Standard tab exports. For the other tabs, the tab name is included in the exported data for reference, but no data from those tabs exports.

To export the template:

  1. Navigate to the Payment Application BP log.
  2. From the toolbar, select Create.
  3. Select a Reference Base Commit for the BP.

    If you do not select a Reference Base Commit, the exported template does not contain data. Data from all columns in the Reference Base Commit exports.

  4. From the More Actions menu, select Export Line Item Template, and then select CSV or Microsoft Excel.

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

Modify the Line Item Template

To modify the item template:

  1. Open the exported CSV or Excel file in Microsoft Excel.

    The SOV line items are listed.

  2. Enter the line item information in the spreadsheet.

    Each line 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 nonrequired 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 the imported values, except for fields auto-populated by Base Commit, Change Commit, or SOV.
  • When a DE is set to auto-populate from a Base Commit, Change Commit, or SOV, the auto-populated values take precedence when a zero value is sent for those DEs 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.
  • Any line items that you import replace the existing line items in the BP.
  • Use this process to add new lines only. Do not use it to modify existing lines.
  • 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 Line Item Template

Note:

The line items that you import replace any existing line items.

To import the template:

  1. Navigate to the Payment Application BP log, and select the applicable BP.
  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 error, and import the file again. If any row contains an import error, the system imports no records.

Import Line Items with Zero Amount

You can add line items with a zero value in the CSV or Excel template. After you import the template to the BP record, the BP record includes the added line items with a zero value.

Example

You import a CSV or Excel template that has the following three line items to your BP record:

1-Amount = 1000

2-Amount = 0

3-Amount = 0

After the import completes, all three line items are added to your BP record.