Question

How to upload allocations to Funds through a file?

Answer

1. Prepare an input file. Here is an example of an Excel file:

Fill in:

• FUND_EXTERNAL_ID - The External ID of the fund or the Fund's Code. This is the identifying value for the fund, and is mandatory.
• The FISCAL_PERIOD_ID is found in: Configuration > Acquisitions > General > Fund and Ledger Fiscal Period
• AMOUNT
  • To reduce Allocation, create a minus sum, such as: -100
• TRANSACTION_REFERENCE_NUMBER 
  • Not mandatory to have value in this column
• TRANSACTION_NOTE
  • Not mandatory to have value in this column

2. Verify that you have access to an FTP server, as set-up in: Configuration > General > Integration Profiles > Integration Type: Finance > for example: "ERP"
3. In the above integration profile > "Actions" tab > find the section "FUNDS ALLOCATION LOADER"
4. Note the subdirectory (you may need to change it, as long as it exists in the FTP server as configured in step #2)
5. Modify the input file - keep it small at least in the beginning when you test
6. Load the file to the FTP server as configured above
7. Open again the Integration Profile > Actions > Find the section "FUNDS ALLOCATION LOADER" > make sure that the Loader section is "Active", and "Run"

The job which will run is: Update Fund Tx Job.

Additional Information

Read here about "Financial Systems" Integration Profiles

And more about the "Funds Allocation Loader – Fund Allocation Loader (called Update Fund Tx Job in the list of scheduled jobs)"

• Article last edited: 2-JUL-2023