Book Image

Compiere 3

By : Andries L Pretorius
Book Image

Compiere 3

By: Andries L Pretorius

Overview of this book

Compiere is a world leading open source commercially supported ERP system. Very large companies have already chosen Compiere over traditional systems. By its nature ERP is a complex subject and while you may be familiar with ERP this book will introduce you to the concepts of Compiere. Here you will learn the Compiere essentials quickly and concisely.The aim of this book is to get you up and running with Compiere through a practical hands on approach. This book will also give you an overview of the main Compiere business process aspects. This book will help you get comfortable with using and exploring the Compiere system as you prepare for a roll out in your organization.Maturing from an open source project to a leading edge competitor in the ERP space, Compiere offers what other traditional big name systems lack. Offering its best of class functionality on a model driven architecture, the latest enterprise platform independent web technologies (GWT, Java, JBoss, Oracle, Postgress), while maintaining openness, value, flexibility, scalability and most of all an integrated ERP platform that can be extended upon with ease.In this book we will introduce you to understanding Compiere functionality exploring the different essential business processes. We will cover the setup, the business processes of sales, purchasing, inventory, financial management as well as advanced aspects like workflow, project planning and migration.Every chapter is illustrated by example so as to facilitate quick and practical reading. This is not a Java programming manual and the book’s aim is to take your basic knowledge of the ERP environment and ensure a proper practical understanding of the critical functional aspects during the Compiere implementation process.
Table of Contents (13 chapters)
Compiere 3
Credits
About the author
About the reviewer
Preface

Adding a new field to a window and database


In this section we are going to illustrate how the System Administrator would go about adding a new field to the database. As an illustration, we are going to add a probability reference field that can be used to measure a predefined set of outcomes on an order to the Sales Order window.

  1. 1. Find the context by Zooming to the Table from the Window. Open and find the Sales Order window in the Window, Tab, and Field menu item when logged in as System Administrator:

  1. 2. Zoom from the window into the underlying Table and Column window. Order records are maintained in the database in the C_Order table:

  1. 3. Next we refer the Column tab, and create a new column in the table (see the field naming conventions below). The new column must be as a System Element defined and hence we need to create a System Element prior to using it as a Column in the Table:

  1. 4. Once the System Element has been defined, we set up the Column as follows:

  1. 5. Create a new Reference key...