Unique Identifiers for Journal Entries

Options
Lori Rudderham
Lori Rudderham ✭
Seventh Anniversary
in Blackbaud eTapestry® General Discussion
Hello,


Is there any way when a journal entry is added that a unique identifer or a generated number is attached to it. We need a way to reconcile each journal entry with our Finance dept and this seems like the best way. The generated receipt number was suggested but would not would for every journal entry.
Tagged:

Comments

  • Ally Seidel
    Ally Seidel ✭
    Ninth Anniversary Facilitator 1 Photogenic
    Lori, would the journal Entry Ref serve your purposes? A unique Entry Ref number is created each time a journal entry is created. Unfortunately, this number is not visible on the transaction record itself, and it is not something you can query or search on in the database. But, it is reportable. You can include a column for "Entry Ref" in any custom report.

    2b06c41eb464dbd6d5465ff24ad73c19-huge-en


    Alternatively, you might use the "Final" checkbox on the transaction. This doesn't provide a unique identifier, but it would allow you to mark off the transactions you've reconciled allowing you to focus your efforts only on those you haven't. If it helps, my colleague has written about how this can be used with a Quickbook integration (see blog post here).
  • Maggi Junor
    Maggi Junor ✭
    Ninth Anniversary Facilitator 1 Name Dropper Photogenic

    Lori Rudderham:

    Hello,


    Is there any way when a journal entry is added that a unique identifer or a generated number is attached to it. We need a way to reconcile each journal entry with our Finance dept and this seems like the best way. The generated receipt number was suggested but would not would for every journal entry.

    We use the the Entry Ref Number in our reports so we can pinpoint specfic journal entries

Categories