iDempiere – Ricardo Malla's Blog

iDempiere: Restart Server

Posted August 18, 2018November 30, 2019 Ricardo MallaLeave a commentPosted in iDempiere

sudo service idempiere stop sudo service idempiere start

iDempiere: Allow Sales Pricelist on Purchase Order

Posted November 17, 2018 Ricardo MallaLeave a commentPosted in iDempiere

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'

Jasper Reports: JAVA Compatibility

Posted August 19, 2018 Ricardo MallaLeave a commentPosted in iDempiere, Java, OpenBravo, Tibco - Jasper Reports

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). […]

Delete duplicate rows on PgSQL and MySQL

Posted December 24, 2017December 24, 2017 Ricardo MallaLeave a commentPosted in iDempiere, PostgreSQL

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 […]

iDempiere: Alter Sequence

Posted September 8, 2016September 8, 2016 Ricardo MallaLeave a commentPosted in iDempiere, PostgreSQL

Update M_Product_ID UPDATE ad_sequence SET currentnext = 1026150 WHERE ad_sequence_id = 114 Update Product PriceList UPDATE ad_sequence SET currentnext = 1026138 WHERE ad_sequence_id = 165