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

Re: can't search on transactions



Or use 1.3.37_rc3.

sent from my phone

On Jan 30, 2014 7:12 PM, "Pongrácz István" <..hidden..> wrote:
 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
------------------------------------------------------------------------------
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