Increase and Decrease columns for CSV imports are incorrect if it's a liability
Reported by Virgil Dupras | August 25th, 2010 @ 12:29 PM
If we have a CSV file for a liability with 2 amount columns corresponding to increases and decreases in the account, using the "Increase" column on the column that corresponds to amount making the debt increase, and the "Decrease" column corresponding to the column with amounts making the debt decrease, we'll end up with inverted amounts in the main import window.
This problem is more than a simple bug, it's a design mistake. Because we don't know at the CSV parsing stage whether the account is an asset or a liability, the term "Increase" or "Decrease" don't make any sense. Therefore, the terms we use there should be changed to "Debit" and "Credit".
Comments and changes to this ticket
-
Virgil Dupras September 3rd, 2010 @ 12:02 PM
- Assigned user set to “Virgil Dupras”
-
Virgil Dupras September 3rd, 2010 @ 03:44 PM
That's more complicated than a simple label change. There are minus sign swapping logic to get around strange CSV files and that logic would be messed with if proper Debit/Credit column were implemented. The best way to deal with this problem I think would be to add a new field swapping option: "Invert amounts".
-
Virgil Dupras September 3rd, 2010 @ 05:36 PM
- State changed from “accepted” to “fixed”
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
Virgil Dupras