bank-statement-import
bank-statement-import copied to clipboard
OCA bank import (V17) error: Bad file/mapping: 'Amount' is not in list when 'Distinct debit/credit' selected
Module
OCA/bank-statement-import (V17)
Describe the bug
'Amount' is not in list when 'Distinct debit/credit' selected and no Amount column.
To Reproduce
Create a bank statement file that has distinct debit/credit columns, load and an error is generated
Add a new column 'Amount' which is sum(+debit-credit) and the file loads.
The error suggests that the Amount column is not included however this shouldn't be required as I have set separate debit/credit columns which suggests that Amount is hardcoded somewhere
Expected behavior
I expect that the amount is calculated from debit/credit when this option is selected.