Hi:
A GP 2018 end user ran Purchasing Reconcile on purchase orders that were closed. Reconcile reopened closed purchase orders and, specifically, only the ones that have line items containing the "Miscellaneous" Item Type.
Upon discovering this, we went to Edit Purchase Order Status. "Closed" is not a choice in Edit Purchase Order Status but, rather, the only choice is "Cancelled".
Choosing "Cancelled", however, would cause future reporting issues in such integrating apps as SalesPad.
So, we decided to run simple T-SQL scripts against the POP10100 and POP10110 table to change the status back to Closed.
But, of course, Reconcile afterward reverted the changed purchase order back to Open.
Why does Reconcile change the status for purchase orders from Closed to Open for those purchase orders containing Miscellaneous line items and is there a way of preventing this?
Thanks!
John