• Power BI Errors

    I have linked our Sage 200extra account which runs on a remote server with Power BI. It works sometimes at refreshing data but 90% of the time is returns the below errors. The refresh tends to work on in query editor but basically never in the data view…
  • Sage 200 creates a new record in the Database after changes data

    Hello Team, I use Sage 200 API to receive data and sync them with my application. For receiving AR documents I use the following endpoint - api.columbus.sage.com/.../sales_transaction_views But, I detected that when I change the Invoice, Credit…
  • Error during the Online Card Receipt

    Hello Team, I know that you are busy, so I'll be brief. Could you help me with the following issue? I tried to create an Online Card Receipt in Sage 200. But Sage returns the following error message: Could you clarify which settings I should apply…
  • Filter $skip doesn't work for method sales_transaction_enquiry_views

    Hello Team, Could you help me with the following issue? I am using the method sales_transaction_enquiry_views to receive transaction allocations. Example: https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sales_transaction_enquiry_views?$filter…
  • Invoice PDF via API from Sage 200

    Hello Team, Could you clarify please, is it possible to receive Invoice PDF via API from Sage 200? If yes, could you provide the link to the API specification? Or maybe you could recommend another way how to receive an Invoice PDF for the integration…
  • Receiving removed Account Receivable entities via API

    Hello Team, During the official documentation, I cannot find an endpoint that allows receiving removed Account Receivable entities (customers, invoices, payments, etc.). How I can receive removed Account Receivable entities via API? Could you provide…
  • Time zone mismatch

    Hello Team, I have a question about the time zone mismatch. I found the following issue. To receive customers we use two endpoints: https://api.columbus.sage.com/uk/sage200extra/accounts/v1/customers https://api.columbus.sage.com/uk/sage200extra/accounts…