Hello,
I was sure this was posted, but.....
Has anyone written a query to look up really old orders to cancel or complete? I would be very interested and very grateful!
Thank you,
Dana
https://www.aphoenixtech.com/estore/centricity-apps
You can download it from my website for free.
Oracle or CPS?
CPS, but it is pretty much the same for Oracle, you have to change some stuff to meet Oracle script standards, but you can get the idea from this script.
its easy enough to write just in chart reports. FIND > Orders WHERE > Status is/is not complete/admin hold/canceled/in process
etc etc
Scott, a bit more complex that just updating the status, there are multiple records that get created when updating the status. I already have the script all done, you gotta download it free. You are set to go after that.
Thanks Acantu - I ordered a few of your free scripts. 🙂
Not a problem 🙂 Glad to be of service 🙂
Hi there. I am trying to download this script and it is giving me a website warning and advising me to back off. I would like to have the script if possible!
Thank you!