We are recently having an issue with our open AP invoices. Once posted, they are automatically going on Hold. This is affecting all twenty-one companies in production. And if we try to clear the hold flag from PM20000, the invoices still remain on hold. Of course we can remove them under Transactions > Holds, but that is very time consuming because you have to do it per vendor ID.
Has anyone ever seen this happen before? And would anyone have the correct script to totally remove than from Hold in SQL?
Any help offered is greatly appreciated.
Patti Parks
*This post is locked for comments