Welcome to the Sage 200 Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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…
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…
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…
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…
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…
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 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?
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…
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…
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…
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…