Alternately, from menu items in the new Treasury Management user interface (UI) you can use the More button to download dedicated Excel Templates for Integration for the specific menu item, identical to the Available templates for import below.
Figure 1. .
Important: You cannot use the Template for Import file download from the Treasury Management user interface (UI) to import files for integrations in Coupa. These are for UI upload in Treasury Management only, as they are based on user language settings in that application.
.
Avoid loading dependency object files at the same time. For example, do not load the Project, Portfolio, and corresponding Cash Flow files at the same time, but load the Project and Portfolio files first, and then the Cash Flow file.
For a small data set, create the data records manually through the UI instead of using a CSV import.
Each inbound file has a limit of 5000 rows and 100 MB.
The date format must be one of the following:
yyyy-MM-dd
MM/dd/yyyy
dd.MM.yyyy
You must use a period mark (.) as the decimal separator for all upload files.
For more information on the elements for the CSV imports, refer to the API documentation in the Treasury Management application. See View Treasury API Documentation.
Inbound files are picked up every 3-6 minutes from your Coupa sFTP site for further processing. This schedule cannot be modified. Once the file corresponding to each object is processed, the file is moved to the corresponding /Archive folder.
Add files to the respective folders under the /Incoming folder. For example: /Incoming/FxRates.
Important: To import classic Treasury market data, your user must be designated as a Classic Import Automation user in Treasury Management. For more information, see Designate automation users.
