codat test
-
Posts
9 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Articles
Downloads
Gallery
Posts posted by codat test
-
-
I also changed the property name as you suggested but still getting he same response.
{ "Id": "a47ccf7e05b64c3682617a6dca046f26", "DisplayedAs": null, "Transaction": null, "CreatedAt": null, "UpdatedAt": null, "DeletedAt": "0001-01-01T00:00:00", "InvoiceNumber": null, "ContactName": null, "ContactReference": null, "Contact": null, "ContactId": "cc80e0fb747e4ddaab743d778d04ec4a", "Date": "2021-07-01T00:00:00", "DueDate": "2021-07-31T00:00:00", "Reference": null, "MainAddressFreeForm": null, "MainAddress": { "Id": "37415aa11e8a4d379b423d961181cd15", "Name": null, "DisplayedAs": "1st Street\nJacksonville FL 0081\nUnited States", "$path": null, "AddressType": null, "AddressTypeId": null, "address_line_1": "1st Street", "address_line_2": null, "City": "Jacksonville", "Region": "FL", "PostalCode": "0081", "Country": null, "CountryId": null, "CountryGroup": null, "CountryGroupId": null }, "DeliveryAddressFreeForm": null, "DeliveryAddress": null, "Notes": null, "TermsAndConditions": null, "ShippingNetAmount": null, "ShippingTaxRate": null, "ShippingTaxAmount": null, "ShippingTaxBreakdown": null, "ShippingTotalAmount": null, "NetAmount": 0, "TaxAmount": 0, "TotalAmount": 0, "TotalPaid": null, "OutstandingAmount": 0, "Currency": null, "CurrencyId": "GBP", "ExchangeRate": 1, "BaseCurrencyShippingNetAmount": null, "BaseCurrencyShippingTaxAmount": null, "BaseCurrencyShippingTaxBreakdown": null, "BaseCurrencyShippingTotalAmount": null, "TotalDiscountAmount": null, "BaseCurrencyTotalDiscountAmount": null, "BaseCurrencyNetAmount": null, "BaseCurrencyTaxAmount": null, "BaseCurrencyTotalAmount": null, "BaseCurrencyOutstandingAmount": null, "Status": null, "Sent": false, "VoidReason": null, "InvoiceLines": [ { "Id": null, "DisplayedAs": null, "Description": "US Customer - PUT", "Product": null, "LedgerAccount": null, "LedgerAccountId": "9a994b92267a11e797950a57719b2edb", "Quantity": 10.0000000000, "UnitPrice": 10.0000000000, "NetAmount": 0, "TaxRate": null, "tax_rate_id": "GB_ZERO", "TaxAmount": 0.00, "TaxBreakdown": null, "TotalAmount": 100.00, "BaseCurrencyUnitPrice": null, "BaseCurrencyNetAmount": null, "BaseCurrencyTaxAmount": null, "BaseCurrencyTaxBreakdown": null, "BaseCurrencyTotalAmount": 0, "EuGoodsServicesType": null, "Service": null, "ServiceId": null, "ProductId": null, "DiscountAmount": 0, "BaseCurrencyDiscountAmount": null, "DiscountPercentage": null, "EuGoodsServicesTypeId": "SERVICES", "EUSalesDescriptionId": "ZERO" } ], "TaxAddressRegion": null, "WithholdingTaxRate": null, "WithholdingTaxAmount": null, "BaseCurrencyWithholdingTaxAmount": null, "LastPaid": null } -
Hi Mark,
When I update the invoice with the same object but with an EU customer its works and sets the correct Tax provided. So I'm not sure were this is going wrong.
Regards,
Abraham
-
Hi Mark,
Thanks for your response. Yes the business is located in the UK. Please find the full body below:
{"SalesInvoice": {"Id": "a47ccf7e05b64c3682617a6dca046f26","DisplayedAs": null,"Transaction": null,"CreatedAt": null,"UpdatedAt": null,"DeletedAt": "0001-01-01T00:00:00","InvoiceNumber": null,"ContactName": null,"ContactReference": null,"Contact": null,"ContactId": "cc80e0fb747e4ddaab743d778d04ec4a","Date": "2021-07-01T00:00:00","DueDate": "2021-07-31T00:00:00","Reference": null,"MainAddressFreeForm": null,"MainAddress": {"Id": "37415aa11e8a4d379b423d961181cd15","Name": null,"DisplayedAs": "1st Street\nJacksonville FL 0081\nUnited States","$path": null,"AddressType": null,"AddressTypeId": null,"address_line_1": "1st Street","address_line_2": null,"City": "Jacksonville","Region": "FL","PostalCode": "0081","Country": null,"CountryId": null,"CountryGroup": null,"CountryGroupId": null},"DeliveryAddressFreeForm": null,"DeliveryAddress": null,"Notes": null,"TermsAndConditions": null,"ShippingNetAmount": null,"ShippingTaxRate": null,"ShippingTaxAmount": null,"ShippingTaxBreakdown": null,"ShippingTotalAmount": null,"NetAmount": 0,"TaxAmount": 0,"TotalAmount": 0,"TotalPaid": null,"OutstandingAmount": 0,"Currency": null,"CurrencyId": "GBP","ExchangeRate": 1,"BaseCurrencyShippingNetAmount": null,"BaseCurrencyShippingTaxAmount": null,"BaseCurrencyShippingTaxBreakdown": null,"BaseCurrencyShippingTotalAmount": null,"TotalDiscountAmount": null,"BaseCurrencyTotalDiscountAmount": null,"BaseCurrencyNetAmount": null,"BaseCurrencyTaxAmount": null,"BaseCurrencyTotalAmount": null,"BaseCurrencyOutstandingAmount": null,"Status": null,"Sent": false,"VoidReason": null,"InvoiceLines": [{"Id": null,"DisplayedAs": null,"Description": "US Customer - PUT","Product": null,"LedgerAccount": null,"LedgerAccountId": "9a994b92267a11e797950a57719b2edb","Quantity": 10.0000000000,"UnitPrice": 10.0000000000,"NetAmount": 0,"TaxRate": null,"TaxRateId": "GB_ZERO","TaxAmount": 0.00,"TaxBreakdown": null,"TotalAmount": 100.00,"BaseCurrencyUnitPrice": null,"BaseCurrencyNetAmount": null,"BaseCurrencyTaxAmount": null,"BaseCurrencyTaxBreakdown": null,"BaseCurrencyTotalAmount": 0,"EuGoodsServicesType": null,"Service": null,"ServiceId": null,"ProductId": null,"DiscountAmount": 0,"BaseCurrencyDiscountAmount": null,"DiscountPercentage": null,"EuGoodsServicesTypeId": "SERVICES"}],"TaxAddressRegion": null,"WithholdingTaxRate": null,"WithholdingTaxAmount": null,"BaseCurrencyWithholdingTaxAmount": null,"LastPaid": null}}Regards,
Abraham
-
Hi All,
Whenever I try to update an invoice from a EU to a non EU customer I get a validation error saying that the line item Tax rate must be Zero Related for customers outside the EU.
However I am providing the tax rate Id (GB_ZERO) in the payload but I'm still not having any luck. Please could you advise?
Error Messages:
- Tax rate is not included in the list
- Tax rate must be 'Zero Rated' for Customers outside the EU.
Payload (Invoice Line Item)
{ "sales_invoice":{ "invoice_lines": [ { "description": "Test Item Line", "quantity": "1.0", "unit_price": "100.0", "net_amount": "100.0", "tax_rate_id": "GB_ZERO", "tax_amount": "0.0", "ledger_account_id": "2c8ec978b3bb11ebb35d02665419b6eb", "eu_goods_services_type_id": "SERVICES" } ] } }Regard,
Abraham
-
Hi Mark,
Sorry it's me again. I have managed to figure out the issue. I was not setting the property "eu_goods_services_type_id" with the id . I was setting "eu_goods_services_type" with an object.
Thanks
Abe
-
Hi Mark,
Apologies, please find the Put Request below:
{"SalesInvoice": {"Id": "7313dda9bad04f6fb2aafcb74d8c1efb","DisplayedAs": null,"Transaction": null,"CreatedAt": null,"UpdatedAt": null,"DeletedAt": "0001-01-01T00:00:00","InvoiceNumber": null,"ContactName": null,"ContactReference": null,"Contact": null,"ContactId": "ccfe555153094837b97bdedbb715ca24","Date": "2021-06-24T00:00:00","DueDate": "2021-07-24T00:00:00","Reference": null,"MainAddressFreeForm": null,"MainAddress": {"Id": "30fa6562cd244d98b0c75a391c9581c1","Name": null,"DisplayedAs": "20 Estate Ave\nDrive Road\nCU DEW\nCuba","$path": null,"AddressType": null,"AddressTypeId": null,"address_line_1": "20 Estate Ave","address_line_2": "Drive Road","City": null,"Region": "","PostalCode": "CU DEW","Country": null,"CountryId": null,"CountryGroup": null,"CountryGroupId": null},"DeliveryAddressFreeForm": null,"DeliveryAddress": null,"Notes": null,"TermsAndConditions": null,"ShippingNetAmount": null,"ShippingTaxRate": null,"ShippingTaxAmount": null,"ShippingTaxBreakdown": null,"ShippingTotalAmount": null,"NetAmount": 0,"TaxAmount": 0,"TotalAmount": 0,"TotalPaid": null,"OutstandingAmount": 0,"Currency": null,"CurrencyId": "GBP","ExchangeRate": 1,"BaseCurrencyShippingNetAmount": null,"BaseCurrencyShippingTaxAmount": null,"BaseCurrencyShippingTaxBreakdown": null,"BaseCurrencyShippingTotalAmount": null,"TotalDiscountAmount": null,"BaseCurrencyTotalDiscountAmount": null,"BaseCurrencyNetAmount": null,"BaseCurrencyTaxAmount": null,"BaseCurrencyTotalAmount": null,"BaseCurrencyOutstandingAmount": null,"Status": null,"Sent": false,"VoidReason": null,"InvoiceLines": [{"Id": null,"DisplayedAs": null,"Description": "Updating line item","Product": null,"LedgerAccount": null,"LedgerAccountId": "9a994b92267a11e797950a57719b2edb","Quantity": 1.0000000000,"UnitPrice": 100.0000000000,"NetAmount": 0,"TaxRate": null,"TaxRateId": "GB_ZERO","TaxAmount": 0.00,"TaxBreakdown": null,"TotalAmount": 100.00,"BaseCurrencyUnitPrice": null,"BaseCurrencyNetAmount": null,"BaseCurrencyTaxAmount": null,"BaseCurrencyTaxBreakdown": null,"BaseCurrencyTotalAmount": 0,"EuGoodsServicesType": {"Id": "SERVICES","DisplayedAs": null},"Service": null,"ServiceId": null,"ProductId": null,"DiscountAmount": 0,"BaseCurrencyDiscountAmount": null,"DiscountPercentage": null}],"TaxAddressRegion": null,"WithholdingTaxRate": null,"WithholdingTaxAmount": null,"BaseCurrencyWithholdingTaxAmount": null,"LastPaid": null}} -
Hi Mark,
Thanks for quick response.
- The business sending the invoice is based in the UK. - Yes
-
The business sending the sales invoice is registered for VAT - Yes
-
The delivery address of the sales contact:
"Address": {"Id": "30fa6562cd244d98b0c75a391c9581c1","DisplayedAs": "20 Estate Ave Drive Road CU DEW Cuba"} - The does not have a VAT number so my guess is that the contact is not registered for VAT
- Invoice date: 28/06/2021
I have also attached the files for Get and Put.
Regards,
Abe
-
Hi All,
I have an Invoice with a non EU customer against it. I am trying to update the invoice via the (https://api.accounting.sage.com/v3.1/sales_invoices/{key}) endpoint, when I execute the request I get an error message from Sage API stating that I need to select the EU Goods/Services on each item line. However I am providing the the the Id of the EUGoodsServicesType as "GOODS" or "SERVICES" but I'm not having any luck with this. Its worth to mention that update works when I update an Invoice with an EU Customer.
Please could you advice on this issue?
Regards,
Abe
Error from API: Please select the EU Goods/Services on each item line.
Updating an Invoice with from a EU to a non-EU customer failes
in Support
Posted
Thanks Mark.
I had to provide the LineitemId for it to work.
Abraham