Posted by: Bayu Cahya P on: December 5, 2009
In the past seven years, as the author was starting his journey with the manufacturing and the services industries, he found that many tasks in these industries involved back offices using manual efforts. These industries made use of spreadsheet applications or implemented their own specifc solution. Each of the departments such as Production, Purchasing, Accounting, and so on created their own data and often had a different figure on the same subject when preparing business reports. This led to extra efforts required when creating an analysis report.
Enterprise Resource Planning (ERP) is a system that integrates all of the functions, in each of the departments, into a single system that is designed to encapsulate all of business processes getting involved. With the existence of an open source ERP package, there is an option for an organization to manage their data in a centralized way, working with the same data and get the beneft with data integrity and can create business reports more accurately and faster.
ERP systems are essential in today’s business market. There are many options for ERP systems; however, ADempiere offers a solid foundation for developing a powerful ERP system that helps your business to manage data effciently, streamline different processes, at affordable costs, and improve the effciency levels without too much complexity.
The ADempiere project was established and created on September 2006. ADempiere is a friendly fork of the Compiere ERP. The ADempiere community expected to use a proven platform, taking care of and listening to the customers’ needs and feedback, and create a project that was community driven and used General Public License (GPL) as its license; thus providing the freedom to extend its feature and capabilities. Form its inception, ADempiere attracted great attention from all over the world. According to the SourceForge.net download statistic for the year of 2009, there have been more than ten thousand downloads, as evident from sourceforge.net
This practical book offers a comprehensive understanding of ADempiere, and takes a look at the main features by way of developing and enhancing a sample case study from concept to deployment. This book will help you model complex business processes with ease.
You will learn to install ADempiere, followed by confguring the company structure and the initial client setup. You can start working with ADempiere immediately because this book will get you up and running quickly, and assumes no prior knowledge or experience of working with ADempiere. ADempiere 3.4 ERP Solutions enables you to: set up the accounting parts, defne the prerequisite data, learn about product and price management, and perform procurement and sales activities. When you read the book, you’ll understand the concept behind the ADempiere workfow and the important function of managing inventory. Activities such as making user-defned fnancial reports, procedures for importing data, and security considerations will be covered in detail, and you will also partly learn about the application dictionary configuration.
ADempiere generates accounting facts or journals automatically. In this book, you will understand the impact of these accounting facts. This book will provide you with a comprehensive study of how to easily implement ADempiere and make the best use of this open source ERP system. To understand the content of this book thoroughly, it is suggested that readers learn and practice the topics sequentially from Chapter 1 through Chapter 10. The remaining chapters can be read and implemented as references.
In Chapter 1: ADempiere Installation, you will be introduced to the hardware requirements, obtaining ADempiere and the prerequisites applications, installing and setting up PostgreSQL databases, applying patches, and verifying the ADempiere server and client. Throughout the book, we will use Microsoft Windows as the operating system.
In Chapter 2: Implementing the ADempiere client and Performing Tasks, you will learn the connection aspect of ADempiere, how to identify the ADempiere version, predefned user IDs, standard format of the ADempiere client user interface, and standard command and functions to perform tasks (including Record Info and the field context menu)
In Chapter 3: Exploring Company Structures and Initial Client Setup, you will create and map a fictitious apparel company structure. In this chapter, you will be introduced to standard ADempiere company structures, preparing chart of accounts which are required during the initial client creation, creating a new client (company), and finally, you will set up and review organizations, warehouses, and locators. You will also be introduced to Accounting Schema, Calendar Year and Period, and the Accounting Processor features of ADempiere.
In Chapter 4: Setting up Master Data and Knowing its Accounting Confguration, before you start working with ADempiere, you need to set up some master or reference data in the system. For all of the basic or data references, it has a standard accounting confguration. This chapter shows you how the accounting related confguration takes parts. With this information, we can confgure and alter the default account
for an account related with master or references data. With this basic accounting confguration, you will be introduced to managing the customer and the vendor (business partner), managing company fnancial management including the company bank and cash books. We conclude this chapter with managing currencies, price management, and product management.
In Chapter 5: Procurement Activities with the prerequisites and preconfigured data at hand, you will continue with the creation of a sample procurement flow. Before producing finished goods in the apparel company, we will defne the raw materials required (to produce these finished goods). Then you will learn how to accomplish an order requisition, purchase order, material receipt, vendor invoice, vendor payment, and also how to reconcile a bank statement. To learn the General Ledger journal created, we will perform some tasks and generate the accounting facts.
In Chapter 6: Landed Costs, Production and Sales Activities, this chapter explains landed cost (for example, we show how to handle transportation charges) which is allocated and assigned to raw materials. Next, you will confgure the bill of material and learn how to manufacture fnished goods. With the available finished goods, you will create quotations, sales orders, shipments, invoices, AR receipts, and also reconcile a bank statement. In this chapter, you will also learn how the General Ledger journal is automatically generated by the ADempiere system.
In Chapter 7: Accounting Information and Confguration, you will learn about the central accounting confguration in ADempiere. You will learn how to manage the Account Element (list of company accounts). You will also learn the Accounting Schema in more detail, and will have a hands-on experience of what the effects of modifying the configuration are. An example of how to avoid the Intercompany Due/To journal, avoid the product inventory clearing journal, commitment accounting, and configuring GL distribution will also be shown. At the end of this chapter, Product Cost will be explained
In Chapter 8: Managing Inventory, you will learn about the various product attributes (for example, registering lot number, color, and so on) and how to work with these attributes. This chapter will guide you through the setup of attribute information, for both raw materials and finished goods. We will continue our discussion with managing internal use of the inventory, managing physical inventory that can be used to perform stock counting, and a way to migrate the existing material. We’ll also discuss about how to perform inventory movement with or without creating a confrmation while receiving the material.
In Chapter 9: Workfow, you will learn about how all the ADempiere documents, such as Purchase Requisition, Purchase Order, MM Receipt, and so on, implement the workflow by default. We’ll discuss the workflow concept and give some examples on how to implement document process, document value, and general workflow. Through these examples, we’ll guide you on how to perform the approval procedure with the help of the document process workflow. You can notify certain people through e-mail if needed. While running a document workflow, we can monitor the workflow progress or even cancel the workflow. You will be guided on how to perform these tasks.
In Chapter 10: Reporting, you will be introduced to the Reports and Print features. This chapter will explain what a print format is and how to set up a default print format for a document such as Purchase Order. You will also be informed about how the ADempiere window finds its print format template. You will learn how to customize standard reports by altering the logo, header layout, and detail layout. As an organization has its unique list of accounts, we will conclude this chapter by showing how to create and configure our own financial reports, which can be used to measure the organization’s performance.
In Chapter 11: Importing Data, you will learn about the importing mechanism through ADempiere. This will involve activities, such as determining import loader format, preparing the data source, loading the data, and conclude with the importing activities. Based on the predefined loader format, you can practice preparing a source files and importing business partners, products, currency rates, GL journals, Orders, Invoices, Inventories, and Bank Statements.
In Chapter 12: Implementing Security, we will finish this book by showing you how ADempiere security works. We will guide you through managing user IDs and creating roles. While constructing a role, we will show the various attributes involved, such as access all orgs, maintain change log, and so on. Here, you will learn how to assign rights to access a window, identify a process, and give rights to it, how to register document access, and manage form access. Then, with an example, we will show you how to perform the access security rule for records, how to restrict access to tables, columns, reports, and export facilities. We will conclude this chapter by showing you the process of obscuring information in ADempiere.
Get the details of table of contents of the book here.
ADempiere is an open community. Wherever you are and whatever is your expertise, you can join us through our Internet Relay Chat (IRC) channel. You can access this website  to access our IRC channel. Enter your nickname and set #adempiere as the channel. You can meet many ADempiere developers, consultants, or end-users around the world and say hello to them.
Moreover, there is a forum  available, which can be used to find any information and to express your interest. There are some groups such as Functional-ERP, Functional-Financials, and Help that can be used to share and answer your ADempiere-related questions. When posting any issues through our ADempiere forum, make sure to check the aim of the group created. For example, Functional-Financials will be dedicated to discuss any issues related with Finance and the accounting parts of ADempiere. When asking any issues through the ADempiere forum, it is wise to check out our friendly rules .
So, don’t wait! Join us now.