Andrew Chaplin

This is my output at journal line level: "id": "e500f2f7a29f487cb2fb44c75e464fb2", "ledger_account": { "id": "284a76e9f70c428aade8e1d4fd9aeb04", "displayed_as": "Basic Salaries - Direct (6000)", "$path": "/ledger_accounts/284a76e9f70c428aade8e1d4fd9aeb04" }, "details": " LS Leeds Basic Salariies ", "debit": "71304.54", "credit": "0.0", "include_on_tax_return": false, "tax_reconciled": false, "cleared": false, "bank_reconciled": false, "journal_line_foreign_currency": { "currency_debit": null, "currency_credit": null, "exchange_rate": null } },

Hi Mark Thank you for your prompt response. The difficulty i am having is the API reference says i should be getting the analysis breakdown by journal line but i'm not. I think i am missing a parameter but not sure what. I am calling https://api.accounting.sage.com/v3.1/journals?attributes=all&items_per_page=200 Best Andrew

Journal entries, what is the endpoint and parameters to extract analysis data per transaction

Hi Ben No not seeing the array at all. Can see on individual invoice requests though. Andrew

Hi Excellent news that we are now able to see analysis types on transactions. We are able to return analysis details on a transaction when we read using the transaction id but not when we read a range of transactions. As below: https://api.accounting.sage.com/v3.1/sales_invoices?attributes=all&from_date=2023-01-02T16:56:05Z&show_analysis_types=true What are we doing wrong? Best Andrew

Hi Mark Excellent news as this was a weakness previously. We can return analysis details on a transaction when we read using the id but not when we read a range of transactions. As below: https://api.accounting.sage.com/v3.1/sales_invoices?attributes=all&from_date=2023-01-02T16:56:05Z&show_analysis_types=true What are we doing wrong? Best Andrew

When i use the path in the transaction types for corrections i get a path not available error??

Multiple deleted transactions still showing deleted=false on Transaction endpoint

Hi Mark Thank you for your response. JSON below. The screen i was viewing is customer transactions and i made sure no filters were on. The Sage interface was displaying correctly, it is the API that has the extra transaction:

I am seeing a record in the transaction table that doesn't show in the live Sage system. I assumed this mean't it was deleted but the deleted flag is showing as false on the api data. Any ideas?

Hi I am struggling to find the link between COA accounts and transactions. Can someone help please? Andrew

Hi Mark Thank you for your help. Andrew

Hi, How do you match payments/credits to invoices (transactions) using the API?

Why is my Refresh token expiring before 31 days?