Book Image

ADempiere 3.4 ERP Solutions

Book Image

ADempiere 3.4 ERP Solutions

Overview of this book

Enterprise resource planning (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 efficiently, streamline different processes, lower costs, and improve the efficiency levels without too much complexity. This practical book offers a comprehensive understanding of ADempiere and a look at its 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 configuring the company structure and the initial client set up. You can start working with ADempiere immediately because this book will get you up and running quickly and assumes no knowledge or experience of working with ADempiere. ADempiere3.4 ERP Solutions enables you to set up the accounting parts, define 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 workflow and the important function of managing the inventory. Activities such as making user-defined financial reports, procedures on importing data, and security will be covered in detail, and you will also learn about the application dictionary. ADempiere generates accounting facts/journals automatically. In this book, you will understand the impact of these accounting facts in detail. This book will give you a comprehensive study on how to easily implement ADempiere and make the best use of this open source ERP system.
Table of Contents (18 chapters)
ADempiere 3.4 ERP Solutions
Credits
About the Author
About the Reviewers
Preface
Index

Importing Invoices


Both, the Invoice (Vendor) and Invoice (Customer) can be imported. Again, the Is Sales Trx will indicate the type of document. Here, we should practice creating both invoices, based on prior import order data activities.

Creating the Invoices Import Loader Format

In the Import Loader Format window, we'll add and save the following information on the Import Format tab:

  1. Set the Organization field to *.

  2. Set the Name field to Import Invoices.

  3. Set the Table field to I_Invoice (shown I_Invoice_Import Invoice in the option).

  4. Set the Format field to Comma Separated.

Next, we jump to the Format Field tab. The I_Invoice table contains 58 columns that can be used during construction of the Invoice Import Loader Format.

In this example, we'll use the ten most commonly-used columns:

Field\Data

1st data

2nd data

3rd data

4th data

5th data

Sequence

10

20

30

40

50

Name

BPartner Key

Doc Type

Doc No

Currency Id

Date Invoiced

Column

BpartnerValue_Business Partner Key

DocTypeName_Document...