v1.22.0

What's Changed

• Update CODEOWNERS by @seeker25 in #1548
• 21464 - Merge EFT into main branch by @seeker25 in #1552
• Fix for fees by @seeker25 in #1553
• 21584 - REPORT-API - Python Upgrade by @seeker25 in #1554
• Bump requests from 2.31.0 to 2.32.2 in /pay-api by @dependabot in #1555
• 21584 - REPORT-API - Cleanup deps by @seeker25 in #1556
• 18619 20719 eft statement updates by @ochiu in #1557
• 20719 - Add interim statement logic when change payment away from EFT by @Jxio in #1558
• Fix CI for pg8000, also fix deps for pay-admin by @seeker25 in #1559
• 18619 - UXA fixes by @ochiu in #1560
• Bump tornado from 6.4 to 6.4.1 in /bcol-api by @dependabot in #1562
• 20088 - Updating unlock_frozen_accounts to take in payment_id and payment_account_id by @rodrigo-barraza in #1563
• 21676 - Add in credits for is_reversal also add in refund_date by @seeker25 in #1564
• Small fix for reconciliation, return statement was nuked by @seeker25 in #1565
• Create a docker-compose file for Arm64 testing by @Jxio in #1566
• 20088 - Unlock associated accounts when paid with exact amount by @rodrigo-barraza in #1561
• Add in gunicorn_config also don't use werkzeug by @seeker25 in #1567
• 21721 - Add ordering to FTP_POLLER by @seeker25 in #1568
• Update DEVELOPER_NOTES.md by @seeker25 in #1569
• Bump urllib3 from 2.2.1 to 2.2.2 in /bcol-api by @dependabot in #1571
• 20069 - All Partners Monthly reports with details of transactions by @hanlunBCRegistries in #1574
• Bump urllib3 from 1.26.17 to 1.26.19 in /jobs/notebook-report by @dependabot in #1572
• Small fixes for pods by @seeker25 in #1575
• Logging tweak to include exception by @seeker25 in #1576
• 20719 - EFT Statement Template Fixes by @ochiu in #1577
• Update payment-jobs-ci.yml by @seeker25 in #1579
• Bump urllib3 from 2.2.1 to 2.2.2 in /report-api by @dependabot in #1580
• Remove report-api, add in developer notes. by @seeker25 in #1583
• 20719- Interim Statements Settings Fix by @ochiu in #1584
• 20719 - Update DEVELOPER_NOTES.md to include new auth account id by @seeker25 in #1585
• Add in small logging instead of throwing exception by @seeker25 in #1586
• Fix sqlalchemy warning by @seeker25 in #1587
• Small fix for dev .env by @seeker25 in #1591
• Fix warning for migration by @seeker25 in #1592
• 22081 - Refund issue - possible request can be None by @seeker25 in #1595
• 22063 - Fix receipt method for EFT by @seeker25 in #1596
• 22063 - Put back CFS account creation or updating by @seeker25 in #1594
• 20907 - Pay outstanding balance switching from EFT payment method by @ochiu in #1573
• Update setup-python in CI by @seeker25 in #1601
• 22206 - Refactor payment account service so it's more dynamic and less boiler… by @seeker25 in #1600
• Small fix for sqlalchemy warnings by @seeker25 in #1602
• 19513 - Add CSV Feedback monitoring by @Jxio in #1598
• Disbursement refund date fix by @seeker25 in #1603
• Warning fixes, update deps by @seeker25 in #1604
• Bump certifi from 2023.7.22 to 2024.7.4 in /jobs/notebook-report/requirements by @dependabot in #1605
• 21622 changes to notebook report for generating revenue letter by @avni-work in #1606
• EFT Invoice create fix, outstanding balance CC flow handling by @ochiu in #1607
• Enhance EFT outstanding balance handling by @ochiu in #1608
• 22018 - PAY-ADMIN - Fix for issues with cookies, also fix OIDC library that depreciated methods by @seeker25 in #1609
• 22018 - PAY-ADMIN - Docker fixes by @seeker25 in #1610
• 19513 - Fix - can't locate env variable IT_OPS_EMAIL on dev by @Jxio in #1612
• 22063 - Allow multiple payment methods, also create multiple CFS accounts to support EFT/PAD switching by @seeker25 in #1597
• Set pad_cfs_account to INACTIVE on PENDING/PENDING_PAD_ACTIVATION by @seeker25 in #1614
• Minor tweak to BCOL-API, extra slash doesn't work by @seeker25 in #1615
• 21622 - adding partners by @avni-work in #1617
• Bump setuptools from 69.2.0 to 70.0.0 in /bcol-api by @dependabot in #1618
• 20087 - PAY-JOBS / ACCOUNT-MAILER - Overdue BCROS A/C not Paid on Time by @seeker25 in #1527
• Routing Slip Search - Cast to numeric for balance for PG8000 adapter by @seeker25 in #1619
• 21527 - Cancel/Apply EFT payment, initial for reverse payment by @ochiu in #1613
• 21535 - Shortname Refund by @Jxio in #1611
• Fix migration logging by @seeker25 in #1620
• Add in composite index for invoice_status_code and payment_account_id by @seeker25 in #1621
• 19513 - Pay-queue yml file missing env by @Jxio in #1622
• 20596 - Rework EFT receipt and apply/reverse invoices job by @seeker25 in #1623
• Upgrade GCP CD pipeline. by @pwei1018 in #1625
• 20596 - Minor clean up and changes for jobs by @seeker25 in #1626
• 20596 - revert logging, put in new column for receipt_number by @seeker25 in #1627
• Bump urllib3 from 2.2.1 to 2.2.2 in /pay-api by @dependabot in #1628
• Bump urllib3 from 2.2.1 to 2.2.2 in /pay-admin by @dependabot in #1629
• 19513 - Add more error catching for csv feedback reconciliation by @Jxio in #1624
• Add keycloak vault to pay queue by @Jxio in #1630
• 19513 - Typo tweaks, removed a log used for testing env by @Jxio in #1631
• Add entity vault to pay queue by @Jxio in #1632
• 19513 - Add "api-points" to shared vault by @Jxio in #1634
• 19513 - Add traceback to csv feedback process error handling by @Jxio in #1635
• 21535 - Update url in eft refund email by @Jxio in #1636
• 20136 - Fixing typo in download transaction invoice link by @rodrigo-barraza in #1639
• 22430 - Pay-admin having issues with 500k payment_account rows in the dropdown by @seeker25 in #1640
• Bump sentry-sdk from 1.42.0 to 2.8.0 in /bcol-api by @dependabot in #1641
• 21528 - EFT Reverse Statement Payment by @ochiu in #1638
• Minor tweak run off of invoice.payment_account_id instead of eft_cred… by @seeker25 in #1642
• 22480 - Skip version tables in migrations by @seeker25 in #1644
• 22480 - Part 2 - Migration fix by @seeker25 in #1645
• 21535 - Eft refund for eft_credits by @Jxio in #1648
• 21979 - On Test, The EFT linkage Modal Take a long time to load by @seeker25 in #1647
• 22588 - Revert partner disbursements, fix migration processes, update versions, prod PREP by @seeker25 in #1651
• 20087 - Statement locking and notification by @seeker25 in #1650
• 20087 - Add in additional emails by @seeker25 in #1654
• 22625 - Move to 1 month + 15 days instead of 1 month for overdue by @seeker25 in #1656
• 22625 - Build unit test so it's realistic, rewrite the day_invoice_due logic … by @seeker25 in #1657
• 22625 - Add in action date override by @seeker25 in #1658
  ...

V1.20.10 - Payment Services May, 2024 Release

What' new

• #1546: 21472 - update sbc-pay version for release 1.21.0
• #1543: Bump requests from 2.31.0 to 2.32.2 in /jobs/notebook-report/requirements
• #1542: 21440 - Refactor queues to point at shared queue library
• #1541: Add in ordering key for SFTP.
• #1538: Bump requests from 2.31.0 to 2.32.2 in /bcol-api
• #1537: 20454 - PUB/SUB Integration TEST on Python 3.8
• #1536: Small tweak use corp type for NRO.
• #1535: Read from cache for corp_types. Add in cache to pay-queue.
• #1534: Bump requests from 2.31.0 to 2.32.0 in /pay-queue
• #1532: Bump requests from 2.31.0 to 2.32.0 in /pay-api
• #1533: Add in more corp types for filtering.
• #1531: Fix CD pipeline
• #1495: 20941 - PUB/SUB Queue upgrades for Python 3.8 master branch
• #1524: don't fail CI if codecov fails.
• #1486: Bump aiohttp from 3.9.2 to 3.9.4 in /queue_services/payment-reconciliations
• #1476: Bump idna from 3.4 to 3.7 in /report-api
• #1475: Bump idna from 3.4 to 3.7 in /jobs/ftp-poller
• #1474: Bump idna from 3.4 to 3.7 in /queue_services/payment-reconciliations
• #1473: Bump idna from 3.4 to 3.7 in /bcol-api
• #1472: Bump idna from 3.4 to 3.7 in /pay-api
• #1471: Bump idna from 3.4 to 3.7 in /jobs/payment-jobs
• #1470: Bump idna from 3.3 to 3.7 in /pay-admin
• #1469: Bump idna from 2.9 to 3.7 in /jobs/notebook-report
• #1468: Bump idna from 2.9 to 3.7 in /jobs/notebook-report/requirements
• #1459: 20607 - Add in TZ conversion
• #1458: Bump pillow from 10.2.0 to 10.3.0 in /report-api
• #1446: Add pay api gcp CD flow.

Thanks to

@Jxio, @avni-work, @dependabot, @dependabot[bot], @pwei1018 and @seeker25

v1.20.9

What's Changed

• Add in branch_name by @seeker25 in #1406
• PAY-API - Update Get Routing Slip to include refund_amount by @Jxio in #1407
• Bump grpcio from 1.54.2 to 1.54.3 in /queue_services/payment-reconciliations by @dependabot in #1410
• 19803 - Changes to search, to exclude inactive org ids by @seeker25 in #1412
• 19762 - Data Model Changes - Partial Refunds by @ochiu in #1413
• 19759 - Partial refunds PAYBC implementation by @seeker25 in #1414
• 19759 - Changes after testing with PAYBC by @seeker25 in #1416
• 19760 - initial partial refunds model persistence by @ochiu in #1415
• Bump cryptography from 42.0.0 to 42.0.2 in /pay-api by @dependabot in #1421
• Bump cryptography from 42.0.0 to 42.0.2 in /jobs/ftp-poller by @dependabot in #1420
• Bump cryptography from 42.0.0 to 42.0.2 in /queue_services/payment-reconciliations by @dependabot in #1419
• Bump cryptography from 42.0.0 to 42.0.2 in /jobs/payment-jobs by @dependabot in #1418
• 19929 - Checking for failed payments in NSF reconciliation flow by @rodrigo-barraza in #1426
• Fix the description field, it's incorrect by @seeker25 in #1427
• 19912- Updating partial refunds type enums by @rodrigo-barraza in #1430
• Add in invoice number to logging by @seeker25 in #1431
• Add in feature flag for partial refunds by @seeker25 in #1432
• 20037 - Fix NSF unlock receipt by @seeker25 in #1429
• Add in initializer for details by @seeker25 in #1434
• 19875 - Add Disbursement to refunds_partial by @Jxio in #1433

Full Changelog: v1.20.8...v1.20.9

v1.20.8

What's Changed

• 17382 - Update the Wording based on PAD Receipts by @Jxio in #1281
• 17829 - EFT Service updates by @ochiu in #1293
• payment-jobs - sbc-pay dependency hash update by @ochiu in #1294
• 17224/17829 - EFT over due status handling updates by @ochiu in #1295
• 17224 - EFT Payment reminder notifications by @ochiu in #1282
• 18012 - Minimum changes for new PayBC partial refunds. by @seeker25 in #1308
• 17869 - REPORT-API - CFS Account Number Added by @AbrahamRostampoor in #1309
• 18099 - PAY API - endpoint to add EFT Allowed flag to an account by @Jxio in #1307
• Remove default=False, put in server_default='f' by @seeker25 in #1312
• 17303- New EFT PDF Statement Template by @rodrigo-barraza in #1296
• Minor tweak for enable_eft. by @seeker25 in #1313
• 18395 - Implement EFT available notification by @seeker25 in #1314
• Fix error logging for payment jobs. by @seeker25 in #1316
• Fix batch limit for AP refunds. by @seeker25 in #1318
• 18468 - EFT Credits / Model updates by @ochiu in #1315
• 18510 - Add extra step to set transactions to REFUNDED if billable = 'f' by @seeker25 in #1321
• 18423 - REPORT-API CFS New Requirement Update by @AbrahamRostampoor in #1322
• 18439 - EFT Short name mapping endpoints support by @ochiu in #1323
• EFT Reconciliation by @ochiu in #1320
• 10680 - Changes to allow account fees to be removed all at once. by @seeker25 in #1324
• Bump aiohttp from 3.8.5 to 3.8.6 in /queue_services/payment-reconciliations by @dependabot in #1325
• 18584 - Fix paybc changes. by @seeker25 in #1326
• 18730 - Add invoice id to EJV description, because it doesn't show up in flow thr… by @seeker25 in #1327
• 18756 - Raise business exception on invoice creation if cfs account is frozen. by @seeker25 in #1329
• 18574 - EFT Verification Fixes by @ochiu in #1328
• Bump aiohttp from 3.8.6 to 3.9.0 in /queue_services/payment-reconciliations by @dependabot in #1330
• Bump cryptography from 41.0.4 to 41.0.6 in /jobs/ftp-poller by @dependabot in #1334
• Bump cryptography from 41.0.4 to 41.0.6 in /queue_services/payment-reconciliations by @dependabot in #1332
• Bump cryptography from 41.0.4 to 41.0.6 in /jobs/payment-jobs by @dependabot in #1333
• Bump cryptography from 41.0.4 to 41.0.6 in /pay-api by @dependabot in #1331
• 18767 - Add in new sequence column via model, migration and job. by @seeker25 in #1335
• 18767 - Update requirements.txt for payment-jobs by @seeker25 in #1336
• Add in unit test for Truth and reconciliation day, change holiday cod… by @seeker25 in #1337
• Revert "Add in unit test for Truth and reconciliation day, change holiday cod…" by @seeker25 in #1338
• 18790 - Use newer version of library for correct holidays - which include obs… by @seeker25 in #1339
• Update sbc-pay reference in payment-jobs. by @seeker25 in #1340
• 18762 - EFT automatically set statement frequency to monthly by @ochiu in #1343
• 18924 - Fix payment_date for Disbursements, EJV, PAD, ONLINE BANKING. Fix di… by @seeker25 in #1344
• Set invoice to CANCELLED instead of REFUNDED for EJV refunds, when th… by @seeker25 in #1345
• 18763 - default statement settings for EFT by @ochiu in #1347
• 18758 - refactor / update notebook jobs to support multiple partners by @ochiu in #1342
• Dockerfile config update by @ochiu in #1348
• 18758 - update readme, fix weekly report issue, update cronjob.yaml by @ochiu in #1349
• 18955 - Change invoice status for get invoices for disbursement to include CR… by @seeker25 in #1346
• Add in credited for disbursement_status by @seeker25 in #1350
• Add in lines that checks for CC invoices. by @seeker25 in #1351
• Bump paramiko from 3.2.0 to 3.4.0 in /jobs/ftp-poller by @dependabot in #1353
• Bump paramiko from 3.2.0 to 3.4.0 in /jobs/payment-jobs by @dependabot in #1352
• 18493 - EFT Statement updates by @ochiu in #1354
• 18493 - Update EFT statement generation by @ochiu in #1355
• 18014 - Update eft instructions by @rodrigo-barraza in #1356
• Add in additional indexes for DW. by @seeker25 in #1357
• Bump fonttools from 4.39.3 to 4.43.0 in /report-api by @dependabot in #1358
• 18681 - EFT GL Distribution supporting changes by @ochiu in #1378
• 17534 - NSF Implementation by @rodrigo-barraza in #1377
• Fix migration revision by @seeker25 in #1380
• 18681 - Update EFT TDI17 processing logic by @ochiu in #1379
• Bump pillow from 10.0.1 to 10.2.0 in /report-api by @dependabot in #1381
• 19162 - Payment Reconciliation NSF Implementation by @rodrigo-barraza in #1382
• Update requirements.txt by @rodrigo-barraza in #1383
• 17534 - nsf tweaks by @rodrigo-barraza in #1385
• 17534- Reconciliation tweaks by @rodrigo-barraza in #1386
• 18681 - EFT Transfer task job by @ochiu in #1387
• Sync db models with migration by @ochiu in #1388
• Bump aiohttp from 3.9.0 to 3.9.2 in /queue_services/payment-reconciliations by @dependabot in #1390
• 19336 - EFT Payment details by @ochiu in #1389
• 19336 - update eft transactions TDI17 processing by @ochiu in #1391
• 19331-EFT-Shortname-search by @ochiu in #1393
• 19330 - Add in branchName by @seeker25 in #1395
• 16467 - NSF Calculation Fixes and PDF Download by @rodrigo-barraza in #1396
• 19331 - EFT Shortname search by @ochiu in #1394
• 19331 - eft short name linking audit columns by @ochiu in #1398
• 19222 - Add other refund states to get routing slip route by @Jxio in #1397
• 19330-19333-EFT-shortname-search-updates by @ochiu in #1399
• 19330 eft shortname date range fix by @ochiu in #1400
• Bump cryptography from 41.0.6 to 42.0.0 in /jobs/ftp-poller by @dependabot in #1401
• Bump cryptography from 41.0.6 to 42.0.0 in /queue_services/payment-reconciliations by @dependabot in #1402
• Bump cryptography from 41.0.6 to 42.0.0 in /pay-api by @dependabot in #1404
• Bump cryptography from 41.0.6 to 42.0.0 in /jobs/payment-jobs by @dependabot in #1403
• 19673 - Create eft_staff role to access EFT shortname functionality by @Jxio in #1405

New Contributors

• @rodrigo-barraza made their first contribution in #1296

Full Changelog: v1.18.6...v1.20.8

v1.18.6

What's Changed

• Update dependencies. by @seeker25 in #1156
• Add in weekend check for CGI feeders. by @seeker25 in #1157
• 15961 - Add in fallback value for cfs_account if the user changes from PAD ->… by @seeker25 in #1158
• Get rid of HOLIDAYS_LIST. Otherwise we have to redefine it every year by @seeker25 in #1159
• Update requirements for jobs. by @seeker25 in #1160
• Update version.py by @seeker25 in #1161
• Create BCOL_NOTES.md by @seeker25 in #1162
• 16408 - pay-api: Exception on /api/v1/accounts/9789/statements/2047079 by @Jxio in #1173
• Lock holiday to 0.23 for now. by @seeker25 in #1174
• Bump requests from 2.28.2 to 2.31.0 in /pay-api by @dependabot in #1184
• Bump requests from 2.28.2 to 2.31.0 in /report-api by @dependabot in #1183
• Bump requests from 2.28.2 to 2.31.0 in /jobs/ftp-poller by @dependabot in #1182
• Bump requests from 2.28.2 to 2.31.0 in /queue_services/payment-reconciliations by @dependabot in #1181
• Bump requests from 2.28.2 to 2.31.0 in /jobs/payment-jobs by @dependabot in #1180
• Bump requests from 2.28.1 to 2.31.0 in /bcol-api by @dependabot in #1179
• Bump requests from 2.27.1 to 2.31.0 in /pay-admin by @dependabot in #1178
• Bump requests from 2.23.0 to 2.31.0 in /jobs/notebook-report by @dependabot in #1177
• Bump requests from 2.23.0 to 2.31.0 in /jobs/notebook-report/requirements by @dependabot in #1176
• 16458 - cast service_fee by @Jxio in #1175
• partial of the new queue service by @thorwolpert in #1185
• adding the vault for gcp-queue by @thorwolpert in #1193
• Bump tornado from 6.2 to 6.3.2 in /pay-api by @dependabot in #1186
• Bump cryptography from 40.0.2 to 41.0.0 in /jobs/payment-jobs by @dependabot in #1197
• Bump cryptography from 40.0.2 to 41.0.0 in /pay-api by @dependabot in #1196
• Bump tornado from 6.2 to 6.3.2 in /report-api by @dependabot in #1191
• Bump tornado from 6.2 to 6.3.2 in /bcol-api by @dependabot in #1189
• Bump tornado from 6.2 to 6.3.2 in /jobs/payment-jobs by @dependabot in #1187
• Bump tornado from 6.2 to 6.3.2 in /queue_services/payment-reconciliations by @dependabot in #1188
• Update DEVELOPER_NOTES.md by @seeker25 in #1198
• Bump cryptography from 40.0.1 to 41.0.0 in /queue_services/payment-reconciliations by @dependabot in #1195
• Change state to subdiv, also include observed holidays. by @seeker25 in #1199
• 16789 - Change _get_payment_account, so it doesn't fail when there are multip… by @seeker25 in #1201
• 16843 - Add in condition to not create NSF invoices if the account is already… by @seeker25 in #1202
• Update version.py by @seeker25 in #1200
• Update requirements.txt. by @seeker25 in #1203
• Add in config to override valid redirect url. by @seeker25 in #1204
• Bump cryptography from 41.0.1 to 41.0.2 in /queue_services/payment-reconciliations by @dependabot in #1208
• Bump cryptography from 41.0.1 to 41.0.2 in /jobs/ftp-poller by @dependabot in #1206
• Bump cryptography from 41.0.1 to 41.0.2 in /jobs/payment-jobs by @dependabot in #1207
• Bump cryptography from 41.0.0 to 41.0.2 in /pay-api by @dependabot in #1205
• Bump aiohttp from 3.8.4 to 3.8.5 in /queue_services/payment-reconciliations by @dependabot in #1209
• Fix deps - Small date time fixes for end of the month UTC issues by @seeker25 in #1220
• Fix deps part2 by @seeker25 in #1221
• Bump cryptography from 41.0.2 to 41.0.3 in /jobs/payment-jobs by @dependabot in #1224
• Bump cryptography from 41.0.2 to 41.0.3 in /queue_services/payment-reconciliations by @dependabot in #1225
• Bump cryptography from 41.0.2 to 41.0.3 in /jobs/ftp-poller by @dependabot in #1222
• Rollback get_first_and_last_dates_of_month - small dep fix by @seeker25 in #1226
• 17529 - Remove isPremium check from CSV export. by @seeker25 in #1235
• Update version. by @seeker25 in #1236
• 15687 - Pay remove restx by @ochiu in #1234
• update requirements dependency for pay-api by @ochiu in #1247
• 17477 - Correct overwriting at footer of Online Banking Payment Invoice by @Jxio in #1248
• 17477 - documents footer fix by @Jxio in #1249
• Update and rename pay-api-1.0.3.yaml to pay-api-1.0.4.yaml by @seeker25 in #1250
• 17828 - EFT - A start on some of the database model changes. by @seeker25 in #1255
• 17829 - Implement summary route for statements. by @seeker25 in #1256
• 5857 - Add in new eft_instructions. by @seeker25 in #1257
• Bump cryptography from 41.0.3 to 41.0.4 in /queue_services/payment-reconciliations by @dependabot in #1254
• Bump cryptography from 41.0.3 to 41.0.4 in /pay-api by @dependabot in #1253
• Bump cryptography from 41.0.3 to 41.0.4 in /jobs/ftp-poller by @dependabot in #1252
• Bump cryptography from 41.0.3 to 41.0.4 in /jobs/payment-jobs by @dependabot in #1251
• Fix conditional check for oldest_overdue_date by @seeker25 in #1269
• Fix deps by @seeker25 in #1270
• Add in fields back to the response for CSO. by @seeker25 in #1258
• 17829 - Add in new is_overdue flag by @seeker25 in #1271
• Bump pillow from 9.5.0 to 10.0.1 in /report-api by @dependabot in #1272
• 17828 - initial EFT file processing models by @ochiu in #1273
• 17827 - initial TDI17 file retrieval setup by @ochiu in #1274
• 17830 - EFT TDI17 Parser by @ochiu in #1275
• Add in the two dates that were missing. by @seeker25 in #1276
• 17836 - PAY-API Added Invoice Reference Number to the csv export by @AbrahamRostampoor in #1277
• 17836 - pay api transaction id by @AbrahamRostampoor in #1278
• 17831 - EFT Monthly Statement by @ochiu in #1279

New Contributors

• @thorwolpert made their first contribution in #1185
• @ochiu made their first contribution in #1234
• @AbrahamRostampoor made their first contribution in #1277

Full Changelog: v1.18.5...v1.18.6

v1.18.5

What's Changed

• 15467 - Statement enhancements, remove duplicates - fix the sort order in pay as well. by @seeker25 in #1135
• Add in db.session.flush() by @seeker25 in #1139
• 15197 - Models _mapping for service backwards compatibility by @seeker25 in #1140
• Add in line to print out invoice id. by @seeker25 in #1141
• Adding in developer notes by @seeker25 in #1138
• Small fix for payment reconciliation for online banking. by @seeker25 in #1142
• Statement weekly fix by @seeker25 in #1144
• Add in data for no fee, add in details field for credits, update developer notes. by @seeker25 in #1143
• Performance tweak statements by @seeker25 in #1145
• Bump sentry-sdk from 1.9.10 to 1.14.0 in /pay-api by @dependabot in #1150
• Bump sentry-sdk from 1.11.1 to 1.14.0 in /bcol-api by @dependabot in #1146
• 15699 - Changes to accomodate 3 tiers of service fees in BCOL. by @seeker25 in #1151
• Cast to float by @seeker25 in #1152
• New columns for pay-admin. by @seeker25 in #1153
• PAY-JOBS - Use the latest version of pay-api. by @seeker25 in #1154
• 15719 - Skip EJV Disbursement / Payment on holidays by @seeker25 in #1155

Full Changelog: v1.18.4...v1.18.5

v1.18.4

What's Changed

• bcol refund fix float/decimal conversion by @kialj876 in #1104
• add in additionalProperties for Invoice object. by @seeker25 in #1116
• 14850 - allow basic accounts access to transaction route by @Jxio in #1103
• 14850 - Unit test for basic account - transaction screen by @Jxio in #1117
• Fix for bcol logging. by @seeker25 in #1119
• Use decimal instead of float. by @seeker25 in #1118
• Update enums.py by @seeker25 in #1120
• To fix all notebook reports Sent but not delivered Issue#2247 by @stevenc987 in #1123
• Fix for BCOL + missing fields. by @seeker25 in #1125
• Fix additionalProperties. by @seeker25 in #1126
• 14847 - AP non-gov disbursement for BCA. by @seeker25 in #1122
• Remove time check in task, just do this via CRONTAB instead. by @seeker25 in #1128
• 15257 - Fix statements serialization issue by @seeker25 in #1115
• Change auth_account_id to accountId.. by @seeker25 in #1129
• 15467 - Allow statements job to have a date override by @seeker25 in #1130
• 15467 - Statement performance optimizations, also weekly / monthly weren't wo… by @seeker25 in #1131
• 15387 - invoices table enhancement by @Jxio in #1124
• 15467 - Revert requirements.txt. by @seeker25 in #1132
• AP disbursement changes + statement tweak. by @seeker25 in #1133
• 15257- Fix for exception not coming back correctly. by @seeker25 in #1134
• 15467 - Statement enhancements, remove duplicates - fix the sort order in pay as well. by @seeker25 in #1135
• Add in db.session.flush() by @seeker25 in #1139
• 15197 - Models _mapping for service backwards compatibility by @seeker25 in #1140
• Add in line to print out invoice id. by @seeker25 in #1141
• Adding in developer notes by @seeker25 in #1138
• Small fix for payment reconciliation for online banking. by @seeker25 in #1142

Full Changelog: v1.18.3...v1.18.4

v1.18.3

What's Changed

• Add try except for create_cfs_account. That way if it fails it doesn'… by @seeker25 in #1084
• enhancements added to transactions history by @kialj876 in #1085
• Fix null details. by @seeker25 in #1086
• Add transistion to complete. by @seeker25 in #1088
• 15086 - Add in registration in process_event. by @seeker25 in #1087
• Create job to schedule reports - invoice reconciliation #14945 by @stevenc987 in #1089
• Fix lint errors. by @seeker25 in #1090
• Fix rs correction api by @seeker25 in #1091
• Enable the AP refund reconciliation always. by @seeker25 in #1092
• Bump cryptography from 39.0.0 to 39.0.1 in /jobs/payment-jobs by @dependabot in #1095
• Bump cryptography from 36.0.1 to 39.0.1 in /jobs/ftp-poller by @dependabot in #1093
• Bump cryptography from 38.0.3 to 39.0.1 in /pay-api by @dependabot in #1094
• 15276 - Add in SQL to load in test data for pay. by @seeker25 in #1097
• added indexes on invoice ref table by @kialj876 in #1096
• 15290 - Search optimizations. by @seeker25 in #1098
• Fix invoice count by @seeker25 in #1099
• Sorting fix + pad activation date fix. by @seeker25 in #1100
• Change subquery, so it excludes some of the outer joins, only adds if… by @seeker25 in #1101

Full Changelog: v1.18.2...v1.18.3

v1.18.2

What's Changed

• Skip over certain corp types for queue messages. by @seeker25 in #1068
• Create job to schedule reports - invoice reconciliation #14945 by @stevenc987 in #1069
• Create job to schedule reports - invoice reconciliation #14945 by @stevenc987 in #1078
• Create job to schedule reports - invoice reconciliation #14945 by @stevenc987 in #1079
• backend updates for transaction table by @kialj876 in #1071
• 14618 - Fix from feedback, casting float to Decimal. by @seeker25 in #1077
• Missing str for decimal by @seeker25 in #1080
• Adding in pylint to requirements.txt, renaming the CI name. by @seeker25 in #1081
• Bump future from 0.18.2 to 0.18.3 in /jobs/notebook-report by @dependabot in #1074
• Bump future from 0.18.2 to 0.18.3 in /jobs/notebook-report/requirements by @dependabot in #1073
• 14618 - Routing Slip job changes for Corrections by @seeker25 in #1082
• 15161 - Add in change for invoice.disbursment_date by @seeker25 in #1083

Full Changelog: v1.18.1...v1.18.2

v1.18.1

What's Changed

• allow job to run with more than 1000 records to update by @kialj876 in #1058
• 14346 - update CfsReceiptStatus by @Jxio in #1059
• 14346 add receipt status check before sending reverse request by @Jxio in #1060
• 14507 - added a column of FOILO and change FEE CODE to PRODUCT CODE by @Jxio in #1061
• 14507 - Convert UTC to PDT/PST by @Jxio in #1062
• 14618 - PAY-API changes for routing slip corrections - Part 1 by @seeker25 in #1063
• 12777 - System Exit 1 / Performance fixes for Invoice searching, also statement building by @seeker25 in #1065
• 14618 - add CORRECTION.value to RoutingSlipStatus by @Jxio in #1066
• Skip over sending queue message for CSO payments. by @seeker25 in #1067

Full Changelog: v1.18.0...v1.18.1