We are on Polaris 7.8 and recently got the patch for POL-22964, where “Print manual bills are “posting” to the database (removed from NotificationQueue) when staff initiate the post from the staff client Reports and Notices Utility, but these never update from “Pending” to “Billed” in the patron account.” However, the patch only resolves the problem for new bills. I’m trying to find existing print bills stuck in pending status and see if I can update them. However, NotificationQueue is a RESULTS table in the Transactions database, so I don’t really know how to work with it.
I am hoping one of you has attempted to fix the same problem and might be able to share how you approached it.
Hi Emma, I can’t come up with an exact report, sorry. However, if you know the reason(s) why you would have billed anything that would be pending (for us it seems to just be missing parts) you might be able to find most of the bills in question? I just ran a report that included patron IDs and “acct reason (or fee reason)” and then filtered the excel file before importing into a record set. Most of the bills with that reason are older and yes, still pending.