iDempiere: Allow Sales Pricelist on Purchase Order
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’
Category: iDempiere
Jasper Reports: JAVA Compatibility
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). […]
iDempiere: Restart Server
sudo service idempiere stop sudo service idempiere start
Delete duplicate rows on PgSQL and MySQL
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
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