You can export a CSV template that includes the upper form and detail form fields as columns. These fields include 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 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.
You can then modify the exported CSV template and import it to create the upper form header and the detail form line items for the new business process.
Note: Unifier allows you to import Payment Application records and line items by way of CSV and REST.
To export a copy of the payment application business process template
- Navigate to the General Spends business process log.
- Click Create to create a new 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 exported payment application business process template
- Open the exported CSV file in Microsoft Excel.
- Enter the business process information into the spreadsheet. Each upper form header record must begin with an "H". Each line item 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, 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
- Use to add new business process records only; not to modify existing business processes.
- You might find that you have to change some of the cells in the CSV file to Text type in order for data to import correctly. For example, if you have a CBS code of 1-1, 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, the description from the SOV sheet is imported, and the line item description is not imported.
To import the general spends line item template
- Navigate to the General Spends business process log.
- Open 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 file to view and correct the error. No records are imported if any rows contain an import error.