Managing Outsourced Manufacturing in iDempiere Open Source ERP

  Hi Everyone, The purpose of this post is to introduce you to a new training series designed to help you support the outsourced manufacturing process in iDempiere, open source ERP. This course covers: How to configure iDempiere to receive

Manufacturing BOM Templates in iDempiere Open Source ERP

  Hi Everyone, The purpose of this post is to help you create manufacturing BOM (Bill of Material) templates in iDempiere open source ERP. In make-to-order, high-mix-low-volume (HMLV), and make-to-order (MTO)  manufacturing scenarios, users do not like creating products from

Project Manufacturing – Quick Demonstration using iDempiere Open Source ERP

  Hi Everyone, The purpose of this post is to demonstrate project manufacturing in iDempiere. Manufacturing companies generally fall into one of two camps: You make hundreds or millions of units in a day – Example: high volume discrete or process

iDempiere and ADempiere Trx Organization (Transaction Org – AD_OrgTrx_ID)

  Hi Everyone, The purpose of this post is to offer information on the iDempiere, Open Source ERP, transaction org field. This discussion applies to ADempiere, Compiere and Openbravo as well. There is not much information on the web about why this

iDempiere Last PO Costing Method Cost Element – Audit Results

Hi Everyone, The purpose of this post is to test the accuracy of iDempiere’s Last PO costing method. Tests will be performed when costing level is at (a) Client, (b) Organization, and (c) Lot/Batch. Tests performed for products with and

Why Choose Average Invoice in a Perpetual Accounting System or ERP

Hi Everyone, The purpose of this post is to discuss why someone would want to use Average Invoice costing in a perpetual accounting or ERP system. This question bothered me for many years, and a recent conversation enlightened me. Therefore,

PostgreSQL Triggers – Enhancing/Customizing Open Source ERP

Hi Everyone, The purpose of this post is to offer a simple way to enhance ADempiere and iDempiere, open source ERP, using database triggers. Business Scenario: You are a distributor of products. You use standard costing to record the cost

iDempiere and ADempiere – Learning Manufacturing and Production

Hi Everyone, The purpose of this post is to help make learning production and manufacturing in iDempiere and ADempiere, open source ERP, as easy as possible. Specifically, I am going to address a common situation that users encounter when first

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

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,