Book Image

ADempiere 3.6 Cookbook

Book Image

ADempiere 3.6 Cookbook

Overview of this book

Table of Contents (16 chapters)
ADempiere 3.6 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

Preface

ADempiere is one of the leading open source ERP products in today's business market. ADempiere offers everything you need to make your business successful. Efficient data management, streamlining business processes, reduction in costs, and minimal complexity.

What this book covers

Chapter 1, Preparing the Ground: This is the starting point. The chapter prepares us for the journey ahead. In this chapter, we would learn how to set up a typical development as well as deployment environment. This chapter introduces the different tools and teaches us how to make use of them in the development.

Chapter 2, ADempiere Customization Part I: In this chapter, we are going to look at the overall customization capability of ADempiere, mainly through the Application Dictionary configuration. The chapter covers topics such as creating a new window, how to customize an existing one, how to create multiple tabs in a window, the search widget, zoom option, and menu tree. A case study-based approach has been taken to explain the practical relevance of each of the topics.

Chapter 3, ADempiere Customization Part II: In this chapter, we will look into the advanced configuration options of ADempiere and topics such as data filtration, using display and default logics, lookup record, dynamic validation, customizing print format, working with the models, callouts, processes, and toolbars.

Chapter 4, Web Services: This chapter covers the recipes and the steps required to get the Web services capability built into the ADempiere. The chapter explains the different types of ADempiere Web services and how to make use of them.

Chapter 5, VirtueMart Integration: This chapter introduces Joomla!'s VirtueMart shopping cart component and its integration with ADempiere. The recipes try to provide the required information using which we shall be able to use VirtueMart as the web store.

Chapter 6, JasperReports with ADempiere: JasperReports is at the heart of ADempiere's reporting framework. In this chapter, you learn how to set up the environment, how to develop a new report with/without a database view, how to make use of ADempiere's context in a report, using sub-reports, and how to use a custom report for printing.

Chapter 7, PayPal Integration: This chapter is dedicated to the integration of PayPal with ADempiere. The recipes include setting up the environment, making use of the PayPal APIs, and the specific use cases, like, making payment to a PayPal account, receiving payment from a PayPal account, and the Instant Payment Notification.

Chapter 8, Equifax Integration: Equifax is a popular credit reporting agency, which is used to find out the information pertaining to the customers to evaluate his/her credit status and validity about information provided by the customer. In this chapter, we would discuss about integrating ADempiere with Equifax. The chapter covers the different services offered by Equifax, such as, the address matching service, bank validation service, company matching service, consumer bureau service, and the password change service.

Chapter 9, Mondrian Integration for Analysis: In this chapter, we will learn about the Open Source OLAP engine Mondrian, and understand how to use it and integrate it with ADempiere to provide the analysis capability on top of the existing ADempiere schema. The chapter covers the concepts such as cube, slicing, dicing, and the provided recipes show how to build them using Mondrian.

Chapter 10, E-mail Integration with Mozilla Thunderbird: This chapter contains the recipes demonstrating the steps required to integrate Mozilla Thunderbird (an e-mail client) with ADempiere. It takes us through the steps needed to build a Thunderbird add-on for ADempiere, using which the user can import the e-mail IDs of the contact, setup in ADempiere, and use them to compose mails.

What you need for this book

  • Eclipse Galileo (Eclipse for JEE development)

  • JBoss 4.2.3 GA

  • JDK 1.6

  • PostgreSQL Database 8.x

  • SVN client (for example, TortoiseSVN)

  • soapUI for Web services, VirtueMart, Thunderbird, and so on

Who this book is for

If you want to easily implement ADempiere in your organization, this book is for you. This book will also be beneficial to system users and administrators who wish to implement an ERP system. Only basic knowledge of ADempiere is required. This cookbook will build on that basic knowledge equipping you with the intermediate and advanced skills required to fully maximize ADempiere. A basic knowledge of accounting and the standard business workflow would be beneficial.

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "In this recipe, we saw how we can use the Ant build file build.xml to compile the code and create the installation packages (.zip and .tar.gz files)."

A block of code is set as follows:

SELECT ad_client_id,c_momstatus_id,name,isdefault,value FROM c_momstatus;

Any command-line input or output is written as follows:

java mondrian.test.loader.MondrianFoodMartLoader -verbose -tables -data -indexes -jdbcDrivers="org.postgresql.Driver,sun.jdbc.odbc.JdbcOdbcDriver" -inputFile=C:\mondrian\demo\FoodMartCreateData.sql -outputJdbcURL="jdbc:postgresql://localhost/foodmart" -outputJdbcUser=adempiere360 -outputJdbcPassword=adempiere

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Click on the Product link, uncheck Patio Table and click on the OK button".

Note

Warnings or important notes appear in a box like this.

Note

Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to, and mention the book title via the subject of your message.

If there is a book that you need and would like to see us publish, please send us a note in the SUGGEST A TITLE form on www.packtpub.com or e-mail.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Note

Downloading the example code for this book

You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

Errata

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/support, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.

Piracy

Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.

Questions

You can contact us at if you are having a problem with any aspect of the book, and we will do our best to address it.