private static FinancialAccountRows RowsNotInVatReport(FinancialAccount account, DateTime endDateTime) { Organization organization = account.Organization; SwarmDb dbRead = SwarmDb.GetDatabaseForReading(); FinancialAccountRows rowsIntermediate = FinancialAccountRows.FromArray( SwarmDb.GetDatabaseForReading().GetAccountRowsNotInVatReport(account.Identity, endDateTime)); FinancialAccountRows rowsFinal = new FinancialAccountRows(); foreach (FinancialAccountRow row in rowsIntermediate) { // Check if this row _closes_ an _existing_ VAT report, in which case it should _not_ be included int vatReportOpenId = dbRead.GetVatReportIdFromCloseTransaction(row.FinancialTransactionId); int vatReportCloseId = dbRead.GetVatReportIdFromOpenTransaction(row.FinancialTransactionId); if (vatReportOpenId == 0 && vatReportCloseId == 0) { // This particular transaction doesn't close an existing VAT report rowsFinal.Add(row); } } return(rowsFinal); }