webERP Forum
Counter sales - - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+---- Forum: RESOLVED - Bugs/Problems (http://www.weberp.org/forum/forumdisplay.php?fid=15)
+---- Thread: Counter sales - (/showthread.php?tid=253)



Counter sales - - asperatus - 05-30-2012

Error is in line 244 of Countersales.php - need to correct spelling error to decimalplaces


Database Error : There is a problem selecting the part records to display because
Unknown column 'stockmaster.decmimalplaces' in 'field list'


Database SQL Failure : The SQL used to get the part selection was
SELECT stockmaster.stockid, stockmaster.description, stockmaster.units, stockmaster.decmimalplaces FROM stockmaster INNER JOIN stockcategory ON stockmaster.categoryid=stockcategory.categoryid WHERE (stockcategory.stocktype='F' OR stockcategory.stocktype='D') AND stockmaster.mbflag <>'G' AND stockmaster.controlled <> 1 AND stockmaster.description LIKE '%HEX%' AND stockmaster.discontinued=0 ORDER BY stockmaster.stockid LIMIT 50 OFFSET 0


RE: Counter sales - - Exsonqu_Qu - 05-30-2012

Hi, asperatus:

Thank you very much. I've committed your fix to svn.

Best regards!

Exson