Somewhere, someplace ... someone must have a solut...
# suitescriptd
darrenhillconsulting
11/16/2022, 6:03 PMSomewhere, someplace ... someone must have a solution to determining when a Transaction is
Closeds
Stuart Anderton
11/16/2022, 6:18 PMCould you be more specific about the problem?
n
NickSuite
11/16/2022, 6:50 PMHave you tried checking the lines of the transactions if they are closed?
s
Stuart Anderton
11/16/2022, 7:20 PMCan you not just read the Status in an After Submit UE?
d
darrenhillconsulting
11/16/2022, 8:14 PMClicking in the
Closedarrenhillconsulting
11/16/2022, 8:15 PMBest solution so far is to use the BEFORELOAD to check the Close status.
darrenhillconsulting
11/16/2022, 8:15 PMHowever, there's no real solution to capture on the server side.
darrenhillconsulting
11/16/2022, 8:17 PMSo, if an integration closes a transaction, or a map/reduce or CSV import closes transactions, there's no way to know. Unless we implement a Map/Reduce (every 15min) that look for any transactions who have been updated in the last 15mins that is now closed.
s
Stuart Anderton
11/16/2022, 8:22 PMYeah, sorry I see what you mean.
Stuart Anderton
11/16/2022, 8:30 PMDon't like timed ones as they are hard to recover from if for some reason an iteration doesn't run.
I think I might have a UE script which copies the current status to a custom field on Before Load. Then make the scheduled script look for transactions where that custom field != actual status.