FrontAccounting forum — Tax Report rep702 order by date

Re: Tax Report rep702 order by date

null@example.com (apmuthu) — Mon, 10 Feb 2020 19:14:27 +0000

@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

null@example.com (rafat) — Mon, 10 Feb 2020 13:10:27 +0000

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

null@example.com (rafat) — Mon, 10 Feb 2020 12:52:48 +0000

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

null@example.com (Braath Waate) — Mon, 10 Feb 2020 11:03:47 +0000

@@ -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

null@example.com (rafat) — Mon, 10 Feb 2020 07:13:08 +0000

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?