Steel, Mark

Hi Joshua, Thank you for your question. Can you confirm the following please: The location of the business you are attempting to create the invoice for The location inc state/province if in NA of the selected customer How you are obtaining the tax_rate_id Thanks Mark

Thanks Norman, I can replicate the issue and also resolve it by adding "tax_amount": 0.00 to the third invoice_line. Can you recall when this first started occurring? Thanks Mark

Hi Stuart, Thank you for your question. We have no experience of using the Sage Business Cloud Accounting API's within Power Automate or Power Automate directly. The access_token lasts for 5 minutes and then it needs to be refreshed by exchanging the refresh_token for a new set of tokens (access and refresh) as per the auth guide. The response of the request is then returned to the callback Url's that you have registered against your application in the app registry The message you are seeing indicates that the access_token used in the header is invalid. Is there a default callback URL Power Automate uses and how have you implemented the maintaining of the access_token within Power Automate? Have you registered the Power Automate callback Url in the app registry? Thanks Mark

Hi Norman, Thank you for your question. We're currently looking into this after it was reported Adding a tax_amount of 0.00 resolved the issue in this case. Could you provide us with the full body you were sending in the request please Norman.

Hi, the Bank Feeds in SBCA are not exposed by an API. It may be worth your while enquiring in the https://developer-community.sage.com/forum/37-banking-service/ lobby as this relates to the Banking Service consumed by Sage Business Cloud Accounting. Thanks Mark

You would only need to pass an exchange_rate when using a currency_id different to the base currency of the business and you would never be setting the currency_tax_amount in the invoice_line only the tax_amount. It also looks as if you're trying to pass the tax_rate_id of a sales tax_rate and not that of a purchase. To obtain a list of valid tax rates you can query the tax_rates API using the usage query paramater - tax_rates?usage=purchase&address_region_id=CA-BC. The address_region_id should be that of the registered business for purchases and the address_region_id for sales needs to be that of the customer. { "purchase_invoice": { "contact_id": "9bb46a4136e64b36819f34f6a7f75952", "date": "2023-04-20", "due_date": "2023-05-20", "reference": "Internal Reference", "vendor_reference": "Vendor reference", "invoice_lines": [ { "description": "cf85707a-5081-4251-ba0d-c96d142ff717", "unit_price": 125, "quantity": 329, "tax_amount": 4935, "ledger_account_id": "b4e9d889381d11ecbcc60e97dc3b579b", "tax_rate_id": "CA_GST_PST_BC" } ] } } Thanks Mark

This looks to be the response of a GET request for a purchase_invoice/bill. You ideally need to start with some requirements for the integration in terms of the fields that you wish to update the purchase_invoice/bill with. What fields are you wishing to edit for the Bill? https://developer.sage.com/accounting/reference/invoicing-purchases/

You ideally need to start with some requirements for the integration in terms of the fields that you wish to update a contact with. The ID's that you are passing are system generated and returned when a contact is created, you would see the ID's in the 201 response for the PUT request. The API's are used across different regions and tiers of SBCA and not all of the attributes returned for a record are applicable for every region or tier. I would start by building out your PUT request using a body containing parameters referenced in the docs and add to it as per your integration requirements.

This looks to be the response of a GET request for a contact. You ideally need to start with some requirements for the integration in terms of the fields that you wish to create a new contact with. The ID's that you are passing are system generated and returned when a contact is created, you would see the ID's in the 201 response for the POST request. The API's are used across different regions and tiers of SBCA and not all of the attributes returned for a record are applicable for every region or tier. I would start by building out your POST request using a body containing parameters as below. You can then refer to the docs and add to it as per your integration requirements. { "contact": { "name": "Customer 0b2cf704-bb66-42bb-914f-9e89d6033376", "contact_type_ids": ["CUSTOMER"], "reference": "JH4", "default_sales_ledger_account_id": "b4e9c1f1381d11ecbcc60e97dc3b579b", "locale": "en-CA", "currency_id": "CAD", "main_address": { "address_line_1": "4331 Forbidden Plateau Rd", "address_line_2": "", "city": "Courtenay", "region": "BC", "postal_code": "V9J 1R2", "country_id": "CA", "is_main_address": true }, "main_contact_person": { "contact_person_type_ids": ["SALES", "PURCHASING", "ACCOUNTS", "DELIVERY"], "name": "Railz Dev", "telephone": "", "mobile": "", "email": "", "fax": "", "is_main_contact": true, "is_preferred_contact": true } } } Thanks Mark

Hi, Thanks for your question, can you provide us with the request body you are sending please. Thanks Mark

Hi, Thanks for your question, can you provide us with the request body you are sending please. Thanks Mark

Thanks for the information, we'll look into it. For clarification, the body you posted at the start of the thread is the actual request you are making?

"Here in docs, it is said that if omitted it will be automatically set to "0" which we were doing up until now, but it seems that something changed and this field is now required. " - When did you notice this change in behaviour? The SBCA API's supported here are intended to be used across 6 different regions CA, ES, FR, IRE, UK and US. Within these countries there are many different tax rules and rates which encompass many different business types and taxation treatments which add up to many thousands of different permutations. The API reference should be treated as a guide, as different fields and values will become required for different configurations. For example, if you create a Sales invoice for a UK VAT registered business and the contact selected does not have an address set but has a tax_number set against it, the request would fail if you did not provide the address in the sales_invoice body. For Canadian businesses how do you establish if they collect taxes in the region/province you are creating the sales_invoice for? Are you providing the user with a UI to select from the appropriate rates or are you presuming that the transaction always uses a tax_rate of CA_NO_TAX? Thanks Mark

Hi Shaldon, Thank you for your question. The only report available via the API's is a trial balance. The reports you require are available from the Sage Business Cloud Accounting UI which is accessible via a mobile device. https://developer.sage.com/accounting/ - The API's documented here are suitable for SBCA in CA, ES, FR, IRE, UK and US. Thanks Mark

Hi ,thanks for your question. The business in question must be set to collect taxes for this region/province and needs to see the tax_amount. { "sales_invoice": { "contact_id": "479b90167950499c80ef3abd8a89f9bd", "date": "2023-03-29", "tax_address_region_id": "CA-QC", "invoice_lines": [ { "description": "Some service 1", "service_id": "7896d5025d92423b85db7c821efc488f", "ledger_account_id": "3c65c506bda911eda8c40ef4cf562701", "quantity": "1.0", "unit_price": "25.0", "tax_amount": "0.0", "tax_rate_id": "CA_NO_TAX" } ] } } Thanks Mark

@Lahiru Hewa Rajage - The behaviour has now been improved to provide the tax_amount when setting the unit_price_includes_tax attribute to true.

Hi, thanks for your question. Sage 300 is not a supported product on this community. If you reach out to our North American colleaugues at [email protected] they'll be able to locate the best person to help you. Thanks Mark

Hi, thanks for your question. Sage 300 is not a supported product on this community. If you reach out to our North American colleaugues at [email protected] they'll be able to locate the best person to help you. Thanks Mark

Hi, Thanks for your question. The GUID's you refer to are required only in the DB and are of no value outside of SBCA hence they're not shown or provided in the UI or export tool. If you require the ID's, you'll need to export the data using the API's available. Thanks Mark

Hi Dean, Sage Data Objects is applicable only to the UK version of Sage 50 Cloud Accounts. SDO is a very low level access component that represent the flat files db structure of Sage 50. There will be very little or none of that code that can be reused with SBCA. Thanks Mark

Hi Andrew, We experienced a live issue with the Authentication service which was resolved at approx 4pm 20/03/2023. The issue did not effect the exchange of refresh_tokens and was problematic for new auth requests. Apologies for any inconvenience this may have caused. Thanks Mark

Hi Stefan, This issue is now resolved. Apologies for any inconvenience caused. Thanks Mark

HI Stefan, Your problem maybe to do with an ongoing issue with our auth Server. The issue looks to be related to the authenticating of businesses recently provisioned and does not appear to affect applications which are currently maintaining an access_token. If you can provide the below information relating to your business that would be helpful: Business info Required Business Name Email Address used to access the Sage Business Cloud Accounting Business The Date the business was created The region(CA, ES, FR, IRE, UK, US) the business was created for Thanks Mark

Hi Fraser, Thank you for your question. If the business is associated with a Stripe account you should see the payment link in the sales_invoice response body as per the below response. "href": "https://accounts-extra.sageone.com/advanced_uk/online_payment/. "links": [ { "href": "https://accounts-extra.sageone.com/invoicing/sales_invoices/43e95187a15b47bcbc5872549ed69078", "rel": "alternate", "type": "text/html" }, { "href": "https://accounts-extra.sageone.com/advanced_uk/online_payment/gba25967de2129e9d659ca7c3e01efa563dd4dae73158332757a2ba89d9563588f65f9df632a42d56b87213cf9d6a579532a825c5b8639f72a9c184127456f3503ad4a6a3b8229086df787cfc253a513369c3201940365ea9385f4e3c28e", "rel": "bookmark", "type": "text/html" } ], Thanks Mark

Hi Guillaume, Thank you for your question. At present the French product integration support is handled by the below two individuals. [email protected] [email protected] Thanks Mark