Hi Everyone, The purpose of this post is to document how to make PostgreSQL’s concat_ws behave like MySQL’s concat_ws. You can use the below functions bring multiple records into a single comma or new-line delimited string. When I wrote this,
ADempiere and iDempiere – How To Remove CheckBox and X from Yes/No
Hi Everyone, Here is a common question: “How do you remove the green check or the red X from ADempiere and iDempiere print formats?” Answer: Create a column in your print format’s view or a ColSQL in your print
ADempiere – iDempiere – Add Text from Reference List to Print Format
Hi Everyone, Here is a common question: For my print format, I have a column that is of Reference type “List”. The Reference Key points to _PaymentRule (payment rule). Currently, it prints this field as “S”. How do I fix
Example of ERP Customization – ERP Best Practices
Hi everyone, In a previous post, I recommended guidelines on when you should and should not customize your ERP system. This post prompted a discussion that I believe you would be interested in. Summary: “We want to change how ADempiere works
ERP Customization – What You Should Know
Hi Everyone, The purpose of this article is to discuss ERP customization and its impact on your project. I read over and over how people warn about ERP customization, but the reality is that ERP is the one application that everyone
Open Source ERP – Safely and Securely Hosting your Sensitive Data
Hi Everyone, The purpose of this post is to discuss ADempiere, iDempiere, open source ERP and security. If you go into a board room and announce that you are going to run your entire company’s business using open source ERP
Open Source ERP Integration with Concur Expense Management
Hi Everyone, The purpose of this post is to help you integrate iDempiere and ADempiere, open source ERP, and Concur expense management tools. Summary: Concur activities result in expenses in an ERP. These expenses appear in the form of either payables to
Open Source ERP Supports the Natural Evaluation Process
Hi Everyone, It takes awhile to decide if a new ERP is the right choice for your organization. There are social, operational, financial and technical hurdles that need to be viewed, discussed and solved. This process takes time, and it
ADempiere and iDempiere – User Activity and Change Log Reporting
Hi Everyone, One of my favorite features of ADempiere and iDempiere is that you can track every little footstep (change tracking) everyone makes in the system. This is true for IT personnel changes as well. The purpose of this post is
ADempiere and iDempiere – PayFrom on Business Partner Location
Hi Everyone, —————————– Updated 11/12/2013 See this post for an updated and more accurate description of ADempiere/iDempiere’s Payfrom (ispayfrom): —————————– The purpose of this post is to better explain the ADempiere and iDempiere’s Pay From (PayFrom) checkbox on the Business Partner’s