When a membership line item is deleted from the current period tab in the "manage installments" screen, we unlink the LineItem record for this membership from any future pending contribution in the payment plan, but while investigating BASW-897, I noticed that we still keep the MembershipPayment record that links the Contribution with the Membership, and thus if you open the membership that we removed from the current period tab, you will still see that it is linked to the future pending contribution even though it has no line items on any of these future contribution, this PR corrects by removing the MembershipPayment Record that links the two.
Technical details
I used raw SQL query because MembershipPayment API end point does not support the "delete" action.
Overview
When a membership line item is deleted from the current period tab in the "manage installments" screen, we unlink the LineItem record for this membership from any future pending contribution in the payment plan, but while investigating BASW-897, I noticed that we still keep the MembershipPayment record that links the Contribution with the Membership, and thus if you open the membership that we removed from the current period tab, you will still see that it is linked to the future pending contribution even though it has no line items on any of these future contribution, this PR corrects by removing the MembershipPayment Record that links the two.
Technical details
I used raw SQL query because MembershipPayment API end point does not support the "delete" action.