SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the board
Thread view  Mix view  Order
venky4025(R)

09.03.2015, 21:09
 

Upgraded to Version 3.07 and issue with report (General)

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

Dieter Simader(R)

09.03.2015, 23:59

@ venky4025

Upgraded to Version 3.07 and issue with report

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

venky4025(R)

10.03.2015, 01:54

@ Dieter Simader

Upgraded to Version 3.07 and issue with report

Thank you Dieter
Venky

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

Dieter Simader(R)

10.03.2015, 15:04

@ venky4025

Upgraded to Version 3.07 and issue with report

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

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