ADempiere and iDempiere – Product Management Beyond Stocked Items

Hi Everyone, In a previous post, we discussed how to use products to communicate shipping and receiving instructions to internal or external users. The purpose of this post is to (a) expand the conversation into other types of non-stocked product

How to Connect to Your ADempiere or iDempiere Database

Hi Everyone, The purpose of this post is to help you configure your ADempiere or iDempiere PostgreSQL database so that you can connect to it from an external machine. There are a number of reasons why this topic is important.

Running iDempiere, Open Source ERP, on a Micro AWS Instance

Hi Everyone, Here is a common question: “Can iDempiere run on a micro AWS instance?” Answer: yes. Another question: “How many iDempiere users can you support using the micro AWS instance?” Answer: between 1 and 3 concurrent users (more if

How to Run iDempiere on AWS and Disconnect from SSH Client

Hi Everyone, ********** Update: here is a much better way to install iDempiere. ********** The purpose of this post is to offer easy instructions on how to launch iDempiere (open source ERP), disconnect from an SSH client (like Putty), and

ADempiere and iDempiere – Mass Create Missing Cost Records

Hi Everyone, The purpose of this post is to remind me later when I need a query to create missing costing records. Copy execute the below query into pgadmin: select ‘insert into m_cost values(‘||p.ad_client_id||’, 0, ‘||p.m_product_id||’, 1000000, 1000000, ‘||ce.m_costelement_id||’, 0,

Install iDempiere, Open Source ERP, on a AWS Linux Server in 10 Min

Hi Everyone, The purpose of this post is to record how to quickly install iDempiere on an AWS Ubuntu server. You do not need to use AWS. Any modern Ubuntu server should do fine. *** Update (06/08/2014): The below script

ERP Best Practices – Shipping, Receiving and Invoicing Notes

Hi Everyone, The purpose of this post is to share ADempiere and iDempiere, open source ERP, best practices when communicating notes and instruction between order entry, receiving, fulfillment and invoicing. This topic is commonly discussed in high-volume wholesale distribution and

Best Month to Go Live with a New ERP

Hi Everyone, A common question is: “what is the best month or time to go live with a new ERP?” Here are some points to consider: You do not want to go live on the last period of your fiscal

Hosting Open Source ERP in the Cloud – Maximize Linux Hosting

Hi Everyone, There are compelling reasons to use Linux over Windows when hosting open source ERP, ADempiere and iDempiere, in the cloud. For example, Linux is less than half the price of windows when you consider the (a) AWS hourly

Best Practices for System Administrator Role in ADempiere – iDempiere

Hi Everyone, Has anyone ever told you that SuperUser is the only user that can access the ADempiere or iDempiere Server Management Page to view logs or manage services? Does everyone in your IT team use the SuperUser / System