Invoice deleted but still showing in NXT report

Andrea Trembath

Hi We run reports on acct #s to include unposted transactions as there are often journals that have yet to be posted, etc. If an invoice is deleted (input incorrectly for instance), it will no longer show in the database version and in NXT the invoice is listed but marked as Deleted when you review that vendors invoice history. However in the Report for that acct code it will still show. does anyone know of a way to not include a deleted invoice in that expense code - it is slightly different than ‘unposted’ and we don't see a way to “exclude deleted items”. TIA (thanks in advance)

Andrea Trembath

I should also add that we ran the report without including Unposted items and the deleted invoice was still showing in the expense acct. Perhaps a bug?

Christopher Hafer

@Andrea Trembath
There unfortunately isn't an “exclude” option in the report filters. Maybe that's one for the Blackbaud engineers to consider adding in the future. What you're describing does sound like a bug to me. What's the post status of the deleted invoice? Posted, unposted, or do not post?

Andrea Trembath

@Christopher Hafer thank you for your comments. Invoice shows as an unposted item,

Christopher Hafer

@Andrea Trembath
Okay, yeah that sounds like a bug. I've created and deleted invoices before that don't show up on the financials in any report because they were never posted. They're effectively deleted and purged. Honestly, I was hoping you'd say it was showing up as “do not post” so you could filter your post status to include “posted” and “unposted”, but that won't help. You need to be able to see all unposted items, but not this deleted item that shouldn't exist anymore. Maybe Blackbaud support can help if you figure out how to purge the invoice if you open up a support case.