Skip to content

Ricardo Malla's Blog

  • Home
  • Information Technology
    • O/S
    • Databases
    • Software
  • Life
    • Health
  • Ideas
  • Notes

Category: iDempiere

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

iDempiere: Restart Server

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

sudo service idempiere stop sudo service idempiere start

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

Posts navigation

1 2 3 Next
Proudly powered by WordPress | Theme: Sydney by aThemes.