Update subscription revenue row from new transaction

Your course transaction records arrive uncategorised, leaving revenue and enrolment lists inconsistent for billing and reconciliation. Add or update the subscription log so billing and admin have accurate records before reconciliation.