[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

can't search on transactions



Hi All,
	I am experiencing the exact same issue.

LedgerSMB 1.3.36, Postgres 8.4

AR->reports->transactions: Does not matter what is entered in any of
the fields fails with

ORDER BY 4 ASC,2,16
ERROR: column "a.crdate" must appear in the GROUP BY clause or be used in an aggregate function
LINE 2: ...ELECT a.id, a.invnumber, a.ordnumber, a.transdate, a.crdate,

AR-reports->Outstanding : Does not work if Detail is selected, Summary works and accepts date info etc.


AP->reports->transactions: Does not matter what is entered in any of
the fields it fails the same as above

AP-reports->Outstanding : Does not work if Detail is selected, Summary works and accepts date info etc.

Ideas?

Dave

------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable 
security intelligence. It gives you real-time visual feedback on key
security issues and trends.  Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users