Open P.O.s

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!

Reply to
Alex
Loading thread data ...

Is there any way to separate the ones you want to leave open vs the ones you want to close. ie Last updated before a certain date, certain supplier, etc. Let me know and I can give you a script.

Reply to
rsakry

I would like to close all POs last updated prior to 10/01/2007 (but not receive them).

Thank you!

Reply to
Alex

Alex, Here is a script that should take care of that: UPDATE PurchaseOrder

SET [Status] = 2

WHERE LastUpdated < '2007-10-01'

Reply to
rsakry

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.