Ben Smith

Hi Chris, Thanks for bringing this to our attention. I'll investigate and let you know what I find, if required I'll update you once I've fixed it and updated the site to reflect the changes. Ben

Hi Reginald, Just wanted to let you know its something we are considering, but I can't confirm if or when that will likely happen at this stage. I'll update you should I hear more. Ben

This is interesting, I'll see what I can find out and let you know! Ben

Hi Reginald, Apologies for the delay in getting back to you. The only way at present I can see this working is if your customer's user is only going to be using your application, if authentication is handled during initial setup by the admin, then subsequently you maintain the connection via the refresh token - anyone that uses your app after that should be able to do so without ever knowing the credentials required to log in and access the Sage Business Cloud Accounting (SBCA) business. Obviously this depends upon how you are handling multiple users of your app and if they are required to sign into SBCA when they start a session. Ben

Hi Aladin, This is most likely because you are passing the attributes and values as query params. You need to ensure you build a JSON body as per our API reference, passing the values accordingly, along with a header of Accept: application/json: Purchase Transactions | Sage Developer { "purchase_invoice": { "contact_id": "string", "date": "2019-08-24", "due_date": "2019-08-24", "reference": "string", "total_quantity": 0, "net_amount": 0, "tax_amount": 0, "total_amount": 0, "invoice_lines": [ ... ], "tax_analysis": [] } } Once you've had a look at the guide I've linked above it should make sense. Let me know if you still have any issues. Ben

Hi Dave, Hope you are well. I've done some testing and can see that you can do exactly what you are asking within the UI but not via the API. I will be reporting this to be investigated. In my tests is seems that regardless what you do via the API the logic appears to only take note of the net amount, the tax id and then calculate the tax amount. I'll see what I can do about this and let you know once I have more, or if I end up raising it as a bug. Ben

Hi Reginald, I will do some checking to see if this is something a) we have and b) we can publish - as it would be really helpful to have further detail on these error messages and even recommendations on how to fix them available. I'll update this post with more if I have anything to share. Ben

Glad you've got this working ok Sylvain 🙂 Yes as a rule the first time someone with the available permissions to authenticates with an app they will be asked to authorize that the application can access the business, once that is allowed the connection is present in the apps section of the UI settings. Ben

Hi Andrew, That is not one I've seen before! How did you enter the invoices? Via the API? If so can you provide me with the JSON body you used to make the POST request? I can then do some testing. Ben

Hi Reginald, The country hasn't any publicly exposed details available at present. Ben

Hi Reginald, Thank you for the very detailed response, this makes sense now. As you are currently logged into the SolutionJ business, when you go to connect via your application to the Aardvark business, the cached session is used, authentication is already completed and the tokens returned are for the currently authenticated user logged into that business. Have you have found that there are circumstances where a user of your application will also need to be logged into Accounting in a separate business with different credentials? I'll investigate the business ids and see if there's anything else I can suggest. Ben

Hi Daniel, I'll reach out via a private message - I'll need some further details in order to check our logs. Ben

Hi Reginald, I see now from this post you are correctly using the X-Business header, so disregard my reply in the other forum. It would be best to try and keep this thread in one place though, so if you can do that going forward that would be great. Can you advise further on how you have been simulating the refresh token expiry? Removing the connected app from inside the Web app UI will revoke the grant on all active tokens. Ben

Hi Reginald, Unfortunately we don't have the analysis types available via the API yet. It is something we have provided a lot of feedback to the engineering teams about, and hope that we can offer it in the future. I don't as yet have an ETA on its availability though, please accept my apologies. Ben

Hi Reginald, Authentication with Accounting is a little different to how others do it. When you authenticate, you are authenticating as a specific user, and will subsequently be granted a token that is valid for use in all businesses that user has been granted access to. It is therefore vital that you are using the /businesses endpoint to obtain the id of the business you are interested in, and pass that as a value with the X-Business header. That header routes any requests to that specific business. Depending on the email address used in your scenarios if its the email address that created the business, that business is its 'lead business' and is, in the absence of any X-Business header, the one it will default to. So if you use a secondary email that has been invited to this business, if that second address also created another business, it will always default to its 'lead business' (without an X-Business header) which may well be not what you are expecting. What I'd ask is that if you can test this again ensuring you pass the appropriate business id with the X-Business header when accessing the different accounts and see how you find it? I'd also recommend having a look at our Best Practices | Sage Developer guide, which covers the use of multi business. I hope that helps, Ben

Hi Robert, Sorry for the delay in getting back to you - can you confirm which region the account is in? This could well be a legacy sub, and isn't to my knowledge one that you can get anymore. Ben

Thanks for letting me know, if you decide to revisit this please get in touch. Ben

Hi Colet, The version of Sage Business Cloud Accounting available in South Africa is a different product, and requires the use of a different API. As such there is a different site available to give you details etc. to get started. You can find the pages here: Developer API - Sage Business Cloud Accounting | Sage South Africa The page has links to register your app for use with this API, details on the auth process and a full API specification. I hope that helps, Ben

When the response is received are you getting a 200 OK, then saving the response as a file of type .pdf? Can you attempt this process outside of your application using something like Postman to achieve the same?

Hi, Welcome to the community! Can you provide me with the headers you are passing with this request please? Ben

Hi Kelvin, Good to hear you've completed an integration with Sage Business Cloud Accounting! When it comes to the Sage 50cloud Accounts SDO, that has different capabilities that are relevant to features in 50cloud Accounts and shouldn't be compared to the SBCA REST API. I'd recommend contacting our UK Developer Services team on [email protected] and provide them with your use case. They will be able to clarify if the SDO is capable of what you are looking to achieve. I hope that helps, Ben

Thanks for posting this Bob, I'm others will have/will do this so it being here will help! Glad you have it resolved. Ben

Hi Andrew, We have a ticket logged with our engineering team on this one, there are other codes that need to be added too. We'll chase this one up and see if we can get an idea of how quickly we'll have this one resolved for you. Ben

Hi Andrew, So there's more to the consideration on this one that I expected, and have escalated this request through our Product Management to see if/where this could be added to the roadmap. In case I get further questions on it, you specifically want to be able, when making a POST request for any bank related transaction, to mark it as reconciled, correct? If what I'm reading is correct, the concern there would be how would you, at the point of POST which reconciliation the tran would be included in? This would normally be something that you'd do at the end of a month or statement period. So is the ask to be able to make a subsequent PUT request later on to update that information? Thanks! Ben

Yes, I'll reach out to you via direct message - as a developer we can extend your trial for 12 months free of charge. Ben