• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 60 views
  • Users 0 members are here
Related

Deleting a record from T_PAYMENT?

Former Member
Former Member $organization

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

Parents
  • $organization

    In terms of maintain a proper audit trail , I would advise not attempting to delete this payment. Since you already have it posted and in the GLs it would create a “hole” and your Finance dept would likely have to note the adjustment anyway in its records.   

     

     

     

    From: Debbie Jacob [mailto:bounce-debbiejacob1796@tessituranetwork.com]
    Sent: Wednesday, April 05, 2017 12:53 PM
    To: McKinley, Leslie <LMcKinley@nycitycenter.org>
    Subject: [Tessitura Technical Forum] Deleting a record from T_PAYMENT?

     

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    In terms of maintain a proper audit trail , I would advise not attempting to delete this payment. Since you already have it posted and in the GLs it would create a “hole” and your Finance dept would likely have to note the adjustment anyway in its records.   

     

     

     

    From: Debbie Jacob [mailto:bounce-debbiejacob1796@tessituranetwork.com]
    Sent: Wednesday, April 05, 2017 12:53 PM
    To: McKinley, Leslie <LMcKinley@nycitycenter.org>
    Subject: [Tessitura Technical Forum] Deleting a record from T_PAYMENT?

     

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data