We're using an API endpoint called GeneralLedgerBalanceV2 to fetch the account balance for each account over the course of a year, as we need this data for some calculations. However, when querying for a specific period (eg, 202301), we're receiving multiple values for the same account. To handle this issue, we've implemented logic to select the balance value based on the lastModifiedDateTime, assuming that the most recent value is the most accurate. However, we're unsure if this approach is correct. Additionally, we've already configured the parameters to request balanceType as 'actual'. Example Response (part of it) for more context: [ { "balanceType": "Actual", "financialPeriod": "202301", "beginningBalance": 11241.3100, "yearToDateBalance": 13234.5200, "yearClosed": false, "lastModifiedDateTime": "2023-04-01T08:38:46.443", }, { "balanceType": "Actual", "financialPeriod": "202301", "beginningBalance": 0.0000, "yearToDateBalance": 0.0000, "yearClosed": false, "lastModifiedDateTime": "2021-08-05T08:08:35.283" }, { "balanceType": "Actual", "financialPeriod": "202301", "beginningBalance": 0.0000, "yearToDateBalance": 0.0000, "yearClosed": false, "lastModifiedDateTime": "2023-09-15T10:22:15.217" } ]
... View more