Known Blackbaud NXT Issue Causing GL and TB to be Out of Balance

Christopher Hafer

If you void payments, double check your GL that the reversal didn't post for double. There is an known issue that doubles the reversal in the GL but not the TB. I asked support why we weren't notified of the issue, and their response was, “Not every organization is effected which is why Blackbaud decided on publishing an article vs sending a mass notification.” I've posted a link below to the article they so quietly posted surrounding the issue.

Christopher Hafer

@Christopher Hafer
I also would like to note that this article was uploaded to their database today 1/25/2024, but I see that there are forum questions with this issue dating back to 12/14/2023. It's been a known issue for at least a month.

Julie Jump

@Christopher Hafer

See the discussion topic “Invoice Showing as Posted Twice” for prior conversations and other members' comments. I have provided documentation of the issue as we see it, and they have requested a copy of our database so their developers can work on a fix. We have posted voids in January that (so far) appear to be correct - our affected transactions posted in November and December.

Christopher Hafer

@Julie Jump
Thanks for the info. I actually have commented on that feed as well. It was created back on 12/14/2023. When in November did you have a void that was affected?

Blackbaud did say that moving forward the issue shouldn't happen again, but they were also still testing the fix. They have no solution for the ones that are already posted.

BTW, Blackbaud has also suggested creating journal entries to correct voids that doubled in the GL, and your circumstance could be different, but if we were to post a journal entry to correct the GL, our TB would be out of balance. Currently our GL and TB don't match.

Julie Jump

@Christopher Hafer
The November transaction was actually voided in December but used a November posting date.

I documented where transactions appear differently based on how one report parameter was set, and when looking at the transaction in webview versus database view. This is why I didn't even try a correcting JE.

Debbie Thacker

@Christopher Hafer
Thank you – we have been trying to figure out why the Balance Sheet report from FE is off from the Trial Balance report from FE in both cash and A/P in December. We found the voided check transaction for the difference and see that the “Transaction amount” is double the “amount”. Nice to know we're not alone but very frustrating that it happened!

Julie Jump

@Christopher Hafer
I was notified today that Blackbaud implemented a fix for this issue - at least on our database. After checking the places I'd seen the error it does appear their fix worked.

Debbie Thacker

@Julie Jump
I was going to post today that between last Friday and yesterday our one issue with a voided check being doubled on some FE reports was fixed as well. I went in yesterday 1.29.2021 to run the reports needed to report the issue to Blackbaud and miraculously all reports were showing the correct amounts!

Paul Wu

@Christopher Hafer

Really don't know why this issue was not brought to our attention, even when we created a case for it on Jan 23.

It was very frustrating to see the balance of my Tbal and my Gl account the same, but my report showed a different number for our December Quarter end statements.