Add group Batch update for date

Add group Batch update for date


Currently if you make an error on the contribution date you have to go in and manually change each gift. if would save a lot of time to be able to update the date by batch.

Photo of Angela Pruitt Submitted by Angela Pruitt, The Crossing Church  ·   ·  Finance
Login to add a comment...

  • Andrew Torrance

    For now, if you're trying to mass update all transactions in a batch to the same date, you can use the following SQL in Power Tools, just be careful and change the TransactionDateTime and BatchId as needed.

    UPDATE dbo.FinancialTransaction
    SET TransactionDateTime = CAST('2019-08-06' AS DATETIME)
    WHERE BatchId = 2958