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,
Goals for ERP – Accuracy, Productivity, Insight and Accountability
Hi Everyone, Everything you do during an ERP installation revolves around these four goals: Accuracy Productivity Insight Accountability You might think this is an overly-simplified statement, but when you read this article, you realize all the effort that goes into
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
ADempiere and iDempiere – Advanced System Element Find
Skill Level: Advanced Hi Everyone, In an previous post, I discussed how to use the ADempiere and iDempiere code to answer the questions “How does XYZ work?” or “What happens if I click ABC?”. Using Eclipse to see business logic is
How Does it Work? Answering the Most Common ERP Questions
Skill Level: Intermediate Hi Everyone, As an ADempiere and iDempiere integrator, the single most common questions I get are “How does XYZ work?” or “What happens if I click ABC?”. The purpose of this post is to help you answer
Should you Modify ERP? – Proprietary vs SaaS vs Open Source
Hi Everyone, The purpose of this post is to discuss the topic of modifying ERP – “To modify or not to modify?” There are generally three options in today’s world for solving problems of accuracy, productivity and insight across an