[All items on this Sales Invoice must have the same EU Goods/Services type. API error]

Are all these rules documented somewhere, please?

[Exporting Options from Sage 50]

Hi. Are you aware that you can set up your own exports? You just need to choose a query tool and then, via odbc, your entire Sage database can be read.

If you don’t have Excel, then there are plenty of other tools around, some of them free - Libreoffice for example.

cheers

Reg

[Problem posting sales credit note]

Mark,

If it helps, the contact in question had been inactive, but was then made active again?

Cheers

Reg

[Problem posting sales credit note]

Hi Mark,

It’s not a UK business (Singapore) and the contact does have an address.

Cheers

Reg

[Problem posting sales credit note]

HI,

One of my customers is unable to post a particular sales credit note through the api (having posted many before). They're getting a 422 response code and this error:

[{"$severity":"error","$dataCode":"RecordInvalid","$message":"This field is required.","$source":"main_address"}]
 

Has anyone seen this before? I've not had to supply the main_address field before, so I can't understand why this has come up.

Cheers

Reg

[Integration with Sage50]

The Sage50 SDK requires you to sign up to what is, in my opinion, an overly-expensive developer subscription....

[Sage 50 SDO hanging on Login]

Hi. Are you using a Sage login that is not being used by anyone else?

[Regional Versions]

Hi Mark. I received the invite, and accepted it, but then the same screen came up saying I would get a verification code, and that still hasn't come through.

I have also read and takend on board the email you sent.

Many thanks

Reg

[Regional Versions]

I am. I have set up email address [email protected] specifically just to do this. Yes, it's a signup for Spain.

[Regional Versions]

Hi Mark,

I'm trying to set up a trial using the link you provided, but I just cannot seem to get an email verification code sent through. Is there some sort of validation on which domains are allowable?

Cheers

Reg

[Regional Versions]

Many thanks Mark.

 

Cheers

Reg

[Regional Versions]

I have a customer that currently uses the UK-region product (I still know it as SageOne), but they are now starting a business in Spain. Is there a version of SageOne for use by Spanish businesses, and if so is the API common to both?

Cheers

Reg

[How to apply an overall discount to a Sales Invoice created via API]

Ok, thank you.

[How to apply an overall discount to a Sales Invoice created via API]

Hi,

I am also trying to post discounts at line level, but I'm using the discount_percentage field rather than discount_amount, but it seems the APi is ignoring it?

Cheers

Reg

[Strange API problem]

Hi Mark,

Thanks, I have now resolved the issue.

 

cheers

reg

[Strange API problem]

Hi,

While retrieving / looping through a list of contacts (specifically Suppliers), I'm getting a JSON error:

It's not happening on the first contact, I've proven that, so I can only assume there's nothing inherently wrong with my code. I can't find much information about this error. Can anyone shed any light?

Cheers

Reg

[API Access for non-users]

Ok, thanks Ben.

[API Access for non-users]

👍

[API Access for non-users]

Thanks Ben. I've seen that this problem is universal, i.e. not just for SBCA, and it's an inherent weakness in the Oauth2 concept in my opinion. Some api suppliers are addressing it under the heading of M2M (machine to machine) access, and it would be interesting to know if SBCA are looking into this as well?

 

Cheers

Reg

[API Access for non-users]

One of my customers wants to have an admin resource use my application to create and post sales and purchase invoices into SageOne, but they do not want that person to have the ability to log into SageOne itself. Given the way the initial authorization process works can anyone suggest how can this be done?

Cheers

Reg

[Error messages]

Thanks Ben. I remembered reading about certain system-generated customers and suppliers, HMRC repayment for example. I used this supplier in my application as a supplier when generating test data. It dawned on me that posting to these suppliers might be disallowed, and that's what it was. I've now excluded contacts with system = true from use in my application.

Cheers

Reg

[Error messages]

I'm getting an error message when trying to add a purchase invoice. Is there a list available of these messages and what they mean?

I don't mean the response codes (201 etc), I mean the actual specific messages that are returned if an api call is rejected.

The message I'm getting is "Saving Purchase Invoice failed: value of contact was not allowed".

Cheers

Reg

[EU Membership]

Ok Ben, thanks

[Authorisation Question]

Ah, ok 🙂

[Authorisation Question]

Your client will have to authorise it for themselves sylvain, i.e. by logging into Sage under their own email address...