Merge 2 bills - Redcrest-Solutions/FlyingFleet-issues GitHub Wiki

UPDATE Transactions SET BillId = 2026000213 WHERE BillId = 2026000234;
DELETE FROM Bills WHERE Id = 2026000234;
DELETE FROM ImportPaymentItems WHERE CreditId IS NOT NULL;
DELETE FROM MemberCreditsUsages WHERE BillId = 2026000213;
DELETE FROM MemberCredits WHERE MemberId = 9;
DELETE FROM AccountingJournal WHERE TransactionId IN (SELECT Id FROM Transactions WHERE BillId = 2026000213 AND ArticleId = 28);
DELETE FROM Transactions WHERE BillId = 2026000213 AND ArticleId = 28;
UPDATE Bills SET Status = 10, Total = 1946.65 WHERE Id = 2026000213;