When trying to search on transactions (I only have one - just created) - I'm used to just having to fill out a "from date" field - or even nothing - and then SL will search with default settings.
with ledgersmb 1.3.36 - I get an error: SELECT a.id, a.invnumber, a.ordnumber, a.transdate, a.crdate, a.duedate, a.netamount, a.amount, (a.amount - pd.due) AS paid, a.invoice, a.datepaid, a.terms, a.notes, a.shipvia, a.shippingpoint, ee.name AS employee, vce.name, vc.meta_number, vc.entity_id, a.till, me.name AS manager, a.curr, ex.sell AS exchangerate, d.description AS department, a.ponumber, as_array(p.projectnumber) as ac_projects, as_array(ip.projectnumber) as inv_projects FROM ap a JOIN entity_credit_account vc ON (a.entity_credit_account = vc.id) JOIN acc_trans ac ON (a.id = ac.trans_id) JOIN chart c ON (c.id = ac.chart_id) LEFT JOIN (SELECT acc_trans.trans_id, sum(CASE WHEN 'ap' = 'ap' THEN amount WHEN 'ap' = 'ar' THEN amount * -1 END) AS due FROM acc_trans JOIN account coa ON (coa.id = acc_trans.chart_id) JOIN account_link al ON (al.account_id = coa.id) WHERE ((al.description = 'AP' AND 'ap' = 'ap') OR (al.description = 'AR' AND 'ap' = 'ar')) AND (approved IS TRUE) GROUP BY acc_trans.trans_id) pd ON (a.id = pd.trans_id) LEFT JOIN entity_employee e ON (a.person_id = e.entity_id) LEFT JOIN entity_employee m ON (e.manager_id = m.entity_id) LEFT JOIN entity ee ON (e.entity_id = ee.id) LEFT JOIN entity me ON (m.entity_id = me.id) JOIN entity vce ON (vc.entity_id = vce.id) LEFT JOIN exchangerate ex ON (ex.curr = a.curr AND ex.transdate = a.transdate) LEFT JOIN department d ON (a.department_id = d.id) LEFT JOIN invoice i ON (i.trans_id = a.id) LEFT JOIN project ip ON (i.project_id = ip.id) LEFT JOIN project p ON ac.project_id = p.id WHERE (FALSE OR a.approved) AND 1 = 1 AND a.transdate >= '01-01-2010' AND pd.due <> 0 AND a.id IN (SELECT ac.trans_id FROM acc_trans ac JOIN chart c ON (c.id = ac.chart_id AND charttype = 'A') WHERE a.id = ac.trans_id AND c.accno = '2100') GROUP BY a.id, a.invnumber, a.ordnumber, a.transdate, a.duedate, a.netamount, a.amount, a.invoice, a.datepaid, a.terms, a.notes, a.shipvia, a.shippingpoint, ee.name , vce.name, vc.meta_number, a.amount, pd.due, vc.entity_id, a.till, me.name, a.curr, ex.sell, a.ponumber, d.description 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, -- Regards, Klavs Klavsen, GSEC - k...@vsen.dk - http://www.vsen.dk - Tlf. 61281200 "Those who do not understand Unix are condemned to reinvent it, poorly." --Henry Spencer ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
