Bank import is not working

1

Manager: 21.2.22
OS: Ubuntu 20.04.2 LTS (64-bit)
Date format: 05/04/2021

While importing bank statement, if file has more than one transactions, it shows number of transactions 0.

1. CSV Content
Date,Description,Amount
05/02/2021,Transaction 1,100
04/02/2021,Transaction 2,-200

Output: Number of transactions in the file 0 transactions

2. CSV Content
Date,Description,Amount
05/02/2021,Transaction 1,100

Output: Number of transactions in the file 1 transactions

3. CSV Content
Date,Description,Amount
04/02/2021,Transaction 2,-200

Output: Number of transactions in the file 1 transactions

Both transactions individually works but not in same file.

Am I missing something?

2

I copy & pasted this CSV content into CSV file, then imported and it worked fine. 2 transactions imported.

3

@shah_p_r Manager does not import transactions if matching transactions are already in the businesses.

When you did test 1 was the test businesses transactions empty or had you already entered the transactions another way?

4

@Patch - These transactions were not entered earlier. Test 2 and 3 I did after test 1 failed. For all these tests, I did not proceed to import after summary screen.

@lubos - This was working fine for me till November / December last year. Tried again yesterday but didn’t work. So thought to upgrade Manager but didn’t help.

Any other OS/library dependency that impact parsing the CSV and I should check?

Any way to debug this locally? Turning on more logs or something else?

5

@lubos , @Patch - Any update on last post?

6

This turned out to be issue when lock date is set.

Date format: 05/04/2021
Lock date: 31/03/2021

Question still remains. Why try 1 does not work but 2 and 3 works. Some issue with date format?

7

Depending on when you conducted your experiments, you might have been affected by a fix to a lock date problem that was made recently.