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), 10.03.2015, 15:04

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.
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
^
_________________________________

Gaving issue with AP Tax report too.

Any help will help.

Best regards
Venky

a fixed version of RP.pm is available for download from http://www.sql-ledger.com/source/updates/3.0/8/SL

 

Complete thread:

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