Report to move On-Account Money to Fund Code en masse

I'm kicking myself for not thinking of this a few years back but last week as I faced the upcoming task of moving our unused On-Account Ticketing money to contributions (400+ entries of small amounts), it hit me why don't we have a program.

We have a program to do auto charges and auto renenewals.  We have program reports that cancel/write off pledges.   More recently a program repor that cancels gift card balances to an On-Account.    All create financial transaction in batches.  

So why should we individually post 400+ entries that are going to go to the same fund and get the same acknowledgement -- when there could be a program report that does it???   My thought is have report that takes everything with the Payment method of X and moves it to Fund Code XX and of course a List can be used as well. It's parameters would be as below

Batch Type:

List:

Payment Method:  (would be good if we could limit it to On-account but not necessary)

Fund Code:

Appeal:

Acknowledgement:

Review Only: (Y/N)

(Channel would come from the original entry)

Has anyone else realized the same thing and already,hopefully, has this report to share?

I have some data entries folks here that will be forever grateful if this does exist.   Thanks

 

 

Parents
  • Hi, any chance you or anyone made any progress on this. my order entry operators would be gratefull to not have to do this for 4000+ constituents going back 5 years:)

    ===========================

    Mendy Sudranski

    IT Manager

    Manhattan Theatre Club

    311 West 43rd Street - 8th Fl

    New York, NY 10036

    Phone: (212) 399-3000 ext. 4105

    msudranski@mtc-nyc.org

     

Reply
  • Hi, any chance you or anyone made any progress on this. my order entry operators would be gratefull to not have to do this for 4000+ constituents going back 5 years:)

    ===========================

    Mendy Sudranski

    IT Manager

    Manhattan Theatre Club

    311 West 43rd Street - 8th Fl

    New York, NY 10036

    Phone: (212) 399-3000 ext. 4105

    msudranski@mtc-nyc.org

     

Children
No Data