Adding promotions through SQL

Hey all,

Quick question for anyone that does this regularly.

I had an inside source that I needed to add an additional 211 names to. I figured out how to add them to T_PROMOTION and everything seems to be just fine on that end. But I'm noticing that the Contacts number in the source is still the old number and the Revenue by Source and Appeal report pulls that old number as well. I don't think it's a big deal for this particular source but is there a way I can make that number update? Or is there no way to make it update and this is now a lesson that I've learned for future updating of this kind?

I wasn't confident that it would work at the source level but I did try running the AP_UPDATE_APPEAL procedure just in case. It didn't change anything.

Thanks for the help!

Parents Reply Children
No Data