diff options
| -rw-r--r-- | python/report_ops/cash.py | 6 | ||||
| -rw-r--r-- | python/report_ops/custodians.py | 1 |
2 files changed, 4 insertions, 3 deletions
diff --git a/python/report_ops/cash.py b/python/report_ops/cash.py index 3d2ddab2..da8709c4 100644 --- a/python/report_ops/cash.py +++ b/python/report_ops/cash.py @@ -98,7 +98,9 @@ class SerenitasUMBCashReport( p = self.get_cash_report("umb_") df = pd.read_excel(p, skiprows=3) for row in ( - df.groupby(["Portfolio #", "Currency"]).sum()["Current Balance"].items() + df.groupby(["Portfolio #", "Currency"]) + .sum(numeric_only=True)["Current Balance"] + .items() ): self.stage_from_row(row) self.commit() @@ -119,7 +121,7 @@ class BowdstBNYCashReport( ) for row in ( df.groupby(["Account Number", "Local Currency Code"]) - .sum()["Beginning Balance Local"] + .sum(numeric_only=True)["Beginning Balance Local"] .items() ): self.stage_from_row(row) diff --git a/python/report_ops/custodians.py b/python/report_ops/custodians.py index b95def6e..b5c04ca5 100644 --- a/python/report_ops/custodians.py +++ b/python/report_ops/custodians.py @@ -188,7 +188,6 @@ class BNY(Custodian, account="BONY2"): date_part, "%Y%m%d%H%M%S" ).date() case _: - warnings.warn(f"Unknown report type {file_type}") continue p = DAILY_DIR / str(date) / "Reports" / fname if not p.parent.exists(): |