Answer

Note:  For On-Premise customers:  The user exporting to the MIP must have both Fundraising 50 and MIP Workstations installed on their machine even if the Fundraising 50 user is not an MIP user.

This article offers an overview of setting up integration between Fundraising 50 and Fund Accounting.  Specific steps may vary, depending on your organizational needs. 
 
Abila Client Services or your Abila Business Partner can provide a quote for assisting customers with establishing integration between Fundraising 50 and Fund Accounting and modifying DEF files should you require assistance. 
 
While modifying DEF files is not a covered support topic, consulting services can be quoted by our Client Services team.
 
It is recommended that you keep a second copy of your customized DEF files in a secure location to serve as a backup.
 
To establish integration between Fund Accounting and FR50, set the following parameters:

  1. Fund Accounting must be installed on the same machine with Fundraising 50.

  2. In Fundraising 50, navigate to Administration>Setup>System Options>Gift Export

    • Select the radio button to ‘Automatically initiate Abila Fund Accounting import upon completion of gift data export.

    • Add your Fund Accounting user ID and password

    • Select the fund accounting database you will be importing into


Select the Segments you wish to be included in the data file to be created for export.  (Tender is required)

Note: Customers who have MIP Fund Accounting hosted on our multi-tenant private cloud and who have Fundraising 50 installed on their local network will need to select "Export gift data file for later manual import into accounting".

a

       3.   Add your Abila GL Account and/or Segment values in Table Maintenance for the selected segments.         Access Table Maintenance from the Tool Bar by going to Admin>Table Maintenance>specific table>Segment Value. 



        4.  Using the default sample DEF files, you will need to edit these to ensure transactions are imported to the desired segments in Fund Accounting.  The default DEF files are located in C:\Program Files\Abila Fundraising 50\Import.  If the installation path was modified to a non-default location, these files will reside in the directory provided at the time of installation.
 
Modifying DEF files is not a covered support topic; however, consulting services can be quoted by our Client Services team.  




     5. Once DEF and CSV files are formatted to your specifications, the file locations will need to be indicated in the Abila Fundraising 50 Transaction Type Table:  (Administration>Table Maintenance>Transaction Type)




The export (CSV) file contains a list of all transactions exported ins a single Export session and can be used to verify against the resulting unposted transactions in Fund Accounting, for auditing purposes.

Customers who utilize our Private Cloud platform will need to configure their file paths with \\tsclient\C 

Article Type
Product Info
Product Line
Fundraising 50
Product Module/Feature
Data Import/Export
Ranking
No votes yet