ADempiere 3.4 ERP Solutions

ADempiere 3.4 ERP Solutions

by Bayu Cahya Pamungkas
Released December 2009
Publisher(s): Packt Publishing
ISBN: 9781847197269

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Implementing an Enterprise Resource Planning (ERP) system in your organization can be a smooth process when you follow this ADempiere tutorial. From understanding the basics to customizing for your own needs, it’s a great intro to an excellent system.

  • Successfully implement ADempiere—an open source, company-wide ERP solution—to manage and coordinate all the resources, information, and functions of a business
  • Master data management and centralize the functions of various business departments in an advanced ERP system
  • Efficiently manage business documents such as purchase/sales orders, material receipts/shipments, and invoices
  • Extend and customize ADempiere to meet your business needs
  • Written in a clear and practical manner, this book follows a realistic case-study example enabling you to learn about ADempiere fundamentals and best practices along the way

In Detail

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

  1. ADempiere 3.4 ERP Solutions
    1. Table of Contents
    2. ADempiere 3.4 ERP Solutions
    3. Credits
    4. About the Author
    5. About the Reviewers
    6. Preface
      1. About this book
      2. What this book covers
      3. Getting involved with the ADempiere project
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Errata
        2. Piracy
        3. Questions
    7. 1. ADempiere Installation
      1. ADempiere hardware and operating system requirements
      2. Installing the Sun Java Development Kit (JDK)
        1. Obtaining JDK/JRE
        2. Installing JDK/JRE
          1. JDK installation on the ADempiere server computer
          2. JRE installation on the ADempiere client computer
        3. Configuring Java system variables and the Windows path
        4. Verifying system variables and the Windows path
      3. Installing databases
        1. Obtaining PostgreSQL databases
        2. Installing PostgreSQL databases
        3. Adding the PostgreSQL path
        4. Verifying the additional PostgreSQL path
        5. Configuring PostgreSQL
          1. Modifying the client authentication configuration file
          2. Verifying the PostgreSQL configuration file
        6. Configuring the firewall to allow database connections
      4. Installing ADempiere on the server side
        1. Downloading the ADempiere core installation files
        2. Downloading the latest ADempiere patch files
          1. Obtaining the ADempiere application patch files
          2. Obtaining the ADempiere database migration script
        3. Verifying the ADempiere binary files
        4. Extracting the ADempiere core installation files
        5. Applying the ADempiere application patch files
        6. Creating an ADempiere PostgreSQL database
          1. Creating a PostgreSQL new login role
          2. Creating an ADempiere database
        7. Configuring the ADempiere server
        8. Importing the initial ADempiere database
          1. Applying the database migration script
        9. ADempiere server memory management
        10. Starting up the ADempiere application server
      5. Installing ADempiere on the client side
        1. Web Start client installation
        2. Verifying the ADempiere client installation
      6. Reading the ADempiere 3.4.2s release notes
      7. Summary
    8. 2. Exploring the ADempiere Client and Performing Tasks
      1. The Connection aspect of ADempiere
        1. Checking the ADempiere client version
        2. The predefined user ID and password
        3. Understanding the Client and System users
        4. Changing our ADempiere server connection
        5. Which ADempiere server are we working on?
      2. Managing ADempiere client
        1. Working with the Menu
          1. Menu Icon
          2. Accessing menus
          3. Menu Lookup and creating shortcuts
          4. User preferences
            1. More on the Cache Window option
          5. Parts of the ADempiere window
            1. More on Record Info
            2. OK or Cancel button in the window
          6. Maintaining a log of data changes
          7. Standard window fields
            1. Client and Organization fields
            2. Active checkbox fields
      3. Performing tasks
        1. Data management
        2. Data navigation
        3. Other tasks
        4. More on Lookup records
          1. Setting additional search criteria
        5. More examples on the use of Zoom Across
        6. Field context menu
          1. Zoom
          2. ReQuery
          3. Value preference
      4. Summary
    9. 3. Exploring Company Structures and the Initial Client Setup
      1. Sample apparel company structure
      2. ADempiere company structures
      3. Managing the Chart of accounts template
        1. Exploring the accounting format template files
        2. Account editor tools
      4. Creating a new ADempiere client
      5. Reviewing your new ADempiere client creation
        1. Setting additional organizations
          1. Creating the organization type
          2. Creating an additional organization
          3. Updating organization information
        2. Setting up an additional warehouse
          1. Altering the existing default warehouse and locators
          2. Adding extra warehouses and locators
        3. Re-importing the chart of accounts
          1. Import File Loader
          2. Import Account
      6. Taking a look at the other configuration parts
        1. Accounting schema
        2. Calendar Year and Period
          1. Creating a new year and periods
          2. Opening document types
          3. Period Closed error message
        3. Accounting processor
          1. Automatically posting documents
          2. Common errors during manual posting
      7. Summary
    10. 4. Setting up Master Data and Knowing its Accounting Configuration
      1. Introduction to master data accounting configuration
        1. Example of a Product's accounting configuration
        2. The meaning of HQ-14120-_-_-_-_
        3. Account combination
          1. Common rules when creating an account combination
          2. Creating a new account combination
        4. Changing the account combination of the ADempiere default account
          1. Account alias
          2. Altering the Product Asset default account
      2. Managing a Business Partner
        1. Business Partner Group
          1. Grouping criteria
          2. Accounting configuration
          3. Creating a new business partner group
        2. Business Partner
          1. Registering a new Vendor
          2. Vendor accounting configuration
          3. Registering a new Customer
          4. Customer accounting configuration
      3. Company financial management
        1. Managing your bank information
          1. Registering your bank information
          2. Registering a bank account document
          3. Bank account configuration
        2. Managing a Cash Book
          1. Configuring your own cash book
          2. Cash book accounting configuration
        3. Introduction to Charge
          1. Preparing new account combinations for Charge
          2. Creating a new type of Charge
      4. Using multiple currencies
        1. Currency
          1. Deactivating unneeded currencies
        2. Currency conversion rate types
          1. Creating a new currency type
        3. Currency rates
          1. Entering new currency rates
          2. Entering reciprocal rates
      5. Price management
        1. Managing Price List Schema
          1. Registering a new price list schema
        2. Creating a Price List
          1. Registering a new Price List
          2. Creating a Price List version
      6. Product management
        1. Product Type
        2. Product configuration
          1. Creating a Product Category
          2. Product Category accounting configuration
        3. Creating a new Product
          1. Preparing a new unit of measurement
          2. The Product tab
          3. The Purchasing tab
          4. The Price tab
      7. Summary
    11. 5. Procurement Activities
      1. Introduction to the ADempiere Document
      2. Working on a Purchase Requisition
        1. Creating a Purchase Requisition manually
        2. Working with Replenish Reports
          1. Setting up replenish information
          2. Setting up the default Price List
          3. Completing the replenish information
        3. Accounting facts
      3. Working with Purchase Orders
        1. Creating a Purchase Order manually
        2. Creating a Purchase Order from a Purchase Requisition
          1. Accounting facts
      4. Receiving material
        1. Receiving materials with a Purchase Order reference
          1. Accounting facts
        2. Receiving material without a Purchase Order reference
        3. Posting error
        4. Matching a Purchase Order to a Receipt
          1. Accounting facts
        5. Matched Purchase Orders
          1. Accounting facts
      5. Managing vendor invoices
        1. Invoicing with a Material Receipt reference
          1. Accounting facts
        2. Invoicing without a Material Receipt reference
          1. Accounting facts
        3. Matching an Invoice to Material Receipt documents
        4. Evaluating Matched Invoices
          1. Accounting facts
        5. Summary of Material Receipt and Invoice (Vendor) accounting facts
      6. Making a payment to the vendor
        1. Outstanding liabilities
        2. Payment Selection
          1. Creating a list of unpaid invoices
          2. Creating a payment proposal
          3. Payment Print/Export
        3. Account Payable payments
          1. Accounting facts
        4. Viewing payment allocation
          1. Accounting facts
        5. Bank Statement
          1. Entering Bank Statement information
          2. Entering a Bank Statement Line
          3. Accounting facts
        6. Summary of Payment, Allocation, and Bank Statement accounting facts
        7. Cash payment
          1. Cash Type
        8. Invoice cash payment
          1. Accounting facts
        9. Cash Payment Allocation
          1. Accounting facts
        10. Summary of Cash Payment and Cash Allocation accounting facts
      7. Summary
    12. 6. Landed Costs, Production, and Sales Activities
      1. Activating the accounting processor
      2. Landed costs
        1. Prerequisite configuration
          1. Entering an additional business partner
          2. Creating a new account combination
          3. Setting transportation charges
          4. Setting a new cost element
          5. Altering the product cost adjustment default account
          6. Creating additional Price Lists
        2. Registering for the transportation charges
          1. Cost distribution type
          2. Expected distribution value
          3. Entering our transportation cost
          4. Accounting facts
      3. Manufacturing finished goods—shirts
        1. Bill of material (BOM)
          1. Entering the bill of material information
        2. Expense type of product as a part of bill of material
          1. Creating an overhead product category
          2. Creating labor and electricity products
          3. Altering the product's default account
          4. Setting up the product's standard cost
          5. Registering labor and electricity products into the Shirt's BOM
        3. Production
          1. Accounting facts
      4. Proposal or Quotation document
        1. Introduction to Proposal and Quotation
        2. Setting up a product's sales price
        3. Entering a Proposal or Quotation document
      5. Sales Order
        1. Proposal conversion to a Standard Order
        2. Examining the resulting standard order document
          1. Accounting facts
      6. Shipments
        1. Generating Shipments
        2. Shipment (Customer)
          1. Shipment confirmation
          2. Updating the Shirt Finished Goods standard cost
          3. Accounting facts
      7. Generating customer invoices
        1. Generating invoices using Generate Invoices (manual)
        2. Examining the Invoice (Customer) window
          1. Accounting facts
      8. Account receivable payment
        1. Customer payment
          1. Accounting facts
        2. Payment allocation
        3. View allocation
          1. Accounting facts
        4. Void and Reset allocation
          1. Reset allocation
          2. Void allocation
        5. Bank statement
          1. Accounting facts
        6. Summary of Account receivable payment accounting facts
      9. Managing direct sales
        1. Preparing cash books
        2. Entering a sales order
        3. Unveiling POS Order transaction workflow
        4. Accounting facts
      10. Summary
    13. 7. Accounting Information and Configuration
      1. Managing ADempiere accounts
        1. Chart of accounts
        2. A journey through the ADempiere list of accounts
        3. Adding more accounts
          1. Summary accounts option
          2. Document Controlled option
          3. Post Actual, Budget, and Statistical options
      2. Introducing accounting dimensions
      3. Re-posting a document
      4. A walkthrough of the Accounting Schema
        1. Exploring the Accounting Schema tab
          1. GAAP
          2. Commitment Type
          3. Accrual- or cash-based accounting
          4. Costing method and costing level
          5. Currency
          6. Periods controlling
          7. Use Account Alias
          8. Post Trade Discount
          9. Post services separately
          10. Explicit Cost Adjustment
          11. Allow Negative Posting
          12. Post if Clearing Equal
        2. The Account Schema Element tab
          1. Adding campaign information
          2. Registering another account schema element
          3. Deactivating the account schema element
          4. Avoiding the Intercompany Due From/To journal entries
        3. The General Ledger and Defaults tabs
      5. Avoiding Product Inventory Clearing journal entries
        1. Prerequisites
        2. Testing the configuration
          1. Accounting facts
      6. Practicing commitment accounting
        1. Prerequisites
        2. Requisition reservation
          1. Accounting facts
        3. Purchase Order Commitment and Reservation
          1. Accounting facts
        4. Matched Invoices commitment release
          1. Accounting facts
      7. General Ledger distribution
        1. Concept of GL distribution
          1. Distribution tab configuration
          2. Line tab configuration
        2. Sample of GL distribution case
          1. Configuring GL distribution
        3. Sample transactions and accounting facts
          1. Creating a new account combination
          2. Creating a new General Ledger Journal transaction
      8. Product costs information
      9. Summary
    14. 8. Managing Inventory
      1. Introducing Product Attributes
        1. Attributes for a raw material's product
          1. Registering color attribute configuration
          2. Registering the vendor serial number configuration
          3. Registering additional information (description)
          4. Registering internal number references (lot number)
          5. Binding raw material attributes into an Attribute Set
          6. Registering attributes for a raw material product
        2. Example of using raw material product attributes
          1. Creating a new Purchase Order using a material that uses attributes
          2. Entering attribute information during Material Receipt
        3. Tracking raw material related information using its attribute information
          1. Tracking using the Attribute Set Instance window
          2. Defining additional search criteria
        4. Attributes for Shirt finished goods products
          1. Registering size attribute configuration
          2. Registering a lot number to identify production identity
          3. Registering the internal number for shipment references
          4. Creating an Attribute Set for the Shirt product
          5. Attaching an attribute set to finished goods products
        5. Example of using product attributes on the Shirt finished goods product
          1. Attaching attributes during production activities
          2. Searching for the Shirt product by its attributes
          3. Assigning information during shipment activities
      2. Managing internal use of inventory
        1. Creating advertising and promotion types of charge
        2. Sample usage of Internal Use inventory
          1. Accounting facts
        3. Tracking inventory transactions
      3. Managing Physical Inventory
        1. Stock counting and reconciliation
          1. Accounting facts
        2. Migrating an existing raw material into ADempiere
          1. Creating a migration product category
          2. Creating a migration product
          3. Setting a product's product costs
          4. Performing migration activities
          5. Accounting facts
      4. Moving Inventory
        1. Movement between locations in different warehouses and / or different organizations
          1. Setting up the In-Transit Material Movement document
          2. Practising Moving Inventory with confirmation
          3. Confirming receipt of full material quantity
          4. Accounting facts
          5. Confirmation of receiving with scrapped material
          6. Confirmation of receiving with partial material
        2. Movement among locations in the same warehouse
      5. Summary
    15. 9. ADempiere Workflow
      1. Knowing the General workflow—a step-by-step guide
        1. Example of general workflow
        2. Constructing our own general workflow
        3. Attaching general workflow to a menu
      2. Understanding ADempiere workflow
        1. Knowing the workflow for an ADempiere document
        2. Activity/Node flow
        3. Setting up transition among Activities/Nodes
        4. Node's Action
        5. Node's workflow responsible
          1. Responsible Type
          2. Setting up a new workflow responsible
      3. Document process workflow
        1. Setting up User Choice actions
          1. Finding the person with approval rights
        2. Sample of approval workflow implementation
          1. Initiating a requisition document
          2. Approving the requisition document
          3. Monitoring workflow progression
          4. Cancelling a workflow in progress
        3. Setting up E-mail actions
          1. Activating the e-mail feature
          2. Setting up e-mail for end users
          3. Setting up a mail template
          4. Altering workflow configuration
          5. Testing the e-mail notification configuration
        4. Setting up an application process's action
          1. Finding the internal ADempiere process identity name
          2. Identifying a parameter for a certain ADempiere processes
          3. Additional workflow configuration
          4. Testing the application process configuration
        5. Setting up a Variable's action
          1. Configuring the set attribute action
          2. Testing the set variable workflow
      4. Document value workflow
        1. Setting up a new mail template
        2. Defining configuration
        3. Testing the document value workflow
        4. Document value logic format
          1. Document and Evaluation Value
          2. Operator
        5. Multiple logic
        6. SQL document value logic format
      5. Summary
    16. 10. Reporting Management
      1. Introduction to the ADempiere standard printing feature
        1. Accessing the Report button
          1. Working with the Drill down feature
          2. Working with the Drill across feature
        2. Printing a report
          1. Introducing print format templates
          2. Sending e-mail, archiving reports, and exporting
        3. How the ADempiere window finds its print format templates
          1. Purchase Order and Sales Order
          2. Invoice
          3. Payment
          4. Shipment (Customer) and Material Receipt
      2. Customizing Reports
        1. Creating new print format templates
          1. Duplicate Order Line print format
          2. Duplicate Order Header print format
          3. Setting the purchase order default print format
        2. Altering the logo
        3. Altering another header layout
        4. Altering the detailed purchase order layout
      3. Financial Reporting
        1. Working with the Report Line Set window
        2. Working with the Report Column Set window
        3. Creating a Financial Report
          1. Enabling the List Sources option
      4. Reporting Hierarchy
        1. Configuring a specific financial report
          1. Setting up a new summary product
          2. Setting up a Summary of Products Tree
          3. Setting Tree Maintenance
          4. Verifying the Summary of Products Tree
          5. Setting up the Summary of certain products reporting hierarchy
          6. Testing our sample reporting hierarchy reports
        2. More details on the summary financial report
          1. Setting up a new summary business partner
          2. Setting up a Summary of BP Tree
          3. Setting Tree Maintenance
          4. Verifying the Summary of BP Tree
          5. Setting up a more specific reporting hierarchy
          6. Executing a more specific financial report
      5. Info window
      6. Integration with JasperReports
      7. Summary
    17. 11. Importing Data
      1. ADempiere's import mechanism
        1. Determining the Import Loader Format
        2. Preparing the data source
        3. Loading data with the Import File Loader
        4. Import activities
      2. Import the Business Partner information
        1. Creating the BPartner Import Loader Format
        2. Preparing the Business Partner data files
        3. Loading the Business Partner data
        4. Importing the Business Partner data
        5. Import Error Message sample
      3. Importing Products
        1. Creating the Product Import Loader Format
        2. Preparing Product data files
        3. Loading Product data
        4. Importing Product data
      4. Importing currency rates
        1. Creating the Daily currency rates Import Loader Format
        2. Identifying Search Key information
        3. Preparing Currency rates data files
        4. Loading Currency rates data
        5. Importing Currency rates data
      5. Importing General Ledger journal entries
        1. Creating the GL journal Import Loader Format
        2. Preparing GL journal data files
        3. Loading GL journal data
        4. Importing GL journal data
      6. Import Orders
        1. Creating the Order Import Loader Format
        2. Preparing the Purchase Order data files
        3. Loading the purchase order data
        4. Importing Purchase Order data
        5. Sales Order data import sample
      7. Importing Invoices
        1. Creating the Invoices Import Loader Format
        2. Preparing Invoice Vendor data files
        3. Loading Invoice Vendor data
        4. Importing Invoice Vendor data
        5. Invoice Customer data import sample
      8. Importing Inventory
        1. Creating the Inventory Import Loader Format
        2. Preparing Inventory data files
        3. Loading Inventory data
        4. Importing Inventory data
      9. Importing a Bank Statement
        1. Creating the Bank Statement Import Loader Format
        2. Preparing Bank Statement data files
        3. Loading Bank Statement data
        4. Importing Bank Statement data
      10. Summary
    18. 12. Implementing Security
      1. Managing ADempiere user IDs
        1. Creating a user ID in the system
      2. Managing user ID access control
        1. Introduction to ADempiere roles
        2. Creating a new ADempiere role
          1. Attaching a user ID to a specific role
          2. Assigning organization access to a user ID
          3. Working with the Access all Orgs option
          4. Working with the Maintain Change Log option
          5. Working with the Show accounting option
          6. Working with the Can Report option
          7. Working with the Can Export option
          8. Accessing Info Window
          9. Assigning Window Access
          10. Identifying Process Access
          11. Registering Process Access
          12. Introduction to Document Action Access
          13. Registering Document Action Access
          14. Managing Form Access
      3. Recording access security rules
        1. Enabling Personal Lock
        2. Blocking access to certain records
        3. Restoring access to certain blocked records
        4. Using Dependent Entities
      4. Working with Role Data Access in detail
        1. Restricting Table access
        2. Restricting Report access
        3. Restricting Export access
        4. Restricting Column Access
      5. Obscuring information
        1. Enabling the encrypted feature
        2. Working with the Obscure feature
      6. Summary
    19. Index

Product information

  • Title: ADempiere 3.4 ERP Solutions
  • Author(s): Bayu Cahya Pamungkas
  • Release date: December 2009
  • Publisher(s): Packt Publishing
  • ISBN: 9781847197269