linxo issue with a specific bank

Discussions about iCompta on macOS
Post Reply
SRIC
Posts: 26
Joined: 23 October 2019, 23:51

linxo issue with a specific bank

Post by SRIC »

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.
User avatar
Angeman
Administrateur
Posts: 2302
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: linxo issue with a specific bank

Post by Angeman »

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.
SRIC
Posts: 26
Joined: 23 October 2019, 23:51

Re: linxo issue with a specific bank

Post by SRIC »

thanks,
this is the log
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…
I have 2 accounts one with weird decimals the other without. both in the same linxo.
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
"amount" : "12345.190000"
in the log, ended up as 12.345.190.000,00 EUR

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.
User avatar
Angeman
Administrateur
Posts: 2302
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: linxo issue with a specific bank

Post by Angeman »

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.
SRIC
Posts: 26
Joined: 23 October 2019, 23:51

Re: linxo issue with a specific bank

Post by SRIC »

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.
User avatar
Angeman
Administrateur
Posts: 2302
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: linxo issue with a specific bank

Post by Angeman »

Thanks, I think I found the problem and I will publish a new update soon.
Post Reply