Query of adjustments with reversing distribution accounts and amounts

Johnson Liang
Johnson Liang
Third Anniversary Blackbaud Certified
in Blackbaud Raiser's Edge NXT®: General Discussions

Hi All,

We are trying to build a query/export of data to import into our financial system (Microsoft Dynamics NAV). I'm currently stuck on being able to query for adjustments and have the reversing distribution accounts/amounts. Does anyone know if this is possible to get out of Raiser's Edge, or will we have to manually massage the data after exporting?

Tagged:

Comments

  • Faith Murray
    Faith Murray Community All-Star
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Johnson Liang, I do not think that this is possible in a Query/Export, although I might be mistaken. There is a KB article talking about a special Gift Type called “GL Reversal” under the Fund Query, but I have not been able to replicate that listing.

    However – do you currently use Financial Edge? And are your gifts marked as “Posted” or “Not Posted”? If your adjustments have only been living in RE and not been integrated yet with accounting software, and are still marked “not posted”, then it may be possible to export the data you need using the Admin-"Post to General Ledger" function to create an export file of Reversals within the date field you specify.

    If that doesn't work, I'd suggest reaching out to Support.

Categories