Hello all,
We are about to launch our digital season and it has come to our attention that in order for patrons to view the productions, the order must be processed on the household level if one exists. I'm trying to figure out a way to pull all orders in this season that were processed to an individual where a household exists. Then, we would transfer the orders to the household.
I imagine a query would be possible, however, I'm still a SQL beginner.
Unfortunately, time is of the essence. Any help would be appreciated!
Thanks in advance,
Michelle
How many accounts are impacted? This can be done manually within a household record by selecting the household member and then in the menu bar going to Constituents > Household Operations > Move transactions to household. If you have a few hands on deck to help crank those out, it might be a faster project than going through the SQL route.