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 Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users