Wrong signage_convention on csv import. How to fix?

[BRTFTW]

So I had some issues importing my transaction csv, because the amount format (1 123.00 standard in my country) is not supported. After editing my csv manually I got it to work but unfortunately, I missed the correct signage_convention this time. And I didn't realise that for another hours or so editing the categories to my liking. Now I am hesitant to delete the transactions and redo the import because of the work already done.
Is there a way to easily fix this from the selfhosting interface? I had a look at the sql database, but messing with the data surely introduces more errors, that maybe wont automatically detect and fix (like changes in balances after switching all the expenses to incomes and vice versa).

[BRTFTW]

On the same note, these transactions were imported with the inflows_positive option (which was and error on my side). The account was created as an Debt account for my credit card. So on one hand, the transactions are handled as inflows, but at the same time the balance decreases by the same amount. Is this to be expected?
Payments to my credit card from my checking account are correctly listed as inflows, but still decrease the balance.

[zachgoll]

Yes, an "inflow" to a debt account (like a credit card) should decrease the balance on that account.

In other words, an "inflow" would be a "payment to the credit card", which will reduce the "amount owed" (which is what the balance represents)

[zachgoll]

@BRTFTW unfortunately we don't have an "easy" way to handle this at the moment other than "reverting" the import entirely.

This will erase all the categorizations as you mention, so its not ideal.

The fastest (but not easiest) way to change signage conventions would be to reverse the amount values in the account_entries table of your database.

Below is a read-only query that demonstrates this. You'll need to change it to UPDATE to make the changes:

-- All "transactions" with reversed amount
SELECT
  amount * -1 as reversed_amount 
FROM account_entries
WHERE entryable_type = 'Account::Transaction';