• Sage 200 Developer Community

    If you're a Sage Developer, there's a separate forum for all things related to Sage 200 Web Amendability, the API and SDK. Developer Community >
  • Sage 200 Professional API

    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
  • Posting Zero Rated products into SOP endpoint

    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…
  • Purchase Order lines Nominal code via API

    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…
  • Sage 200 to power BI connector data missing

    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 to use the API from a job/server context

    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…
  • Sage 200 Api Access Clarification

    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…
  • Please supp the client credentials grant type on your API

    More and more customers are wanting coupled integration with Sage 200 / Standard using the API from their e-commerce sites so this is getting to be an urgent requirement for a lot of developers. This then requires a service to written to get orders…
  • Sage 200 API

    Can a Journal entry endpoint be added to the Sage 200 API for standard and professional?
  • 403 Error when trying to get/refresh access token

    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…
  • Sage 200 API - Better expose the invoicing module via the API

    Currently we can get invoice line items from the customer_sop_invoice_credit_line_views endpoint, however this only includes the line item description if the line item is for a Stock Item, but not if it is for Free Text, Charge or Comment. Additionally…
  • Sage 200 API - change the way the licensing works so we can have more then one developer on a 365 license being able to develop using the API

    We are looking to try and get our developers using the API rather the SDK, but we cannot progress with this due to the complex nature of the setup of the API, and also the restriction to only have one log in in our 365 subscription being able to develop…
  • Sage 200c API access

    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…
  • Allow the prefilled name to be changed on the Azure Application Proxy Installer

    Is it possible for Sage to allow us to manually set the Contacts Name and Native Name within the Azure Application Proxy Installer? The installer prefills in the Name and URL but if it only prefilled in the URL and not the name, we wouldn't have this…
  • Add purchase_allocation API endpoint

    It's currently not possible to allocate purchase ledger transactions against each other through the Sage 200 API. It's possible to do this in the software, and it's possible to do this on the Sales Ledger via the API (with the /v1/sales_allocations…
  • Is it possible to integrate data from Sage 200 using access to the Sage database?

    Hello Team, Could you clarify, is it possible to integrate data from Sage 200 using access to the database?
  • Create Quote in Sage 200 Extra API

    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…
  • Machine to machine authentication with Sage 200

    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.
  • Automatic sales receipt allocation (API)

    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…
  • Contact Update via API "Nullable object must have a value."

    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?
  • SOP_Order_Delivery_Address Dropshipping customers

    Telephone number and Email are not included in the SAGE API, SOP_Order_Delivery_Address. I think that is interesting enabling these fileds as a lot of customers are doing dropshipping and dleivery address is always different. For example if you want…
  • API warehouse_holdings $select not working correctly

    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…
  • Error on API Sales order submission

    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…
  • Sage 200 Standard API - Post Full Sales Invoice

    I Need the functionality in the Sage 200c Standard API to post a Full Sales Invoice with Invoice Lines. The Invoice would then return the Sage generated Invoice number and will display in the Invoice List in Sage 200c Standard UI. The existing functionality…
  • API Developer Keys and Subscription

    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…