Skip to content

Merge 2 bills

bertrand-alain edited this page Oct 3, 2026 · 2 revisions
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;

Article 28 => credits

Clone this wiki locally