p. 1

adempiere 3.4 erp solutions design configure and implement a robust enterprise resource planning system in your organization by using adempiere bayu cahya pamungkas birmingham mumbai

[close]

p. 2

adempiere 3.4 erp solutions copyright © 2009 packt publishing all rights reserved no part of this book may be reproduced stored in a retrieval system or transmitted in any form or by any means without the prior written permission of the publisher except in the case of brief quotations embedded in critical articles or reviews every effort has been made in the preparation of this book to ensure the accuracy of the information presented however the information contained in this book is sold without warranty either express or implied neither the author nor packt publishing and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book packt publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals however packt publishing cannot guarantee the accuracy of this information first published december 2009 production reference 1111209 published by packt publishing ltd 32 lincoln road olton birmingham b27 6pa uk isbn 978-1-847197-26-9 www.packtpub.com cover image by vinayak chittar vinayak.chittar@gmail.com

[close]

p. 3

credits author bayu cahya pamungkas reviewers colin rooney heng sin low praneet tiwari acquisition editor sarah cullington development editor amey kanse technical editors hithesh uchil mayuri kokate copy editor leonard d silva indexer rekha nair project coordinator zainab bagasrawala proofreader dirk manuel graphics nilesh mohite production coordinator aparna bhagat cover work aparna bhagat editorial team leader akshara aware project team leader priya mukherji

[close]

p. 4

about the author bayu cahya pamungkas has experience of working in various financial and manufacturing industries he is currently employed as a functional consultant on both financial and manufacturing domains for a leading proprietary erp system he works on the implementation of project management software for apparel industries and is also involved in the implementation of electronic data interchange edi software with his experience and background he established his own consulting company and implements adempiere for customers around the world currently bayu also teaches and implements adempiere libero manufacturing a new feature in adempiere 3.5 he is an official adempiere committer and shares his thoughts through his blog at http sistematika.web.id if you need adempiere professional services then you can reach his team at consulting@sistematika.web.id i would like to thank jesus christ who guides me and who gave me the ability to finish the book all of the reviewers who gave their invaluable advice the entire adempiere community that directly or indirectly supported this adempiere book and the people at packt publishing who helped me realize this book my wife rossy and my children yohanes and moses thank you for all your love it s an honor to have you in my life.

[close]

p. 5

about the reviewers colin rooney is a founding member of the adempiere project and is a strong advocate of free and open source software and its use by businesses to reduce risk reduce costs and be more flexible born in dublin ireland colin has been involved in the development and deployment of business information systems since he began his it career at germany s nixdorf computers in 1986 from there colin embarked on a long career working with many of europe s biggest multinational companies on projects in a wide range of business areas from manufacturing to services and crm to accounting after sixteen years of living and working in several countries across europe in 2002 colin returned to his native ireland from where he now provides a variety technical and business services primarily based around adempiere to clients via openbiz.ie thank you to all of those in the adempiere community who have helped make adempiere one of the most popular and best business solutions available today thank you also to all of those who have had the wisdom to realize that collaboration and sharing is the way for us all to achieve the most it takes courage to be the first to step forward so i thank you all for your enlightenment and bravery.

[close]

p. 6

heng sin low living in the city of petaling jaya malaysia is one of the most active committers of the adempiere erp project at sourceforge he has been into software development since 1997 performing business application development for small and big enterprises he started his software development journey using the once-popular powerbuilder tool integrated into the oracle database as the world shifted to java programming heng sin low shifted his focus to java in 2001 before joining the adempiere project he was briefly engaged with the castor and webwork open source project he is now the main maintainer of the zk web client for adempiere his other major contributions include the porting of adempiere to postgresql at the time of writing the book sin low was working at idalica m sdn bhd in malaysia which is a development subsidiary of idalica corporation usa praneet tiwari holds a master of business administration from the indian institute of management bangalore and a master of technology in computer science from the indian institute of technology delhi he has been working on integrating adempiere with other enterprise class software such as glassfish mysql and opends his interest areas include open source software modeling of fixed income securities bioinformatics string algorithms abstract algebra and multivariate analysis he is currently working with sun microsystems he can be reached at praneet.tiwari@gmail.com and praneet.tiwari@yahoo.com i want to thank my parents for the immense faith they have put in me and my wife for her boundless patience.

[close]

p. 7

table of contents preface chapter 1 adempiere installation adempiere hardware and operating system requirements installing the sun java development kit jdk obtaining jdk/jre installing jdk/jre configuring java system variables and the windows path verifying system variables and the windows path installing databases obtaining postgresql databases installing postgresql databases adding the postgresql path verifying the additional postgresql path configuring postgresql configuring the firewall to allow database connections installing adempiere on the server side downloading the adempiere core installation files downloading the latest adempiere patch files verifying the adempiere binary files extracting the adempiere core installation files applying the adempiere application patch files creating an adempiere postgresql database creating a postgresql new login role creating an adempiere database obtaining the adempiere application patch files obtaining the adempiere database migration script modifying the client authentication configuration file verifying the postgresql configuration file jdk installation on the adempiere server computer jre installation on the adempiere client computer 10 10 11 11 14 15 16 16 17 17 18 19 20 21 21 21 23 25 25 26 1 9 12 13 19 20 22 23 26 27

[close]

p. 8

table of contents configuring the adempiere server importing the initial adempiere database adempiere server memory management starting up the adempiere application server installing adempiere on the client side web start client installation verifying the adempiere client installation reading the adempiere 3.4.2s release notes summary applying the database migration script 27 30 32 32 33 34 34 35 36 38 38 38 40 40 41 42 43 31 chapter 2 exploring the adempiere client and performing tasks 37 the connection aspect of adempiere checking the adempiere client version the predefined user id and password understanding the client and system users changing our adempiere server connection which adempiere server are we working on managing adempiere client working with the menu menu icon accessing menus menu lookup and creating shortcuts more on the cache window option user preferences 46 48 50 51 52 52 53 54 55 57 58 44 44 45 48 49 50 parts of the adempiere window maintaining a log of data changes standard window fields performing tasks data management data navigation other tasks more on lookup records client and organization fields active checkbox fields more on record info ok or cancel button in the window 51 51 more examples on the use of zoom across field context menu zoom requery value preference setting additional search criteria 56 summary 61 ii 59 59 60

[close]

p. 9

table of contents chapter 3 exploring company structures and the initial client setup sample apparel company structure adempiere company structures managing the chart of accounts template exploring the accounting format template files account editor tools creating a new adempiere client reviewing your new adempiere client creation setting additional organizations creating the organization type creating an additional organization updating organization information 63 64 65 66 67 68 70 73 74 setting up an additional warehouse re-importing the chart of accounts import file loader import account altering the existing default warehouse and locators adding extra warehouses and locators 76 80 83 84 85 74 74 75 76 78 81 81 taking a look at the other configuration parts accounting schema calendar year and period creating a new year and periods opening document types period closed error message accounting processor summary automatically posting documents common errors during manual posting 87 89 85 85 86 87 88 chapter 4 setting up master data and knowing its accounting configuration introduction to master data accounting configuration example of a product s accounting configuration the meaning of hq-14120 account combination common rules when creating an account combination creating a new account combination account alias altering the product asset default account 91 92 92 93 94 98 changing the account combination of the adempiere default account managing a business partner business partner group grouping criteria 95 95 98 98 100 100 100 iii ]

[close]

p. 10

table of contents accounting configuration creating a new business partner group registering a new vendor vendor accounting configuration registering a new customer customer accounting configuration 101 102 103 105 105 106 business partner 103 company financial management managing your bank information managing a cash book introduction to charge registering your bank information registering a bank account document bank account configuration configuring your own cash book cash book accounting configuration preparing new account combinations for charge creating a new type of charge 106 107 109 110 112 113 114 115 116 117 118 119 119 120 122 107 108 108 109 110 111 111 using multiple currencies currency currency conversion rate types currency rates creating a new currency type entering new currency rates entering reciprocal rates deactivating unneeded currencies 113 114 115 116 price management managing price list schema creating a price list registering a new price list creating a price list version registering a new price list schema 117 118 118 product management product type product configuration creating a new product creating a product category product category accounting configuration preparing a new unit of measurement the product tab the purchasing tab the price tab 121 121 122 123 124 124 summary 127 iv ]

[close]

p. 11

table of contents chapter 5 procurement activities introduction to the adempiere document working on a purchase requisition creating a purchase requisition manually working with replenish reports setting up replenish information setting up the default price list completing the replenish information 129 129 131 131 132 accounting facts working with purchase orders creating a purchase order manually creating a purchase order from a purchase requisition receiving material receiving materials with a purchase order reference receiving material without a purchase order reference posting error matching a purchase order to a receipt matched purchase orders managing vendor invoices invoicing with a material receipt reference invoicing without a material receipt reference matching an invoice to material receipt documents evaluating matched invoices summary of material receipt and invoice vendor accounting facts making a payment to the vendor outstanding liabilities payment selection creating a list of unpaid invoices creating a payment proposal payment print/export accounting facts accounting facts accounting facts accounting facts accounting facts accounting facts accounting facts accounting facts accounting facts 134 136 136 137 138 139 141 142 143 145 147 148 150 152 153 155 156 156 157 132 133 134 138 141 145 147 150 152 154 account payable payments viewing payment allocation 160 161 157 157 159 160 161 [v]

[close]

p. 12

table of contents bank statement summary of payment allocation and bank statement accounting facts cash payment invoice cash payment cash payment allocation summary of cash payment and cash allocation accounting facts summary activating the accounting processor landed costs prerequisite configuration accounting facts accounting facts cash type entering bank statement information entering a bank statement line accounting facts 162 164 165 166 167 168 169 172 172 173 162 163 164 165 166 167 chapter 6 landed costs production and sales activities 171 registering for the transportation charges cost distribution type expected distribution value entering our transportation cost accounting facts entering an additional business partner creating a new account combination setting transportation charges setting a new cost element altering the product cost adjustment default account creating additional price lists 178 173 174 174 176 176 177 178 179 179 181 manufacturing finished goods shirts bill of material bom expense type of product as a part of bill of material entering the bill of material information creating an overhead product category creating labor and electricity products altering the product s default account setting up the product s standard cost registering labor and electricity products into the shirt s bom accounting facts 182 183 184 183 184 185 185 186 187 189 production 188 191 191 192 193 proposal or quotation document introduction to proposal and quotation setting up a product s sales price entering a proposal or quotation document vi ]

[close]

p. 13

table of contents sales order proposal conversion to a standard order examining the resulting standard order document shipments generating shipments shipment customer accounting facts 195 196 196 198 198 199 197 generating customer invoices generating invoices using generate invoices manual examining the invoice customer window account receivable payment customer payment payment allocation view allocation void and reset allocation bank statement summary of account receivable payment accounting facts managing direct sales preparing cash books entering a sales order unveiling pos order transaction workflow accounting facts summary managing adempiere accounts chart of accounts a journey through the adempiere list of accounts adding more accounts summary accounts option document controlled option post actual budget and statistical options accounting facts reset allocation void allocation accounting facts accounting facts accounting facts shipment confirmation updating the shirt finished goods standard cost accounting facts 203 203 204 206 207 208 209 210 212 214 214 214 215 216 216 217 220 220 221 222 200 201 202 206 207 210 211 211 213 chapter 7 accounting information and configuration 219 introducing accounting dimensions 226 223 224 225 vii ]

[close]

p. 14

table of contents re-posting a document a walkthrough of the accounting schema exploring the accounting schema tab gaap commitment type accrual or cash-based accounting costing method and costing level currency periods controlling use account alias post trade discount post services separately explicit cost adjustment allow negative posting post if clearing equal 227 229 229 the account schema element tab the general ledger and defaults tabs avoiding product inventory clearing journal entries prerequisites testing the configuration practicing commitment accounting prerequisites requisition reservation purchase order commitment and reservation matched invoices commitment release general ledger distribution concept of gl distribution sample of gl distribution case sample transactions and accounting facts product costs information summary configuring gl distribution creating a new account combination creating a new general ledger journal transaction distribution tab configuration line tab configuration accounting facts accounting facts accounting facts accounting facts adding campaign information registering another account schema element deactivating the account schema element avoiding the intercompany due from/to journal entries 240 230 230 230 231 232 232 233 234 236 237 237 239 240 242 243 244 245 246 246 247 248 248 249 250 251 252 252 255 256 258 259 247 249 250 251 252 254 255 256 256 viii ]

[close]

p. 15

table of contents chapter 8 managing inventory introducing product attributes attributes for a raw material s product 261 example of using raw material product attributes registering color attribute configuration registering the vendor serial number configuration registering additional information description registering internal number references lot number binding raw material attributes into an attribute set registering attributes for a raw material product 261 263 tracking raw material related information using its attribute information attributes for shirt finished goods products tracking using the attribute set instance window defining additional search criteria creating a new purchase order using a material that uses attributes entering attribute information during material receipt 268 270 272 263 264 264 265 265 267 268 268 270 271 273 274 274 275 276 277 279 280 example of using product attributes on the shirt finished goods product attaching attributes during production activities searching for the shirt product by its attributes assigning information during shipment activities registering size attribute configuration registering a lot number to identify production identity registering the internal number for shipment references creating an attribute set for the shirt product attaching an attribute set to finished goods products 277 managing internal use of inventory creating advertising and promotion types of charge sample usage of internal use inventory tracking inventory transactions managing physical inventory stock counting and reconciliation migrating an existing raw material into adempiere creating a migration product category creating a migration product setting a product s product costs performing migration activities accounting facts accounting facts accounting facts 281 282 282 284 285 285 288 283 287 289 290 290 291 292 moving inventory movement between locations in different warehouses and or different organizations setting up the in-transit material movement document practising moving inventory with confirmation 292 293 293 295 ix ]

[close]