Sage 200 UKI

Hello Any help would be amazing, Im trying to find out if its possible to do a stock update via the API (increase and decrease stock levels against specific Skus) im really struggling to find where to do this can anyone help please

I have a problem posting an SOP to api.columbus.sage.com/.../sop_orders It comes down to tax_code_id. We have products that are either Standard Rated ( VAT @ 20%) or Zero Rated (0%) When I post an order with lines that have products that are Standard…

Hi, Against a purchase order line you can assign a cost centre. I can't see this in the Pop_order_line_views API endpoint and cannot see a way of linking to other endpoints to retrieve it. i can go from Pop_order_line_views. pop_order_line_analysis_code_1…

Hi, the API documentation discusses that field nominal_analysis_items is returned when querying endpoint sales_transaction_enquiry_views. but it doesnt seem to return. is there a way to get this data? thanks Gareth

How can we authenticate with the API, from the context of a Job or server? We have a bespoke CRM, and want to have a job that will create & update and accounts within it into Sage automatically. Is this even achievable with the product? The only…

One of the clients I am working with for my company is switching to Sage 200. They want me to integrate Salesforce with Sage. Does Sage 200 have a api with a REST endpoint that I can make requests against without having to register for the developer program…

Hi all, I'm having an issue getting/refreshing my access token with Sage. The issue is that when I run my code I get the following error: Error getting access token: 403 - Forbidden. I know that 403 errors are usually linked to a lack of permissions…

Hi all, We have a customer who uses Sage 200c and would like to access the data via the API - do we need to sign up to the developer's program as per this documentation - https://developer.sage.com/200c/guides/developer-keys/ ? We only need to read…

Hello Team, Could you clarify, is it possible to integrate data from Sage 200 using access to the database?

Is it possible to create quotation on Sage 200 Extra API (via Postman)? I have no exposure/experience on Sage 200 so I'm relying on Sage docs which unfortunately not the best out there. I can get quotes according to https://developer.columbus.sage.com…

Hi, We're trying to integrate Sage 200 REST API with our .NET 5 API. We don't want the user to login via the browser so I'm asking if machine to machine authentication is possible.

We currently use Sage 200 Cloud and the Sage APIs to feed in data from our bespoke ERP system. We post an average of about 800 receipts a day, prior to invoices being raised, and therefore there are tens of thousands of unallocated receipts, even though…

I get this 400 error when trying to update a customer_contact via the API. PUT /customer_contacts/xxxx { "first_name": "John", "last_name": "Doe", } [ "Nullable object must have a value." Any ideas?

When i use the $select query variable with quantity columns on warehouse_holdings the quantity columns are simply not returned api.columbus.sage.com/.../warehouse_holdings?$expand=product&$select=id,quantity_in_stock,quantity_allocated,product { id…

I get this message on submission of so far only two orders out of hundreds "The selected item is inactive and cannot be used for this process" I've checked the products are active and the account isn't on hold Supposedly a user was able to submit…

Hi, I work for a company that produces a piece of business software that can be configured to export invoices & credit notes to a company's (our customer) accounts package. We have a number of customers who use various versions of Sage, including Line…

We're developing a web application to push data to hosted Sage 200 API - all is setup, but we're looking to generate authorization tokens for this, and the URL we would hit doesn't appear to be documented anywhere. The Spanish version shows us the process…

Hi All, I would like to install the Sage 200 API but I cannot install Asp.Net 4.5 because that will disturb my environment (Windows 10 Pro, Asp.Net 4.7) which is shared with other application, and that will cost me time to configure the other application…

Hi, I am working with a team to develop a web and mobile front end for an organisation running on on premise solution of Sage 200c. They upgraded to the 2018 version of Sage and we are using this documentation as guidance for integration via APIs: developer…

Hello, I am trying to insert Sales order using Sage 200 UK extra API's. I am able to do that successfully. But, I want to map the few fields with it and for that I want your help. I want to map the following screenshots fields using the API. From…