A customer bought a membership. The representative accidentally applied an ACH/Wire Transfer payment instead of charging a credit card. The order has already been paid and ticketed. In actuality, no payment has been received. We would like this payment record to disappear and not have to make a negative payment in Tessitura (and thus a refund). Can this record simply be deleted from the T_PAYMENT table? What are the repercussions of deleting a record from T_PAYMENT? What other options can we pursue either within Tessitura or through T-SQL?
Thanks!
Debbie
Thanks Sara and Leslie for your replies! Tessitura is in full agreement with both of you. They strongly urged us to NOT make any updates to the T_PAYMENT table.
It is up to Finance to decide how to handle this now. Thanks!