Notifications
Clear all
Topic starter
I am told GE has a script for completing In Process Orders to help improve performance. I have tried to call and get it but right now I'm holding on the phone in perpetuity.
Has anyone seen this? My understanding is you can go back by date, which only makes sense. Thank you!
Posted : November 8, 2017 3:56 am
I don't know if GE has that, but I created this a while back.
https://marketplace.centricityusers.com/#/my-account/preview/409
its free, just have to customize it to your needs.
Posted : November 8, 2017 3:59 am
In looking at your script, does the 'A' refer to admin hold, and if changed to 'I', would that cover the In Progress items?
--Gets Updated User Unique ID Number
SELECT @PVID = PVID
FROM USR
WHERE LOGINNAME = @USER AND STATUS = 'A'
Thanks!
Posted : November 8, 2017 4:09 am
That is for the login, show Active User
Posted : November 8, 2017 4:14 am
Where it states ORDERS
STATUS
U = Unsigned
H = Administrative hold; the order has been signed, but not sent to the service provider.
S = In process; the order has been signed and sent to the service provider.
C = Complete; the order has been processed and any requested results have been received.
X = Canceled; the order was canceled after being signed.
so you want to use S there.
Posted : November 8, 2017 4:15 am
Thanks for the update, I realized my confusion after I posted.
Posted : November 8, 2017 4:20 am
No problem, anytime 🙂
Posted : November 8, 2017 4:21 am
