commit 4fb4659a03756b39a836ffde4427bd4a9e012ce3
author Nabin Hait <nabinhait@gmail.com> Mon Jan 07 15:00:08 2013 +0530
committer Anand Doshi <anand@erpnext.com> Tue Jan 08 15:42:04 2013 +0530
tree d4293b1a705021b7542d1f62d7b683f1a3a1c9c6
parent 8bacc3443e238de7148fb337898d188f447d3a27
parent e80b9c6ee9011dd2cfc77fbb5e78711951748f76

Merge branch 'master' of github.com:webnotes/erpnext

accounts/utils/__init__.py

diff --git a/accounts/utils/__init__.py b/accounts/utils/__init__.py
index c4a0042..8ad1899 100644
--- a/accounts/utils/__init__.py
+++ b/accounts/utils/__init__.py
@@ -28,8 +28,8 @@
 		subdate(adddate(year_start_date, interval 1 year), interval 1 day) 
 			as year_end_date
 		from `tabFiscal Year`
-		where %s >= year_start_date and %s < adddate(year_start_date, interval 1 year)""",
-		(date, date))
+		where %s >= year_start_date and %s < adddate(year_start_date, interval 1 year)
+		order by year_start_date desc""", (date, date))
 	
 	if not fy:
 		error_msg = """%s not in any Fiscal Year""" % formatdate(date)