Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

Increase and Decrease columns for CSV imports are incorrect if it's a liability

#169

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".

Reported by Virgil Dupras · August 25th, 2010 @ 12:29 PM

State: fixed
Milestone: none
Assigned to: Virgil Dupras Virgil Dupras

Activity

  1. Virgil Dupras
    Virgil Dupras
    • Assigned user set to Virgil Dupras

    September 3rd, 2010 @ 12:02 PM

  2. Virgil Dupras
    Virgil Dupras

    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".

    September 3rd, 2010 @ 03:44 PM

  3. Virgil Dupras
    Virgil Dupras
    • State changed from accepted to fixed

    September 3rd, 2010 @ 05:36 PM

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.