[Sage Accounting API oAuth issue - Authorise Application Error]

Hi Rishiom,

The fix has now been deployed and the problem client_id's are now working.

Thanks for your patience.

Mark

[Sage Business Cloud Accounting Prestashop integration]

Hi Daniela,

Sage Business Cloud Accounting exposes public API's to provide integration ability to third party software solutions. https://developer.sage.com/accounting/reference/.

Looking through our integrators on Sage Marketplace there is one product stating it is integrating with Prestashop and Sage Business Cloud Accountinghttps://uk-marketplace.sage.com/en-GB/home. Wether this specific integration provides the functionality you are looking for would be something you would need to determine.

Thanks

Mark

 

[Sage Accounting API oAuth issue - Authorise Application Error]

Hi Rishiom,

The deployment of the fix will happen tomorrow afternoon(07/02/2024) GMT

Thanks

Mark

[Tax incorrectly calculated?]

Thanks Alexandre,

This is the bug section for our API's used by our integrators. 

Thanks

Mark

[Sage Accounting API oAuth issue - Authorise Application Error]

Hi Rishiom,

We are aware of an issue with generated client_id guid's which are failing to pass a regex in our auth service. It sounds as if this could be the issue for yourself.

We're hoping to push a fix live today 06/02/2024 to resolve the issue.

If you DM me with the client_id you're using i'll be able to check if this is the issue.

Thanks

Mark

[Malformed request when creating an invoice]

Hi Ray,

Thank you for your post. You've posted in the General lobby without mention of the Sage product you are integrating with.

If you can provide the name of the product and information relating to the error we'll be able to help/guide you better.

Thanks

Mark

[Tax incorrectly calculated?]

Hi Alexandre,

Thank you for your post. 

This community supports integrators of Sage products with issues, requests and ideas. Product related questions have a greater visibility to our product managers and users in the Sage City community - https://communityhub.sage.com/

Thanks

Mark

[Sage50 Accounts (UK) - PO invoicing via SDK]

Hi Garima,

Thanks for your post. You'll need to contact [email protected] for Sage 50 UK SDK support. 

Thanks

Mark

[SBCA - Units column from invoices to show on sales reports.]

Hi Dane - Thank you for your post.

The feature requests submitted here relate directly to our external API's.

This sounds more like a product feature request which would be more widely seen by our product managers in https://communityhub.sage.com/gb/sage-business-cloud-accounting/

Thanks

Mark

[Problem posting sales credit note]

If you can send me the business ID in a DM i'll take a look.

Do you mean the contact is in Singapore or the business the contact belongs to?

 

[Problem posting sales credit note]

Hi Reg,

Thanks for your question.

If this is a UK business, the main_address will be required if the contact does not have an address set and the business is registered for UK VAT.

Thanks

Mark

[Error in GET Error in GET 422 - [{"$severity":"error","$dataCode":"RecordInvalid","$message":"is not included in the list","$source":"line_items.tax_rate"},{"$severity":"error","$dataCode":"RecordInvalid","$message":"must be 'Zero Rated' for Customers ou]

Hi,

Thanks for your question.

Can you confirm that the business you are posting this for is registered in Spain and provide the address of the contact. Feel free to DM me if you don't wish to make the details of the customer public.

 

Thanks

Mark

[Create Product API error "product_sales_price_type_id is invalid"]

Hi,

Thank you for your question.
 

The sales_prices need to include a valid product_sales_type_id as per the below example.

The product_sales_price_type_id's can be returned via GET https://api.accounting.sage.com/v3.1/product_sales_price_types
 

{
	"product": {
		"description": "22\" Monitor",
		"sales_ledger_account_id": "e37adfa38e6311ecbccd06255bbcbb57",
		"purchase_ledger_account_id": "e37c57448e6311ecbccd06255bbcbb57",
		"item_code": "MON004",
		"sales_tax_rate_id": "GB_STANDARD",
		"usual_supplier_id": "9d4fd4da8949435fa6e11a2c40536983",
		"purchase_tax_rate_id": "GB_STANDARD",
		"cost_price": "45",
		"sales_prices": [{
			"price_name": "Sales Price",
			"price": "80",
			"price_includes_tax": false,
			"product_sales_price_type_id": "ba1045fbfdbc45d5a6c591a1a4baeebd"
		}]
	}
}

Thanks

Mark

[Sage Accounting API is outputting HTML as an error code]

Hi,

Thank you for your post. Can you provide the request you're sending including the body and the full response please.

The response looks to be from AWS rather than our API. We'll need to know the AWS request_id in the response to raise a service ticket with them. 

Thanks

Mark

[Sage Accounting Categories API]

Hi,

Thank you for your post. At present the API does not expose Product Categories.

Thanks

Mark

[Integration with Sage50]

Hi Brijesh,

Were you unable to obtain a response from [email protected]?

Thanks

Mark

[Query regarding LIVE data within a developer setup]

Thanks Ross,

Sage 50 isn't currently a supported product in this community at present.

If you direct your question to [email protected] they'll be able to support you if you're a member of the UK developers program.

Alternatively Sage Community Hub offers lots of guidance for Sage 50. https://communityhub.sage.com/gb/sage-50-accounts/f/general-discussion-uk

Thanks

Mark

[Query regarding LIVE data within a developer setup]

Hi Ross,

Thank you for your question. You've posted in the general forum which is not linked to one specific Sage Product.

Could you provide us with the name of the Sage Product and region your question is targeted at please.

Thanks

Mark

[Please provide Sample C#.NET application to connect Sage Businessworks 2023]

Hi Sarvesh,

Thank you for your question.

Sage Business Works is not a product that is currently supported in this community. 

There are some posts and resource lins available in the Sage City community that may help you.  https://communityhub.sage.com/us/sage_businessworks/f/announcements/197799/announcing-sage-businessworks-2023-release

Thanks

Mark

[How to Link invoice and credit note using Sage API]

Hi Raghu,

The contact_allocation would need to be deleted in order to un-allocate the invoice and credit. The contact_allocation created from the above example is 19ef656e02a64d0eb8c0c06fb6fc87a4 so I would need to pass the below request to un-allocate.

DELETE https://api.accounting.sage.com/v3.1/contact_allocations/19ef656e02a64d0eb8c0c06fb6fc87a4

Thanks

Mark

[Sage 50 SDK Type library registration problem]

Hi Patrick,

The Sage 50 SDK for the UK is not a supported product in this community at present. If you direct any Sage 50 related queries to [email protected] they'll be able to help you with your questions.

Thanks

Mark

[How to Link invoice and credit note using Sage API]

Hi Raghu,

The transaction type = CUSTOMER_ALLOCATION. I've included an example body below where 387a3153269143aa9555ce8ad377eea2 = sales_invoice_id and 17ade05ce4674040a0742578308c20c0 = sales_credit_note_id.

The credit value needs to be signed -.

https://developer.sage.com/accounting/reference/payments/#tag/Contact-Allocations/operation/postContactAllocations

{
  "contact_allocation": {
    "transaction_type_id": "CUSTOMER_ALLOCATION",
    "contact_id": "2f0a9bdd56a548ffbac9380eba27ac19",
    "date": "2023-12-07",
    "allocated_artefacts": [
      {
        "artefact_id": "387a3153269143aa9555ce8ad377eea2",
        "amount": "162.25"
      },
      {
        "artefact_id": "17ade05ce4674040a0742578308c20c0",
        "amount": "-162.25"
      }
    ]
  }
  }

Thanks

Mark

[test data issues or possible bug?]

Hi Andreea, 

It looks as if the dates on the opening_balance transactions are later than the Accounts Start Date hence the 422 response. 

The solution is to change the Accounting Dates in the UI or amend the initial PUT request in the collection to change the Accounts start date to 01/01/2022 and the year end date to 31/12/2023

Thanks

Mark

[How to Link invoice and credit note using Sage API]

The example we have in the guide(attached) uses the contact_allocations API. You are creating an allocation and do not require the contact_payment API.

The example refers to the credit value of a payment on account but this could be any credit value(including a credit note) on the customer account. 

You need to pass in the amount being allocated as well as the sales_invoice id and sales_credit_note id in the allocated artefacts array. The amount can only be as large as the highest amount outstanding on either artefact. For example the SI outstanding amount = 10 and the SC outstanding amount = 20 the largest amount possible to allocate is 10.

Thanks

Mark

[How to Link invoice and credit note using Sage API]

Hi Raghu,

The credit note needs to be allocated to the invoice in order to mark the invoice as paid.

Our payments guide provides further details of how this can be achieved in the Allocating contact artefacts section. https://developer.sage.com/accounting/guides/concepts/payments/ 

Thanks

Mark