We're trying find a solution that allows us to bulk change from one hold code to another on a performance.
I wrote this basic SQL update statement with the intent to create a custom utility that could be run via the application:
update tx_perf_hc
set hc_no =
from
where hc_no =
and perf_no =
It seems to work but I might be missing other tables that need updating as well?
Would love some insight.
Thanks!
Hey Wes,
Not sure if you found a solution to do this, but a Utility has been developed that is used by a lot of Asia Pacific licensees to do exactly that and much more. It was developed to automate consignment of inventory (using hold codes) from one Licensee to another.
I'll see if our team can share it with you, if you're still looking for a solution?
BeauArts Centre Melbourne
Hi, if this is still on offer id love to get a copy as it sounds like the perfect solution to a project I'm working on.
IIRC We just ended up using a hold code map and used season manager to replace the holds