Deposit Import

Robin Heine
Robin Heine
Third Anniversary
in Blackbaud Financial Edge NXT® General Discussions

We are new to Financial Edge and have a number of deposits and payments to bring over. I am starting with the Deposit Import. The import is failing on the Deposit ID. Looking at the deposit record, it looks like you create the Deposit ID with a limit of 12 characters. When I do that for the import, it fails. I cannot find the definition of the Deposit ID anywhere. Any ideas?

Comments

  • Paul Wu
    Paul Wu
    Sixth Anniversary Kudos 2 Name Dropper Facilitator 1

    Not sure if this will help, but you can try changing the column formatting from “general” to “Text”

    I've had to do this when I import JE's.

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    Hi Robin,
    The deposit id is an optional field you can use separate from the Deposit Number which is auto-generated by FE. It is a 12 character alphanumeric field. See the screenshot below. To import a payment into the deposit ( as the import function is for payments, not deposits, so you'd have to create/save the deposit first with no payments). You'd need the deposit ID as one of the fields in the import file. So let's say I wanted to import 3 payments to the deposit below, I'd use the deposit ID field in the import file to tell the import which specific deposit to save the payments on. So in theory, if you had multiple open deposits saved, you could have 1 file and do 1 import to add many payments to multiple deposits, using the Deposit ID field to point where each payment should go.

    7c73f5d02e0df1abc14c19c56703fa88-huge-im

Categories