GnuCash
Contact   Instructions
Bug 797173 - Allow user to specify a debit/credit column needs to be negated.
Summary: Allow user to specify a debit/credit column needs to be negated.
Status: RESOLVED DUPLICATE of bug 797171
Alias: None
Product: GnuCash
Classification: Unclassified
Component: Import - CSV (show other bugs)
Version: 3.4
Hardware: PC Linux
: Normal normal
Target Milestone: ---
Assignee: import
QA Contact: import
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-03 13:41 EDT by Steve Butler
Modified: 2019-09-05 15:33 EDT (History)
3 users (show)

See Also:


Attachments

Description Steve Butler 2019-04-03 13:41:01 EDT
Running the CSV importer on the file that hadfields :

    Status, Date, Description, Debit, Credit, MemberName

Noticed that there were three rows with amounts in the Credit column and
all said values where negative!

Ran the importer and saw that those three rows were treated as charges. 

This is really Citi Credit Card issue as they put the values in a Credit column and then used Negative Values!!

It would be nice to indicate that the creator of the file has used the opposite sign that would normally be expected.  

This should be on a column by column basis.  As in my example, they put positive values in the Debit column and negative columns in the Credit column.  I would want to specify that only the Credit column be treated as opposite to expected values.
Comment 1 Geert Janssens 2019-09-05 15:33:15 EDT
This is the same issue as bug 797171, though you propose two different solutions. The multiple column selection in the other bug has my preference, so I'm marking this one as a duplicate.

*** This bug has been marked as a duplicate of bug 797171 ***

Note You need to log in before you can comment on or make changes to this bug.