Import Payment Application Line Items into a BP

You can export a template that includes the detail form fields as columns for a specific business process. These fields include the SOV data and detail line item fields defined in Integration. The Reference Number field is exported as a column for payment application business processes that use individual line items. The Reference number field is not exported as a column for payment application business processes that use Group by CBS. If multiple tabs are designed for the line items in the business process, the tab columns are included in the export. All the data on the Standard tab is exported; no data on the other tabs is exported.

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

Note: The system lets you import Payment Application records and line items by way of CSV and REST.

The Payment Application of Summary Payment Application SOV type supports Record, Line Item, and Cost Allocation creation through CSV integration.

If the payment line items have already been added in the Standard tab, importing of the line items through CSV is not permitted.

When importing Summary Payment line items for Payment Applications BPs, the system uses the values that the user provided for the auto-populate data elements, if the fields were editable originally; otherwise, the system uses the values that are from Base Commit line items or Change Commit line items.

To export the payment application line item template

If multiple tabs are designed for the line items in the business process, only the data in the Standard tab is exported. For the other tabs, the tab name is included in the exported data for reference, but no data in these tabs is exported.

Navigate to the payment application business process log.
Click Create to create a business process.
Select a Reference Base Commit for the business process. If you do not select a Reference Base Commit, the exported template will not contain data. Data from all columns in the Reference Base Commit is exported.
Open the Menu Options (  ) and hover over Export Line Item Template, then select CSV or Microsoft Excel.

Depending on your browser, the file will be downloaded automatically, or you will be prompted to download the file manually.

To modify the payment application line item template

Open the exported CSV or Excel file in Microsoft Excel. The SOV line items are listed.
Enter the line item information into the spreadsheet. Each line must begin with a "D". For multiple tabs, you must enter appropriate tab name in the Tab Name column.
Enter data into the required fields, as well as non-required fields as needed.

Important information:

Data for formula-based columns is ignored.
If auto-populated data is provided, then the system will import the value, and will not override the imported values except for fields auto-populated by Base Commit, Change Commit, or from SOV.
Any line items with the Amount equal to zero will not be imported.
SOV locking is enforced
Any line items that you import will replace the existing line items in the business process.
Use to add new lines only, not to modify existing lines
For data to import correctly, you might have to change some of the cells in the CSV file to Text type. For example, if you have a CBS code of 1-1, then Microsoft Excel can interpret this entry as a month-day combination and reformat it to Jan-1. In this case, your data import will fail because this data is now an invalid CBS code.
If the Integration design for the business process includes a Description field for line items, and the associated SOV sheet also contains a Description field, then the description from the SOV sheet is imported, and the line item description is not imported.

To import the payment application line item template

Note: The line items that you import will replace any existing line items.

Navigate to the Payment Application business process log.
Select a business process from the log.
Click the Actions menu and hover over Import.
Select either Data From CSV File or Data From Microsoft Excel File.
Browse to select the file to import, then click Next.
Add any attachments to the import.
Click Upload when finished.
If there are any import errors, you can open the CSV or Excel file to view and correct the error. No records are imported if any rows contain an import error.

You can add line items with 0 (zero) value in the CSV or Excel template. In such scenario, after you import your CSV or Excel template to the BP record, the BP record will have your added line items with 0 (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 is complete, all three line items will be added to your BP record.

Last Published Sunday, July 20, 2025