I have a whole bunch of open POs that I would like to mark as closed without actually receiving them. Is there an SQL script that I can run to accomplish this without affecting anything else (like inventory etc)? We have basically been using the back office part of RMS SO for 3 years but we only have been using the front office (POS) for about 6 months we are getting ready to do physical inventory and want to "close" all open POs without actually receiving them because this would throw off our inventory because a PO from 3 years ago would have been physically received already and the PO items (most likely) have been sold already but none of this would have gone through RMS. Does anybody have any suggestions or recommendation (and a SQL script) in regards to the above?
Thank you!