Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (3)

Export to CSV makes expenses as +tive and income (from invoice manager) as -tive Task

Expense Manager
Wednesday, January 02 2019, 10:24 AM
Zena
Zena
Offline
0
Hi,
When i export to CSV in the expense module, expenses as marked as +tive while income are marked as -tive. I understand the logic behind this but this is a bit confusing for my users are expenses are marked as -tive in the expense module and this is what they also expect to see when exported to CSV.
Is there a way to revert this to ensure that .CSV shows expenses as -tive and income as +tive?
Responses (3)

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Thursday, January 03 2019, 11:56 AM - #Permalink
    0
    hello,

    well, this would require a small modification on the PHP code responsible for the CSV export.
    if you're ok with modifying PHP code, I can tell you how.
    The reply is currently minimized Show

  • Accepted Answer

    Zena
    Zena
    Offline
    Thursday, January 03 2019, 12:22 PM - #Permalink
    0
    Hi Germinal,

    Sure. i can modify the php code. Please guide me through the process.
    The reply is currently minimized Show

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Tuesday, January 08 2019, 04:18 PM - #Permalink
    0
    in file /components/com_finances/views/items/tmpl/default_csv.php
    you have to change the sign to the amount:

    for example you can try
    after this code:

    $base = $row->amount / (1+$taxop);


    put this:

    $base = $base * -1;
    The reply is currently minimized Show
Your Reply