FrontAccounting forum — Tax Report rep702 order by date

Re: Tax Report rep702 order by date

2020-02-10T19:14:27Z

@joe: This (date wise) should be the way it is by default. Alternatively, a report request flag for this mod can be in the core.

Re: Tax Report rep702 order by date

2020-02-10T13:10:27Z

Sorry Braath

Your change works perfectly.

I was too quick to answer. Should have paid more attention.

Thanks

Re: Tax Report rep702 order by date

2020-02-10T12:52:48Z

Thanks Braath,

I actually tried this before and I got this error in the log:

[10-Feb-2020 13:48:11 Europe/Berlin] DATABASE ERROR : No transactions were returned
error code : 1054
error message : Unknown column 'taxrec.trans_date' in 'order clause'
sql that failed was : SELECT tt.name as taxname, taxrec.*, taxrec.amount*ex_rate AS amount,

I could not understand why the ORDER BY gives such an error if one changes the order.

Re: Tax Report rep702 order by date

2020-02-10T11:03:47Z

@@ -67,7 +67,7 @@ function getTaxTransactions($from, $to)
         $sql .= " AND taxrec.tran_date >= '$fromdate'
                        AND taxrec.tran_date <= '$todate'
         GROUP BY taxrec.id
-               ORDER BY taxrec.trans_type, taxrec.tran_date, taxrec.trans_no, taxrec.ex_rate";
+               ORDER BY taxrec.tran_date, taxrec.trans_type, taxrec.trans_no, taxrec.ex_rate";
 
     return db_query($sql,"No transactions were returned");

Tax Report rep702 order by date

2020-02-10T07:13:08Z

Dears,

How can I get the tax report to sort entries by date instead of Transaction type?
I tried to look around but being a novice I couldn't make it out.

Any ideas?