[Learning Sage 200's data model]

Hi Felipe,

It really depends on the method of integration you are using with Sage 200, is this via the .NET SDK or through the REST API?

Ben

[Table Extensions / Schema on 2023 r2 and 2024 r1]

Hi Chris,

I understand you are currently working with the team on this query, issues regarding the SDK aren't something we support on the forum.

Thanks,

Ben

[Sage 200 Standard 2024 R1 - release!]

Hi everyone, 

We're pleased to announce the release of Sage 200 Standard 2024 R1.

There are several new features and enhancements, check out the What’s New Datasheet for more.

Specifically for developers, we've added a number of new API endpoints and updated the Web screen component library, which you can find in the whats new post.

 

Ben

[Info on ui and objecty names]

Hi Che,

Currently we haven't got a list of all component ids, but you can use chrome dev tools to select the component and find its id in the HTML of the page.

 

Ben

[Could not load file or assembly]

Hi Hasan,

This query references the use of the Sage 200 SDK, which is licenced and support is provided to members of the UK Developer Programme. If you would like to be a member, or are already please forward this query to [email protected].

Thanks,

Ben

[Sage 200 Web Amenability - Virtual Developer Day - follow up]

Hi Nigel,

We aren't ready to announce anything just yet, and are currently looking at options and reviewing the feedback received to determine what content is best going forward. We'll be sure to pop an announcement on here + communicate it when we are ready.

If you have suggestions, or anything specific you'd like to see more of, by all means let us know.

Have a great Christmas and New Year,

 

Ben

[Generating API clients from the Accounting API Swagger]

Hi Tony,

Unfortunately not, due to various re-organisations we have different people working on different products now. Whilst I'm not currently working with Accounting, we have provided details of these requests and recommendations to the engineering teams. At this point I can't give you an ETA on it, but I've made the relevant people aware of your request again. 

 

Ben

[Sage 200 SDK]

Hi @Philip Walker,

There were some changes made to the licence requirements in 2023 R2. You will need to migrate your licence by completing this form. You will be provided with new details that should be used with the SDK tools.

Regards,

 

Ben

[Sage 200 SDK]

Hi Colin,

Thanks for your question - I see you've sent in a case to Developer Support so we will deal with the issue via email. 

For members of the UK Developer Programme that is still the preferred method for support. 

Regards,

 

Ben

[SDK forum?]

Hi Geoff,

This will be replacing the Sage 200 API forum that's part of the 200 club set up for members of the UK Developer Programme. Use of the 200 API is free, and we are keen to encourage discussion and engage with the developer community. 

The 200 SDK requires access to the UK Developer Programme, and is as a result kept private for members only. I  am looking at options to improve the experience of accessing and using it so that we can provide (as near as possible) a single location for all support, and discussion for developers and our tech partners.

I'd highlight that we've just released to the public the newly created Sage 200 UKI site here on the developer portal, available at developer.sage.com/200.

Thanks,

 

Ben 

[Welcome to the Sage 200 UKI Forums]

Hi all, 

Welcome to the newly added Sage 200 UKI forums for developers!

We are excited to offer developers and partners the opportunity to discuss and ask questions about the Sage 200 UKI API, and the soon to be released Web Screen Amendability features.

Sage staff will also be monitoring these forums to offer answers and support.

[Sage CRM Rest API - $type does not show GET Email or GET Phone]

Hi,

In general, the best place to post about Sage CRM is on their specific community forum - Forums - Sage CRM - Sage City Community

However, I'm looking into this for you and working with your Business Partner to get an answer for you.

 

Ben

[Show discount value on SOP/ Invoice layoout]

Hi Mihaela, 

As this isn't a developer query I'd need you to re-ask this over on Sage City, which is where our product support is handled. A specialist in report design should be able to help you.

Sage 200 UKI - Sage City Community

Thanks

 

Ben

[Analysis Types Issue]

Hi Andrew, 

Are you seeing the analysis types array on the lines for each invoice in your response? Regardless of if its empty?

 

Ben

[Announcement - New virtual event: Sage Dev Stream Oct 28th 2021]

Hi Nigel,

Apologies for the delay getting back to you on this. 

There isn't anything official in the works at the moment that I'm aware of, but we'll be sure to update you via the community of any further events.

 

Ben

[Has the ODBC Driver for v29 Sage50 Changed? Failing with Filemaker Pro]

Hi Colin,

Thanks for notifying us of this, we have had another report of the same. 

It doesn't seem as though we have made any changes to the 64 bit ODBC driver in v29 other than the addition of some new fields.

The ODBC driver is however an unsupported and externally untested method of integration, so there is always a risk to using it for integrations. 

I'm in communication with the engineering teams about this, but cannot promise we'll be able to provide any further assistance, but I'll certainly try, and update you should I have more.

 

Ben

[Unattended / Confidential Client OAUTH integration to Sage 200 API]

Hi Aaron,

You can essentially have a connection to the UKI 200 API unattended using the refresh token to maintain it. During the initial setup, manual login must be provided as part of the oauth process, but after that, the access token can be refreshed indefinitely and without the need for manual intervention. 

Is this what you need to confirm?

 

Ben

[VAT Return including invoices from outside the period requests]

Hi Matt,

This is more of a general support query - and I'd advise you to contact our Accounting support teams directly, but you should see a dialogue like this:



That allows you to determine if you want to have those previous transactions included in the return or not. It's likely in real world scenarios where older invoices/transactions are added after the VAT return has been calculated, reconciled and submitted for the period they should be in. It's perfectly acceptable to include them in the next period's return.

 

Ben

[Cloud accounting - configurable product support.]

Hi,

At present the Plus variant of Accounting allows you to create and update products (stock and non-stock) and services. There isn't the option to create specific variations of each record, you would need to just create a new record for each configured variation.

I'll forward on your suggestion to the product management team as a suggestion for the future.

 

Ben

[Looking for Freelance Sage developers]

Hi Ali,

It's not something we really provide a platform for, the only other community area we have is Sage City (United Kingdom & Ireland - Sage City Community) which you could ask on too.

 

Ben

[C# Winforms Trouble Getting Autorization Code]

Hi Riley,

I've replied to your email directly, but as we don't currently have one available, and for anyone else looking for an example of a desktop app connecting - the example Google provide here named 'OAuthDesktopApp' should help with the Oauth initiation from a form (WPF or WinForms should work here). The code example specifically can be found in the MainWindow.xaml.cs file. 

googlesamples/oauth-apps-for-windows: OAuth for Apps: Samples for Windows (github.com)

Ben

 

[Rest API - for HR - Get Employess Data]

Hi Venkat,

The only thing I can think of is via the Apiary powered version of our API reference for Sage HR, available here: Sage HR API · Apiary 

If you scroll down on the console panel on the right you can see some code examples, and one of the available options is via Java:

An example of the code sample:

I hope this helps!

 

Ben

 

[Changing date range in the Customer "Activity" report does nothing.]

Thanks for bringing this to our attention, I'll be sure to pass your feedback to the product team.

Ben

[Update Products via CSV - Sage Cloud]

Hi Helen, 

Can you confirm is this Sage Business Cloud Accounting you are referring to?

 

Ben

[Sage 300 Windows 2020 SDK Devleopment]

Hi Prajkta,

I'd recommend as per Develop for Sage 300 (Global) | Sage Developer to contact [email protected] as she can assist in how to join the developer programme and how support will work for 300.

Thanks,

 

Ben