Merge 2 bills

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

Documents

Flight logging

Operations

Flying Fleet
Contact us for more information or to book a live demo.
Flying Fleet is a Redcrest Solutions product.

+41 41 511 50 99
Redcrest Solutions GmbH
Sinserstrasse 67
6330 Cham Switzerland
2026 Flying Fleet. All rights reserved.

We use cookies

We use cookies and similar tracking technologies to enhance your browsing experience and gather statistical data. To help us develop and improve our content and services, we may securely store or access information on your device and process personal data, such as your IP address and browsing history. Our primary analytics tool is Google Analytics. Please note that the cookies we use are essential for the website to function correctly.
Accept