We have performances built in the wrong campaign. Most of them have sold out. Both campaigns share the same GL Account so the issue is not one where the money has to be directed to a new account.
Is it possible just to reassign these performances to the proper campaign in performance details? What's the easiest solution?
thank you,
Jamie Kaufman
Hi Jamie,
I believe all you need to do is change the campaign in performance details and run the procedure AP_UPDATE_CAMPAIGN, but I would advise verifying this in a test environment first.
Here is the description of this procedure. (as well as ap_update_appeal)
AP_UPDATE_APPEAL and AP_UPDATE_CAMPAIGN: These two procedures recalculate the Appeal and Campaign financial totals to make sure that they are in sync with the actual contribution and sales records. While the Campaign and Appeal records are updated every time a financial transaction is saved, these procedures just verify that there is no discrepancy. We recommend that these procedures be run monthly, although there is no harm in running them more frequently. Note that these procedures only affect the amounts and successful contacts displayed on the Appeal and Campaign summary screens. All reporting financial totals are calculated from financial tables and will always be accurate, even if these procedures are never run. Some appeal reports do pull the successful contacts amounts for sources from the T_APPEAL table and therefore that figure could be affected if this procedure is not run. The Contacts Attempted field in the Campaign Header and the Target Cust field in the Appeal header are not updated dynamically and so these procedures should be scheduled to run on a regular basis to update those columns. Neither of these procedures requires any parameters.