API problem (bug suspected: wrong function called?)

1

Summary:

(a) Is there an endpoint to show current balances for balance accounts (and also for profit-and-loss accounts)? Or some other way to retrieve that information through the api?

(b) Isn’t there a bug in that the endpoint balance-sheet-transactions actually shows only starting balances, whereas there is already an endpoint balance-sheet-account-starting-balance-list for exactly that?

Background:

I am trying to use the api2 to retrieve the current amount held in balance accounts.

I know that with the endpoint bank-and-cash-accounts I get a list of all bank and cash accounts with their balances, and I was hoping for something like balance-sheet-accounts to do the same for balance accounts, I could not find it. Does an endpoint like that exist?

Now about what seems to be a bug to me: In looking for a solution I tried balance-sheet-transactions and I found, not my answer, but a very strange result. This is the first part of the result in my case:

{
    "business": {
        "name": "my business”
    },
    "skip": 0,
    "pageSize": 50,
    "totalRecords": 26,
    "balanceSheetTransactions": [
        {
            "edit": null,
            "view": null,
            "date": “”,
            "transaction": "Starting balance”,
            "account": null,
            "bankOrCashAccount": null,
            "expenseClaimPayer": null,
            "customer": null,
            "supplier": null,
            "employee": null,
            "inventoryKit": null,
            "inventoryItem": null,
            "investment": null,
            "fixedAsset": null,
            "intangibleAsset": null,
            "capitalAccount": null,
            "specialAccount": null,
            "description": null,
            "tax": null,
            "qty": null,
            "purchaseCost": null,
            "unitCost": null,
            "transactionAmount": null,
            "currencyAmount": null,
            "debit": {
                "value": 23507.34,
                "currency": “EUR”
            },
            "credit": null,
            "balance": null
        },

with more of the same to follow.

What seems to be a bug to me, is that it only shows “Starting Balance” transactions and no other. And indeed, the amounts shown are starting balances.

So, why would an endpoint labeled balance-sheet-transactions show starting balances, and nothing else? Whereas there is an explicit endpoint balance-sheet-account-starting-balance-list that gives what looks to be exactly the same result? Looks to me this endpoint is pointing to the wrong function.

2

Hi @lubos,

I am working on an extension that will import CAMT.052/CAMT.053 files, that will create not only payments and receipts, but also, with a bit of configuration, also inter account transfers and even some journal entries. This should be of considerable benefit to many users I think.

As a bonus, I would like to automate bank reconciliation. What I need for that, and cannot find, is a way through the API to retrieve the current balance of all accounts, not only bank and cash accounts. (The reason for that being that some of the accounts my financial provider holds and reports on are properly modeled as non-bank assets but still should be reconciled.)

Is there an endpoint, analogous to bank-and-cash-accounts that will give me access to such information?

Thanks!

PS In the process of investigation, I found what I think is a bug in the API. See API problem (bug suspected: wrong function called?)