August 24, 2016

PostgreSQL: Find Duplicate Rows

SELECT sku, COUNT(*) FROM m_product GROUP BY sku HAVING COUNT(*) > 1;
August 19, 2016

iDempiere: Callout Function to customize system I need to create a new Callout and add it to the Markup Field I created  
August 15, 2016

Openbravo: Process Request Stopped Working

Accting Process, Payment Monitor etc stopped working, so Invoices are not posted and Payment Schedules are not monitored (how long is an invoice late for example)
August 4, 2016

Openbravo: Check los Logs

The Openbravo Logs are located in: /opt/OpenbravoERP-3.0/tomcat/logs To change the Log Reporting Settings “Error, Debug, Info, Warn etc” you should go to: Session Preferences -> Change […]
August 3, 2016

Ubuntu: Connect via Webservice

First we need to check that there’s a viable connection between the two servers, in my case two ubuntu servers.   new SoapClient($wsdl);    
August 2, 2016

SugarCRM: MySQL Query Update Contacts

Query 1 Adds Vendedor = 1 To All Contacts that are Joined to a Manufacturer     UPDATE contacts INNER JOIN a26_proveedor_contacts_c ON = a26_proveedor_contacts_c.a26_proveedor_contactscontacts_idb […]