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

Re: can't search on transactions



 Hi,

Get the latest svn from the repository, it already contains the fix for this issue, r6622

You should be ok with that.

Cheers,
István


 
----------------eredeti üzenet-----------------
Feladó: "Dave" ..hidden.. 
Címzett: "LedgerSMB Mail List" ..hidden.. 
Dátum: Thu, 30 Jan 2014 10:45:57 -0700
-------------------------------------------------
 
 
> 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/ost
> g.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden.. 
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 



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