PO lines did not close after items received
We are running E1 9.2.7.4 and have come across several hundred lines on PO's that have been fully received and paid but do not show a next status of 999. What is the recommended practice for closing these lines? I was planning to update the next status via SQL to 999 but I am unsure what other tables would need to be updated.