iDempiere: Tweak Xms and Xmx
Posted onChange idempiereEnv.properties IDEMPIERE_JAVA_OPTIONS=-Xms256M -Xmx1024M
Category: iDempiere
iDempiere: Allow Sales Pricelist on Purchase Order
Posted onShow product Pricelist on Purchase Order Go to System profile, Windows, Tabs & Fields Select Purchase Order Tab (header tab) Remove the statement from the Sql Where field. C_Order.IsSOTrx='N'
Jasper Reports: JAVA Compatibility
Posted onWe user Jasper Reports on multiple projects: We have a stand-alone Jasper Server that runs all types of reports from our server We have an Openbravo ERP Instance We have an iDempiere ERP Instance Running (same fork root as Openbravo). The Jasper Studio is used to configure the reports and compile them, the problem is […]
iDempiere: Restart Server
Posted onsudo service idempiere stop sudo service idempiere start
Delete duplicate rows on PgSQL and MySQL
Posted onThis code shows how to delete duplicate rows on pgsql DELETE FROM m_product WHERE sku in( SELECT sku FROM ( SELECT sku, count(*) FROM m_product GROUP BY sku HAVING count(*) > 1 ) a ) AND em_mg_manufacturer = 1000012 In MYSQL DELETE product FROM product WHERE reference in ( SELECT reference FROM ( […]