Hi Everyone, The purpose of this post is to publish a quick fix to an slightly annoying problem. In iDempiere, you can not use the LIMIT keyword in your SQL where statements. The reason is that iDempiere was originally
iDempiere Open Source ERP Disaster Recovery
Hi Everyone, The purpose of this post is to discuss iDempiere Open Source ERP disaster recovery. There are times when things out side of your control go badly. Operating systems go into a bad state. Drives fail. Power is
iDempiere Open Source ERP State of The Union 2016-05-13
Hi Everyone, The purpose of this post is to outline the current iDempiere state of the union (2016) as is observed by me and many of the ERP Academy members. iDempiere officially started in April 2011 as a fork of
Enterprise iDempiere Cost Calculator
Hi Everyone, The purpose of this post is to help you calculate the cost of hosting an enterprise quality iDempiere instance. Here is an iDempiere hosting cost calculator where you can plug in the features you want, and the spreadsheet will
Enterprise Quality Open Source ERP – Scaling iDempiere
Hi Everyone, The purpose of this post is to help you understand how to scale iDempiere to enterprise levels. I recently gave a presentation on this topic at the iDempiere World Conference, and I wanted to share the highlights with you
Advanced iDempiere Open Source ERP Training
Hi Everyone, The purpose of this post is to brag about iDempiere’s training options. In December of 2013, I started the ERP Academy. In the last year, we created over 470 videos illustrating how to use iDempiere Open Source ERP in
iDempiere Installation Behind a Light Firewall and Encrypted Tunnel
Hi Everyone, The purpose of this post is to highlight how to install iDempiere behind a light, free firewall and encrypt all user traffic. Doing so helps ensure: Only the right people can log into iDempiere All traffic between
Manually Inserting Records into iDempiere – Use generate_uuid()
Hi Everyone, The purpose of this post is to offer a quick tip to generate a uuid for iDempiere’s UUID columns. Use the iDempiere function generate_uuid() to create your values when inserting records. Use this function to populte any of the
Comparing OpenERP with ADempiere and iDempiere
Hi Everyone, I am often asked about choosing between OpenERP and either iDempiere or ADempiere (iD/AD). So, I thought I would take the time to share my experiences. Disclaimer: It is worth mentioning that I am partial to iD/AD. I have
iDempiere PostgreSQL Move Data and Config Files to Different Device
Hi Everyone, Today I had to create a script to move the PostgreSQL data and configuration files to a different device or hard drive on Ubuntu Linux. The purpose of this post is to share the results with you. Moving