SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Upgraded to Version 3.07 and issue with report (General)

posted by Dieter Simader(R), 09.03.2015, 23:59

I just upgraded to version 3.07 and am having trouble with some of the
reports giving errors:

AR AGING Report gives:
_________________________________
DBD::Pg::st execute failed: ERROR: column vc.sortorder does not exist
LINE 8: ORDER BY vc.sortorder
^ at SL/RP.pm line 1438.

there is a $ sign missing, edit RP.pm and change the line to

ORDER BY vc.$sortorder

Error!


ERROR: column vc.sortorder does not exist
LINE 8: ORDER BY vc.sortorder
^
_________________________________


AR Tax Collected give:
_________________________________

DBD::Pg::st execute failed: ERROR: syntax error at or near "ASC"
LINE 15: ORDER by ASC, 3 ASC,4,5
^ at SL/RP.pm line 2231.
Error!

SELECT a.id, a.invoice, a.transdate AS transdate,
a.invnumber, n.name, n.customernumber, a.netamount,
a.description,
sum(ac.amount) * 1 AS tax,
a.till, n.id AS vc_id
FROM acc_trans ac
JOIN ar a ON (a.id = ac.trans_id)
JOIN chart ch ON (ch.id = ac.chart_id)
JOIN customer n ON (n.id = a.customer_id)
WHERE a.approved = '1'
AND ch.accno = '2310'

GROUP BY a.id, a.invoice, a.transdate, a.invnumber, n.name,
a.netamount, a.till, n.id, a.description, n.customernumber
ORDER by ASC, 3 ASC,4,5
ERROR: syntax error at or near "ASC"
LINE 15: ORDER by ASC, 3 ASC,4,5
^

this one is a bit trickier to fix, I'll have an update later this week.

You can copy RP.pm from v3.0.6, it should work too. If not wait for the update.

_________________________________

Gaving issue with AP Tax report too.

Any help will help.

Best regards
Venky

 

Complete thread:

Back to the forum
Board view  Mix view
976 Postings in 320 Threads, 326 registered users, 108 users online (0 registered, 108 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum