All transactions could not be entered
When importing the ACH Report File in Gift Import, this error displays:
All transactions could not be entered. Print the error log for detail information.
Products affected: Contributions
Versions affected: Any
Not every individual in the CSV file from Excel has a fund code. ACS only accepts those contribution records with a designated fund code.
- Open Microsoft Excel.
- Click File, then Open.
- Locate the saved CSV file.
- Delete the top two title rows that contain the date and time the file was exported.
- Enter the missing Fund Numbers for every individual under the column to the right of Envelope Number called FUND. This lets you import the file for all funds, instead of one at a time (ACH Format only does one fund at a time.)
- Save the file in .CSV format.
- Close the Excel Spreadsheet and exit Microsoft Excel.