To Phil or Exson,
and any other webERP developer
After I update webERP via SVN Stable Update, now I can't create Credit Note
from Supplier Transaction, I think there's something wrong in
Credit_Invoice.php script after update,
when you click credit from customer transaction inquiries, the credit form
only showing one item and two empty rows, then if you try to push the
process credit button then it shows this following errors :
-----------------------
ERROR Message Report : It appears that taxes are not defined correctly for
this customer tax group
Database Error : The taxes and rates for this item could not be retrieved
because
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'ORDER BY
taxgrouptaxes.calculationorder' at line 14
Database SQL Failure : The SQL that failed was
SELECT taxgrouptaxes.calculationorder, taxauthorities.description,
taxgrouptaxes.taxauthid, taxauthorities.taxglcode, taxgrouptaxes.taxontax,
taxauthrates.taxrate FROM taxauthrates INNER JOIN taxgrouptaxes ON
taxauthrates.taxauthority=taxgrouptaxes.taxauthid INNER JOIN taxauthorities
ON taxauthrates.taxauthority=taxauthorities.taxid WHERE
taxgrouptaxes.taxgroupid=1 AND taxauthrates.dispatchtaxprovince=1 AND
taxauthrates.taxcatid = ORDER BY taxgrouptaxes.calculationorder
-----------------------
Please check and fix this issues cause I really need this in my system.
Thank you.
Best Regards,
===========
Baliboss / Ade
-----
Baliboss
Bali Open Source Solution
http://www.baliboss.com
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Can-t-create-Credit-Note-After-SVN-Update-tp4655649.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|