hi Angeman,
for a specific bank from linxo import, I see in the log I get as amount
-324.67000000000002 en lieu de -324.67
which is shown in the linxo app.
this makes the amount in icompta -32467.00
I tried to create a rule around that but config does not help.
what can I do, is there something I can work out with rules?
in the end also altering the amount to be 1% of itself with a rule, is fine.
it happens only for a certain account with linxo.
I already opened a bug with linxo but that could be a bug with the bank.
I was wondering, is there a way to fix this in icompta.
also I have the free linxo and seems to have a limit in the number of transactions imported to a few days but I see months online. I use icompta Version 6.0.62 (1375) on an intel mac.
linxo issue with a specific bank
- Angeman
- Administrateur
- Posts: 2308
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: linxo issue with a specific bank
There is no reason why -324.67000000000002 would not be converted correctly to -324.67 so can you copy/paste an extract of the log at the end ? I will try to reproduce it on my computer and fix it.
Re: linxo issue with a specific bank
thanks,
this is the log
all tests below were done on a clean new icompta document without rules or previous transactions.
to test, I imported 2 accounts with the same automatic import, new config, which generated the issue.
then I split the automatic imports into two separate linxo1 and linxo2 connections to the same linxo account. running auto import also got the same issue with new config.
tried importing one by one, also the initial balance acted weird. it was
then I saved the config as decimal "." and grouping separator none
with that, the integration was successful for both (I was getting the right number 324,67 EUR) but I got less transactions and also no initial balance.
this is the log
I have 2 accounts one with weird decimals the other without. both in the same linxo.Parsing data…
[
{
"name" : "IT83XXXXXXXXXXXXXXXXXXX3111",
"transactions" : [
{
"id" : "2788557758",
"originalType" : "CREDIT",
"label" : "xx",
"remittance_information" : [
"xxx"
],
"amount" : 4511,
"type" : "CREDIT",
"date" : "27\/01\/2023",
"origin" : "TRANSACTION",
"booking_date" : 1674774000,
"import_date" : 1675196105,
"value_date" : 1674774000,
"currency" : "EUR",
"account_id" : "65181515",
"status" : "BOOKED"
}
]
},
{
"name" : "IT43XXXXXXXXXXXXXXXXXXX5697",
"transactions" : [
{
"id" : "2788557412",
"originalType" : "DEBIT",
"label" : "ADDEBITO M.AV.\/R.AV.",
"remittance_information" : [
"xxx"
],
"amount" : -324.67000000000002,
"type" : "DEBIT",
"date" : "31\/01\/2023",
"origin" : "TRANSACTION",
"booking_date" : 1675119600,
"import_date" : 1675195927,
"value_date" : 1675119600,
"currency" : "EUR",
"account_id" : "12345678",
"status" : "BOOKED"
},
{
"id" : "2788557411",
"originalType" : "CREDIT",
"label" : "xxx",
"remittance_information" : [
"xxx"
],
"amount" : 3.5299999999999998,
"type" : "CREDIT",
"date" : "31\/01\/2023",
"origin" : "TRANSACTION",
"booking_date" : 1675119600,
"import_date" : 1675195927,
"value_date" : 1675119600,
"currency" : "EUR",
"account_id" : "12345678",
"status" : "BOOKED"
},
{
"id" : "2788557410",
"originalType" : "DIRECT_DEBIT",
"label" : "TELEPASS SPA",
"remittance_information" : [
"xyz"
],
"category" : "Services : Frais bancaires",
"amount" : -50.399999999999999,
"type" : "DIRECT_DEBIT",
"source" : {
"label" : "xxx"
},
"notes" : "xyz",
"date" : "31\/01\/2023",
"origin" : "TRANSACTION",
"booking_date" : 1675119600,
"import_date" : 1675195927,
"value_date" : 1675119600,
"currency" : "EUR",
"account_id" : "12345678",
"status" : "BOOKED"
},
{
"id" : "2788557409",
"originalType" : "BANK_FEE",
"label" : " 302005220131372450",
"remittance_information" : [
" 302005220131372450"
],
"category" : "Services : Frais bancaires",
"amount" : -2.8500000000000001,
"type" : "BANK_FEE",
"date" : "31\/01\/2023",
"origin" : "TRANSACTION",
"booking_date" : 1675119600,
"import_date" : 1675195927,
"value_date" : 1675119600,
"currency" : "EUR",
"account_id" : "12345678",
"status" : "BOOKED"
},
{
"id" : "2788557408",
"originalType" : "DEBIT",
"label" : "xxx",
"remittance_information" : [
"Pxxx"
],
"amount" : -369,
"type" : "DEBIT",
"date" : "31\/01\/2023",
"origin" : "TRANSACTION",
"booking_date" : 1675119600,
"import_date" : 1675195927,
"value_date" : 1675119600,
"currency" : "EUR",
"account_id" : "12345678",
"status" : "BOOKED"
},
{
"id" : "2788557413",
"originalType" : "DIRECT_DEBIT",
"label" : "xxx",
"remittance_information" : [
"xxx"
],
"amount" : -43.990000000000002,
"type" : "DIRECT_DEBIT",
"source" : {
"label" : "xxx"
},
"notes" : "xxx",
"date" : "30\/01\/2023",
"origin" : "TRANSACTION",
"booking_date" : 1675033200,
"import_date" : 1675195927,
"value_date" : 1675033200,
"currency" : "EUR",
"account_id" : "12345678",
"status" : "BOOKED"
},
{
"id" : "2788557414",
"originalType" : "DEBIT",
"label" : "xxx",
"remittance_information" : [
"xxx"
],
"amount" : -25,
"type" : "DEBIT",
"date" : "27\/01\/2023",
"origin" : "TRANSACTION",
"booking_date" : 1674774000,
"import_date" : 1675195927,
"value_date" : 1674774000,
"currency" : "EUR",
"account_id" : "12345678",
"status" : "BOOKED"
}
]
}
]
Checking unmapped values…
Creating transactions…
all tests below were done on a clean new icompta document without rules or previous transactions.
to test, I imported 2 accounts with the same automatic import, new config, which generated the issue.
then I split the automatic imports into two separate linxo1 and linxo2 connections to the same linxo account. running auto import also got the same issue with new config.
tried importing one by one, also the initial balance acted weird. it was
in the log, ended up as 12.345.190.000,00 EUR"amount" : "12345.190000"
then I saved the config as decimal "." and grouping separator none
with that, the integration was successful for both (I was getting the right number 324,67 EUR) but I got less transactions and also no initial balance.
- Angeman
- Administrateur
- Posts: 2308
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: linxo issue with a specific bank
Thanks, can you also take a screenshot of System Preferences > General > Region & Language settings ? This way I can try to reproduce it with the same settings as you.
Re: linxo issue with a specific bank
trying to put the required details down in writing
region: Italy,
calendar: gregorian,
time format: 24h
example numeric format:
12.345,67 45.678,90 €
languages:
primary: english
other (in order): italian, french
no app-specific language settings.
running on macOS 12.6.2 (21G320) on an intel macbook pro 2015.
region: Italy,
calendar: gregorian,
time format: 24h
example numeric format:
12.345,67 45.678,90 €
languages:
primary: english
other (in order): italian, french
no app-specific language settings.
running on macOS 12.6.2 (21G320) on an intel macbook pro 2015.
- Angeman
- Administrateur
- Posts: 2308
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: linxo issue with a specific bank
Thanks, I think I found the problem and I will publish a new update soon.