Sage 200 UKI

I am trying to query the Nominal_period_value_view in the SageAPI using Power BI but I am getting the below error; DataSource.Error: Web.Contents failed to get contents from ' api.columbus.sage.com/.../Nominal_period_value_views (400): Bad Request Details…

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…

Hi guys, Our team are looking for an Excel Add-in Tool to help with hundred of lines of Journals Posting for Sage 200C on premise. We will like the Enforcement of Username when posting Journals and Business rules which can be maintained inhouse. …

So from the Sage200 Extra documentation I can create a new SOP with an array of lines by submitting a POST request to {{URL}}/sop_orders . I can update existing lines using a PUT request to the url {{URL}}/sop_orders/id . I can delete a line by added…

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…

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…

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…

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…

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…

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…

Hi, I'm trying to post a sop_order via the Sage 200 API, passing the sop_order_lines and nominals. The sop_order and sop_order_lines are successfully created, but the nominal reference/cost centre and department do not set as per the values passed…