Change idempiereEnv.properties IDEMPIERE_JAVA_OPTIONS=-Xms256M -Xmx1024M
Show 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'
We 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 […]
sudo service idempiere stop sudo service idempiere start
This 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 ( […]