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

[raghu Chaudhary]

I am trying to add my invoice to sage Using Sage API, but its giving me these errors -

"Please select the EU Goods/Services on each item line.",
"is not included in the list",
"All items on this Sales Invoice must have the same EU Goods/Services type."

Can anyone please tell me the cause of these errors & how to resolve them?

Thank You

[Steel, Mark]

Hi Raghu,

Thank you for your post.

There's a lot of validation involved with EU sales and many variables. If you can let me know the following I'll be able to help you further:

• The country/location of the business(the province or state if US/CA)
• The taxation scheme of the business
• The customers location (presuming this is a sales_invoice)
• If the customer is registered for tax (business to business transaction)
• The type of items being sold(goods or services)

Thanks

Mark

[raghu Chaudhary]

• The country/location of the business(the province or state if US/CA)  -  UK
• The taxation scheme of the business  -  We are using GB_STANDARD , GB_EXEMPT etc
• The customers location (presuming this is a sales_invoice)  -  Bulgaria
  If I change Bulgaria to UK it syncs but does not work with Bulgaria.

[Steel, Mark]

Thanks @raghu Chaudhary,

Goods and services sold from a VAT registered UK business to the EU need to report the transactions via the EU Sales List Report.
https://www.gov.uk/guidance/vat-exports-dispatches-and-supplying-goods-abroad

Goods and services sold to the EU fall in to different classifications and potentially different VAT rates. When creating a sales_invoice for an EU customer each line item must be classified with either Goods or Services but you cannot have a mix of both. You would need to create separate sales_invoice's for this scenario.

The JSON body should resemble the below.

{
    "sales_invoice": {
        "contact_id": "4dc963f0c3284f9cbdebd31b569597cd",
        "date": "2024-04-04",
        "reference": "API EU Inv",
        "invoice_lines": [
            {
                "description": "Goods item line",
                "ledger_account_id": "7a5ecfcf884911ed84fa0252b90cda0d",
                "unit_price": "100",
                "quantity": "2",
                "tax_rate_id": "GB_ZERO",
                "eu_goods_services_type_id":"GOODS"
            },
            {
                "description": "Another goods item line",
                "ledger_account_id": "7a5ecfcf884911ed84fa0252b90cda0d",
                "unit_price": "10",
                "quantity": "50",
                "tax_rate_id": "GB_ZERO",
                "eu_goods_services_type_id":"GOODS"
            }
        ]
    }
}

Thanks

Mark

[raghu Chaudhary]

We are sending goods like this- 

{
                    "sales_invoice": {
                        "contact_id": "5ce966c9b90d4892be42455469ed80c3",
                        "currency_id": "GBP",
                        "exchange_rate": "1",
                        "date": "2024-04-02",
                        "reference": "INV05",
                        "main_address": {
                            "address_line_1": "Porik Nedelcho Bev 6",
                            "address_line_2": "Soia",
                            "city": "Sofia",
                            "postal_code": "1528",
                            "country_id": "GB"
                            },
                            "invoice_lines": [{
                                        "description": "Add colums to reports",
                                        "ledger_account_id": "871fd84253d94834545448deb015a2237d",
                                        "quantity": "1",
                                        "unit_price": "120",
                                        "tax_rate_id": "GB_EXEMPT",
                                        "tax_amount": "0",
                                         "eu_goods_services_type_id":"GOODS",
                                        "discount_percentage": "0",
                                        "discount_amount": "0"
                                    }],
                              "due_date": "2024-04-03",
                              "net_amount": "120.00",
                              "total_amount": "120.00",
                              "total_quantity": "1"
                      }
                  }

All invoice lines are goods here but we are getting these errors-

"is not included in the list","$source":"line_items.tax_rate"},

"must be 'Zero Rated' for Customers outside the EU.","$source":"line_items.tax_rate"}]

And why is it saying EU when our business settings have UK.

Thank You

Edited April 5 by raghu Chaudhary

[Steel, Mark]

Thanks @raghu Chaudhary,

The error message is informing you of the issue. The tax_rate_id applicable for this item line is GB_ZERO. GB_EXEMPT is an invalid tax_rate_id for sales of goods to the EU for VAT registered businesses. - "must be 'Zero Rated' for Customers outside the EU.","$source":"line_items.tax_rate"}]

Thanks

Mark

[Reginald Jackson]

Are all these rules documented somewhere, please?

[Steel, Mark]

Hi @Reginald Jackson,

The rules aren't documented per se as this is legislation and rules stipulated by HMRC. A lot the legislation came about during brexit and the subsequent EU VAT Reform. 

We have articles and guides relating to those changes which introduce the tax_determinations API https://developer.sage.com/accounting/reference/taxes/#tag/Tax-Determinations. This has a number of query params that can be passed and will return the tax_rates which are valid based on the params passed.

For example here we have a UK Vat registered business and an EU customer, we can pass the usage type which is sales, and the contact_id for example:
GET https://api.accounting.sage.com/v3.1/tax_determinations?usage=sales&contact_id=4dc963f0c3284f9cbdebd31b569597cd
 

This returns the below response of which there is only one tax_rate_id returned:

{
    "$total": 1,
    "$page": 1,
    "$next": null,
    "$back": null,
    "$itemsPerPage": 20,
    "$items": [
        {
            "id": "GB_ZERO",
            "displayed_as": "Zero Rated 0.00%",
            "$path": "/tax_rates/GB_ZERO"
        }
    ]
}

https://developer.sage.com/accounting/guides/eu-vat-reform/
https://developer.sage.com/accounting/guides/brexit/
 

Thanks

Mark