forums.lyricapps.com

Posted: **02 February 2023, 12:49**

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.

Posted: **02 February 2023, 13:14**

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.

Posted: **04 February 2023, 15:34**

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.

Posted: **04 February 2023, 16:04**

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.

Posted: **06 February 2023, 10:16**

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.

Posted: **06 February 2023, 14:46**

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

forums.lyricapps.com

linxo issue with a specific bank

linxo issue with a specific bank

Re: linxo issue with a specific bank

Re: linxo issue with a specific bank

Re: linxo issue with a specific bank

Re: linxo issue with a specific bank

Re: linxo issue with a specific bank