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
Hey Beau,
Oh brother, I totally lost track of this thread. :/
I'd love to see that utility, if your offer is still on the table and your team is willing to share.
wes