Error creating invoices through Lexo office module

How To
,
1

I am reaching out regarding an issue I am experiencing with creating invoices through the Lexo Office module to create invoice. Despite passing all the required fields, I continue to receive the following error message:
The operation failed with an error. 406 Invalid taxRatePercentage or does not match booking date or country code.

I have tried all possible solutions, including testing without the array aggregator, but the issue persists. Interestingly, when I created an invoice manually on the platform with the same details, it worked without any errors.

I have checked the API and confirmed that all required fields are being passed, including the correct country code (IT) in current case .

I have already taken the following steps to troubleshoot the issue by checking API doc of their all the required fields are passed , I tried to create invoice without aggregator still the same issue

this is the invoice Id created maually with same details ,it works

image
image808Ă—801 47 KB

image
image824Ă—789 48.4 KB

this is using th module

image
image646Ă—709 30.7 KB

image
image904Ă—765 75.9 KB

Any help will be much appericated

2

Hi @Hamza_Irshad,

Any luck with this?

1 Like
3

not yet, still same , facing same error

4

Ok, Can you download the input bundle of the Lexo Office and share that here?

I want to review the full payload that is being sent to Lexo, and since the taxRates as per their documents are closely linked with Country Code and Booking/Voucher Date, I just want to review your payload and see if I can figure out the issue you re getting.

1 Like
5

{
“address”: {
“zip”: “46100”,
“name”: " Tommaso Virgili",
“contactId”: “c59d12ed-6921-4b9a-ad55-131448e66129”,
“countryCode”: “IT”
},
“finalize”: true,
“lineItems”: [
{
“name”: “1 × Toolbox (at €99.00 / every 30 days)”,
“type”: “custom”,
“quantity”: 1,
“unitName”: “Stück”,
“unitPrice”: {
“currency”: “EUR”,
“netAmount”: 99,
“grossAmount”: 120.78,
“taxRatePercentage”: 22
},
“discountPercentage”: 0
}
],
“xRechnung”: {},
“totalPrice”: {
“currency”: “EUR”
},
“voucherDate”: “2023-04-30T18:42:26.093Z”,
“taxConditions”: {
“taxType”: “net”
},
“paymentConditions”: {
“paymentDiscountConditions”: {}
},
“shippingConditions”: {
“shippingDate”: “2023-04-30T18:42:26.094Z”,
“shippingType”: “service”
}
}

6

Hi @Hamza_Irshad,

I actually set up the Lexo Office on my end to test it thoroughly, During which what I found at least on my account/dashboard was for Italy, the available tax percentage was,

Invoice-lexoffice

And, When I tried to use 22 then I was getting the same error. Can you check your account and under Invoice/ Rechnung, see if you have those Tax percentage available?

From your initial screenshot, you were passing Contact ID, which is believe is created for separate company as it won’t work with 22% for Italy. Let me know once you get a chance to test this out, to verify you can change the value to 19 and see if that works for you.

1 Like
7

image
image1250Ă—851 77.3 KB

See this I am seeing the option of 22%

8

{
“id”: “7dfd3a23-6cb1-4d8e-a1b9-d82a78c69e4c”,
“organizationId”: “36e2260d-3820-4f06-9420-153fe735a3b8”,
“createdDate”: “2023-04-29T11:24:11.433Z”,
“updatedDate”: “2023-04-29T11:25:29.662Z”,
“version”: 3,
“language”: “de”,
“archived”: false,
“voucherStatus”: “draft”,
“voucherNumber”: “RE0070”,
“voucherDate”: “2023-04-28T22:00:00.000Z”,
“address”: {
“contactId”: “c59d12ed-6921-4b9a-ad55-131448e66129”,
“name”: “null Tommaso Virgili”,
“supplement”: “Via Bartolomeo Stefani 7”,
“city”: “Mantova”,
“zip”: “46100”,
“countryCode”: “IT”
},
“lineItems”: [
{
“type”: “custom”,
“name”: “Gamma”,
“quantity”: 1,
“unitName”: “Stück”,
“unitPrice”: {
“currency”: “EUR”,
“netAmount”: 99,
“grossAmount”: 120.78,
“taxRatePercentage”: 22
},
“discountPercentage”: 0,
“lineItemAmount”: 99
}
],
“totalPrice”: {
“currency”: “EUR”,
“totalNetAmount”: 99,
“totalGrossAmount”: 120.78,
“totalTaxAmount”: 21.78
},
“taxAmounts”: [
{
“taxRatePercentage”: 22,
“taxAmount”: 21.78,
“netAmount”: 99
}
],
“taxConditions”: {
“taxType”: “net”,
“taxSubType”: “distanceSales”
},
“paymentConditions”: {
“paymentTermLabel”: “Zahlbar sofort, rein netto”,
“paymentTermLabelTemplate”: “Zahlbar sofort, rein netto”,
“paymentTermDuration”: 0
},
“shippingConditions”: {
“shippingDate”: “2023-04-29T00:00:00.000+02:00”,
“shippingType”: “service”
},
“closingInvoice”: false,
“relatedVouchers”: ,
“introduction”: “Thank you for choosing Project Gamma!”,
“remark”: “Vielen Dank für die gute Zusammenarbeit.”,
“title”: “Rechnung”
}

you can see this JSON I created invoice manually , I am attaching the reference as well with pic

IT
IT760Ă—1075 14.6 KB

I found this too
One-Stop-Shop / EU-Regelung: Belege an Privatpersonen im EU-Ausland | lexoffice Help Center

9

Can you use Get a Contact and see which country this contactID is associated with,

“contactId”: “c59d12ed-6921-4b9a-ad55-131448e66129”,

1 Like
10

{
“id”: “c59d12ed-6921-4b9a-ad55-131448e66129”,
“organizationId”: “36e2260d-3820-4f06-9420-153fe735a3b8”,
“version”: 1,
“roles”: {
“customer”: {
“number”: 10146
}
},
“person”: {
“salutation”: “”,
“lastName”: “Tommaso Virgili”
},
“addresses”: {
“billing”: [
{
“supplement”: “Via Bartolomeo Stefani 7”,
“zip”: “46100”,
“city”: “Mantova”,
“countryCode”: “IT”
}
]
},
“emailAddresses”: {
“business”: [
“sognandoleaway@gmail.com”
]
},
“archived”: false
}