Openbravo ERP 2.40 ReleaseNotes

What is Openbravo ERP 2.40

Featuring many usability improvements, broader functional coverage, performance and security enhancements and many defect fixes, Openbravo ERP 2.40 is the latest release of the leading open source ERP solution.

Release status

Currently Openbravo ERP 2.40 is published in beta status, which means that:

• This release is for ready for general usage, including evaluation and production.
• Given its recent publication, however, this release has not yet been proven in enough live customer deployments to be labeled as a production release.
• We recommend new implementation projects to start with this release
• We recommend existing production deployments not to upgrade to this release until it reaches production status.
• An upgrade path is available from earlier releases to 2.40 beta.
• An upgrade path will be available from 2.40 beta to 2.40 production

New Features

Usability Enhancements

• Keyboard Operations & Shortcuts: this feature dramatically improves the usability of Openbravo ERP by allowing users to fully operate the system using the keyboard only and by providing shortcuts for the most common actions.
• Focus Management: data entry and edit is now streamlined by placing initial focus in a new window in the most logical field rather than in the first one and therefore reducing the number of clicks that are required to complete a transaction. System administrators can further configure this option to optimize data entry for the specific requirements of each implementation.
• Improved Visibility of System Status: through the usage of visual clues, the user interface now better informs users of the status of the system, therefore preventing mistakes and confusion. In particular:
  • Read-only transactions are clearly identified.
  • New animated icons inform users when the system is:
    • Loading a new window
    • Loading data
    • Executing a background process
  • Different icons show when users are editing an existing record or creating a new one.
  • The Save icons are disabled when no change needs to be saved.
• Improved Selectors: all the Selector windows now use the same Ajax grid already present in the grid transactional views and provide:
  • Faster data retrieval and rendering
  • Fixed header that is always visible
  • Sorting of search results
  • Resizable and movable columns

Improved Globalization Support

• Multi-schema Accounting: you can now define and use multiple accounting schemas within your system. This feature enables you to account the same transactions according to different rules, in different charts of accounts, in different base currencies and with a different accounting calendar.
  Organizations with international operations can use this functionality to produce accounting that support both local legal compliance and corporate reporting and consolidation.
• International Bank Account Numbers: you can now define bank accounts according with international number formats for both your organization and your business partners.
• Withholding Tax: you can now manage your entire withholding tax process,from configuration and collection to reporting.
• VAT Register: you can now complete your tax reports by providing VAT registers which provide separate document numbering controls for your VAT transactions.

Broader Functional Scope

• Purchase Requisitions Support: users can now initiate the procurement flow by entering requisitions rather than purchase orders. This enables a clear separation of roles and duties between:
  • The Requestor who expresses a demand for goods or services through a requisition.
  • The Purchasing Specialist who selects the most appropriate supplier based on the organization strategic procurement objectives and generates the purchase order, either manually or automatically based on rules.
• Goods Receipt by PO number: registering the receipt of material in the warehouse is now streamlined by letting users initiate the process by entering the number of the expected purchase order.
• Enhanced Projects & Services module:the Project and Service Management module has been completely reviewed and refactored.
  • Workflow redesigned.
  • The Construction and Service Project windows functionalities has been superseded by the Service Project window.
  • Multiphase Project window now correctly generates Sales Orders.
  • Sales and Purchase Orders created in Service Project window include lines.
  • Automatic selection of the business partner based on project in the Expense Sheet window.
  • Invoiceable and Employee Expenses windows now support read-only data view.
  • Sales Orders created from Invoiceable Expenses can now be completed and processed automatically.
  • Enhanced error messages.
• Historical Salary Category: you can now record the historical salary category of your employees as well as the current one. Using this feature you can correctly perform analysis and reporting of past transactions; for example, you can correctly calculate the cost and profitability of a past project.

New Reports

• Payment Aging Balance Report: this report allows you to review all your pending payments and collections and their relative aging and can be used to optimize your cash flow.
• Budget Report: this report allows you to compare your budget with your actual expenditures and revenues and can be used to monitor progress towards your organization plans and objectives.
• Pareto Report: this report classifies your products according A-B-C categorization based on either quantity on hand or inventory value and can be used to focus your material management attention to the products that are most valuable to your organization.

Enhanced Reports

• Payments Report: you can now run the Payment Report for more than one business partner at a time.

Infrastructure Improvements

• Security Enhancements: the sytem security has been significantly revised and improved. In particular, there is now a stronger segregation of duties between users with administrative roles for the whole system and users with administrative roles for a single client.
• Audit: you can now review who created and last updated each transaction.
• Additional web services: the following additional web services are now available:
  • getCustomers
  • getCustomerInformation
  • updateCustomerInformation
  • getCustomerContactList
  • getCustomerContactInformation
  • getProductsCatalog
  • uploadOrders
• Heartbeat: to help us improving our software quality, you can now optionally configure the Heartbeat which communicates information about your system back to Openbravo which will be used to feedback the development process. To thank you for this valuable information, once the heartbeat is configured, you will receive automatic notifications of available system updates.
• PostgreSQL 8.3 Support: Openbravo ERP 2.40 now supports PostgreSQL in both version 8.2 and 8.3.
• Improved Universal Installer: the Universal Installer has been completely redesigned and it is now smaller, faster and simpler to use.

List of Defects Fixed in Openbravo ERP 2.40

Fixes Included in ERP 2.40 alpha r1

The following bugs affecting Openbravo 2.35 have been fixed in Openbravo ERP 2.40 and included in the 2.40 alpha r1.

• 1667262 Some Spanish translations are not clear or need revision
• 1679256 Impossible to navigate from product to work requirement
• 1679745 Generating standard process (manufacturing).
• 1735765 Field Group no visible
• 1745386 Incorrect default values when Creating From DB in PostgreSQL
• 1747599 Window Employee expenses (Old menu Expenses not reimbursed)
• 1757481 Typo in Work Requirement
• 1761356 The servlet-api.jar is included in the generated war file
• 1761950 Different behaviors among languages on Bank Report
• 1761982 The Warehouse detailed inventory has fields in english
• 1762050 Esquema contable > contabilidad general tab, fiels as *
• 1783091 Cannot assign image to product
• 1787183 Typo on menu entry: Catagory instead of Category
• 1788623 Create Purchase Order from Project do not work
• 1794429 Sales & Customer Invoice reports have same name
• 1803432 ant compile.complete deletes the war file from contenxt
• 1807127 Material Transaction Reports - date exclusive
• 1809743 Incorrect button label in work requirement screen
• 1811346 Grid view results in very large number of db queries
• 1813644 System.gc() should never be called
• 1814037 Internal Consumption error
• 1814345 Invoice Line Selection in Outsourced
• 1814408 Create Accounting reports. Year filter
• 1819557 Country should be mandatory in Initial Client Setup
• 1822022 Delete Client process does not work on postgresql
• 1822198 Error on renderJR when an execption occurred
• 1822705 General ledger report balance column sum
• 1822709 Default accounts
• 1822863 Report shipment analisis
• 1823353 'Detailed Warehouse Inventory' calendars
• 1823418 Inconsistent results on chart of account load
• 1827448 Serbia country and currency
• 1827543 Massive changes on crossed verification fields
• 1828187 Delete client produces two errors
• 1828570 Project type confusion
• 1832302 View USER_OBJECTS compatible for Postgres 8.3
• 1832570 Clean web.xml
• 1833000 jrxml files slow compilation
• 1834234 Grid view fails to display properly
• 1834558 Openbravo admin role windows access
• 1835146 web.xml file has some errors
• 1835149 war file contains openbrav-core.jar twice
• 1836592 Generate Order from project phase fails
• 1838516 Synchronize terminology
• 1838534 BitRock setup fails in Windows
• 1838611 Access level is not checked
• 1839254 Security in HttpSecureAppServlet bugs
• 1839432 General Accounting Report very slow in postgres
• 1839460 No access for selectors
• 1839520 JS calendar component does't work with Finnish translation
• 1839538 Access to callouts and workflows
• 1839552 Error message for workflow with no access
• 1839574 Worker checkbox in Employee tab of Partner
• 1840318 No access for Jasper Reports
• 1840358 Initial Client Setup doesn't work
• 1840377 Pending Goods Receipt does not work properly
• 1840392 Missing trailing newline and borked characters in db files
• 1841560 Amortization selector does not work
• 1842335 Spanish messages when running GL Posting by DB Tables
• 1844904 Create Shipments from Orders doesn't copy delivery location
• 1844919 Task to export database structure and metadata missing
• 1845110 Database model not in sync with database created
• 1845598 Task to compare database model and database created
• 1846093 Bad log message when exporting structure
• 1846485 Spelling mistake: Role information window
• 1846793 Installer and setup tool should set log name to context
• 1847769 Bad default value in table C_DEBT_PAYMENT
• 1849194 log4j.lcf is not created during setup
• 1849917 the product complete selector does not take the warehouse
• 1850221 Sales order document shows Invoice instead of Order
• 1850829 Export PostgreSql model
• 1851253 Conflict with setup-properties-*.bin and build scripts
• 1852729 Procedures definition not properly read
• 1852964 Enabling / Disabling constraints does not log errors
• 1853252 Index loading too slow
• 1853256 Oracle recycle bin not purged after modifying model
• 1853784 Primary keys name not created properly
• 1853856 EditionFieldsData does not compile in PostgreSQL
• 1853888 Triggers dissapear when table is rebuilt
• 1854177 Drop rules not generated properly
• 1854180 Prescript not executed when modifying model
• 1854264 Data is not deleted when updating data
• 1854820 Postgre parameters not properly read
• 1855031 For Postgre BLOB types must be translated to OID
• 1855584 Change property to development.environment.id
• 1855855 Code clean up: Remove System.out.println
• 1857492 TEST table should not be in sourcedata
• 1858407 Remove Yugoslavia from the country list
• 1858522 'Copy details' from Multiphase project
• 1858866 'development.environment.id' leads to errors
• 1858873 Error message in Material Transaction Report
• 1858886 'openbravo-core.jar' and 'WEB-INF' to SVN ignore list
• 1859601 Postgres-Some data error on attributes
• 1859623 Postgres- Error selecting a sequence. Work requirem
• 1859813 Attach description encoding not properly displayed
• 1860390 isPeriodOpen NO
• 1861412 Default PostgreSQL settings at setup-properties
• 1862082 Accents problem with date select
• 1862189 Problem with default dates format
• 1862341 setup-properties generates wrong defaults for PostgreSQL
• 1863028 Install from svn fails with postgresql
• 1863030 README.txt is not up to date in svn
• 1863074 Setup binaries are copied to WEB-INF folder
• 1863366 src_db project: default=null should be equal to no default
• 1864067 ** displays when selecting Business Partner
• 1865878 Name of function C_INVOICE_PERCENTAJE_PAID wrong
• 1867540 The exectureDefaultSQL throw an exception
• 1867652 Incorrect error in decimal time required
• 1867777 All tables are rebuilt when updating in postgre
• 1868309 Inserts does not works in spanish
• 1869451 [ 1868453 ] English fixes
• 1871000 Passwords with more than 10 characters
• 1872622 Export structures in Postgre that does not exists in XML
• 1872626 Correction of typos
• 1873034 Lack of currency symbol in Invoice report
• 1873542 XmlEngine: too many log4j info messages
• 1873872 Multiple Business Partners Selector window
• 1873880 Invoice Customer Report look & feel
• 1873921 context.name should be in Openbravo.properties
• 1874503 'Accounting file' field mandatory
• 1874573 Background accounting process doesn't mind active param
• 1876404 Some text like this should not be exported
• 1878401 Tabs with project info are not savable in PG
• 1878794 NUMBER_TO_TEXT_ES function does not work in PostgreSQL
• 1879633 Error in Application translation check window
• 1881103 Rappel scales: amount from 5 ch. length
• 1881237 On c_country table c_country_id should have reference ID
• 1881705 Force LF (UNIX) newline char in all files in SVN repository
• 1881979 Only active fields should be returned in queries
• 1883392 SampleData and MetaData files and filters need a revision
• 1883842 Hide the fields Current balance and Credit limit
• 1887808 KeyMap class construction
• 1889725 Triggers code cleanup because UPDATE OF
• 1889741 Openbravo PostgreSQL 8.3 compatible
• 1891868 Order line selector does not load partner or product
• 1892033 Get Prices button on Service Project window
• 1895995 Wrong parameter order in call to function m_inout_create
• 1896048 Product and customer selectors do not work
• 1896239 Problems with .settings folder and files using Eclipse IDE
• 1896878 PROC. GENERATE_AVERAGE_COSTS & Reversed GoodsReceipts
• 1899490 Problem PLAN_TABLE in update.database
• 1899509 No setup binaries for multiple platforms and OSs
• 1899518 Base64 encoding uses non standard class from sun.misc
• 1899710 Typo in setup
• 1900882 Unneeded file: config/pool.dtd
• 1901891 Postgres stored proc translator discards exception err msgs
• 1901894 Unpost extremely slow when fact_Acct_cfs records exist
• 1902026 Setup: no license window
• 1902046 Setup: unused variable, base.app
• 1902052 Setup: attachments directory not created by default
• 1902097 setup: bbdd.sessionConfig date not taken from SQL-date
• 1902099 setup: bbdd.sessionConfig NLS_LANGUAGE not selectable
• 1902302 The application gets locked when a callout fails
• 1902737 Postgres prescript has ambiguous to_char & to_number funcs
• 1907156 Invoice Dimensional Report dimensions
• 1908509 DbSourceManager error converting rowncount to PL/PGSQL
• 1909687 Error renumbering in 'Price List Schema' in PostgreSQL
• 1911033 Add the counties of the United Kingdom to the regions table
• 1911779 Business partner on selectors does not work
• 1911935 Files with missing licenses
• 1914248 base.source should be relative
• 1914249 setup tool: base.temp is not used
• 1914276 Have a log4j.lcf and userconfig.xml by default
• 1914293 install.source should not include installWebServices
• 1916887 AP Credit Memo. Inconsistent data for the accounting
• 1925045 Minimum fix in Initial Client Setup
• 1925634 Add translations
• 1926085 Bug in "create amortization" process in Assets
• 1926229 Numbering format does not work
• 1926384 Calendar does not work with some date formats
• 1928341 Use numbering vs string ordination in dimensional rpts
• 1931023 Setup: improve date selection
• 1931046 Setup: log4j in wrong directory
• 1932442 Credit Limit Over regression
• 1936843 AcctServer.IsPeriodOpen, wrong message in the log file
• 1938048 M_PRODUCT_ACCT unique constraint
• 1939533 Help for reports does not work
• 1939540 Expense Sheet Lines: Mandatory fields
• 1940071 Disable Import EDI file functionality
• 1941934 Error compiling Warehouse window
• 1942768 log4j.lcf must exist to start the servlet container context
• 1944705 The date filter in the Offers Report doesn't work correct
• 1945573 export.database.data exports translations in every language
• 1947738 Disabled buttons
• 1948040 Filtering dates in Purchase Order Report does not work prope
• 1948895 Not possible to edit data for employee for BPartner window
• 1948994 Set version to SVN revision instead of dev

The above list assumes 2.35 MP4 as baseline and does not include the bugs that have been fixed in previous 2.35 maintenance packs:

• Bugs fixed in 2.35 MP1
• Bugs fixed in 2.35 MP4
• Bugs fixed in 2.35 MP5

Fixes Included in ERP 2.40 alpha r2

The following bugs, recorded in SourceForge and affecting Openbravo 2.40 alpha r1 have been fixed and included in the 2.40 alpha r2.

• 1619682 IndirectCost - Value
• 1676457 Menu window and it's tree with admin role
• 1678418 C_CASH_POST & ENDINGBALANCE=0
• 1684700 Inconsistent class/file naming with underscore
• 1735865 Message search key too small and more things
• 1737623 Bitrock installer: bad port-test
• 1751814 Message Generating Invoice from Draft Receipt is not correct
• 1762463 Logs contain many outputs in Spanish
• 1767320 Installer cannot find ant binary in some Linux distros
• 1768416 The installer deletes existing database user and database
• 1790462 title inconsistency
• 1808246 User option window. Rol-Org access
• 1809735 Incorrect grammar in message
• 1811334 G/L Journal batch process does not report error properly
• 1818365 incorrect record changes are detected in Roles window
• 1820638 Error: ORA-01439: la columna que desea modificar debe estar
• 1822653 Compile does not copy Actionbutton xml
• 1822856 Java error on Change Payment Status
• 1822932 Inconsistent drill down from trial balance
• 1824274 Installer does not create attach directory
• 1824278 Users with two clients see transactions in wrong one
• 1828957 Product Import fails because of wrong field size
• 1829587 Wrong default directory for PostgreSQL
• 1831693 Installer complaints when PostgreSQL version is right
• 1832488 Can't intoduce password in mail server configuration
• 1832525 Default value with a comma
• 1836389 Error importing taxes from temporal table
• 1836390 Import taxes doesn't work properly
• 1838561 No key found in parent tab: Warehouse
• 1841691 Default image for records without image too small
• 1842320 Product field is not mandatory on Purchase Orde Line
• 1855691 Bad format in BPLocation when Address2 is null in PostgreSQL
• 1860372 ArrayIndexOutOfBoundsException
• 1869149 Field ProductionLine should not be updatable
• 1869223 IN-OUT Report does not work
• 1869255 Import Businnes partner. Error in Address
• 1873431 Enabling an inactive report into an active report
• 1883698 MRP Purchase Plan Lead Time
• 1884287 MRP Planning Method Weighting
• 1889537 C_Commission_process does not work
• 1892607 Creating a duplicated Client shows success message
• 1899462 Sample data changed without reason
• 1899463 ExportGrid: Don't show complete name
• 1899465 AD_PINSTANCE_SEQ' changes when creating a new window
• 1901216 Old DB-XML related code in WadConnection
• 1904142 Balance sheet report
• 1908941 Creating roles with existent names
• 1914198 Create Region
• 1919682 Calculate Standard Cost Error
• 1920730 Search pop-up buttons.
• 1924421 copy from order doesn't work
• 1925926 User Option
• 1927283 Strange behaviour ShowAudit session variable
• 1928372 Copy&Paste does not work in some windowsCtrl+C/Ctrl+V
• 1931062 No feedback when trying to login with a user without roles
• 1931088 Commision field length
• 1931213 Melilla
• 1931995 Retrieving business partner of other clients
• 1932443 Not possible to get any customer with GetByName
• 1932446 Not possible to get any customer with GetBySearchKey
• 1933299 Usernames for Org and Client cannot be same
• 1936575 Incorrect spelling
• 1936613 ReportNotPosted hard coded in Spanish
• 1936766 Security flaw in users setup
• 1937529 Images in non-active tabs
• 1937930 Send Mail Text process does not work
• 1938051 Asset amortization lines
• 1939925 tabs rendering
• 1939950 Read only grids still reacts to Delete Key
• 1940352 Clear Session button doesn't work correct.
• 1942794 Remove buttons when edit action is not allowed
• 1942836 User info window. Warehouse combo
• 1942877 Link Created by and Updated by do not work properly
• 1943175 Test hearbeat button has Warning as title
• 1943668 Generated pages do not allow double quotes (")
• 1943891 I cannot activate Heartbeat
• 1943965 Heartbeat configuration window text is not complete
• 1944108 Ctrl+T does not work on Firefox
• 1944705 The date filter in the Offers Report doesn't work correct
• 1945761 If I have not System role access, I do not see UOM
• 1945770 Creating children for parents from other Org
• 1945812 Read only currency fields has ** on Client field
• 1945860 I can attach files to read only records
• 1945894 Change log for generated window is a mess
• 1945970 Business Partner Search window has a scroll bar
• 1945986 Entering Product on New mode looks like Edit mode
• 1945989 QA-IUI Two question marks when loading menu
• 1948040 Filtering dates in Purchase Order Report does not work prope
• 1948889 Button Create pricelist overwrite values
• 1948956 Strange behavior on Business Partner selector.
• 1948989 Ctrl+S. Doesn't call the call-outs
• 1949463 Hide audit button
• 1950999 Some selectors in selectors don't work 'Enter'
• 1951949 Copy From Settlement does not work
• 1953524 Oracle specific code fails on Postgresql
• 1954264 Can't see the text of the bottoms
• 1954875 You can only create an org at once
• 1956116 Calendar tool don't work in popups
• 1958526 Deprecate AD_COLUMN_SYNC
• 1959533 Hidden label on menu bar on any window
• 1962977 P&L report - Wrong operands calculation
• 1965674 trigger cause failed inserts in postgres
• 1966832 The asset value is rounded when is bigger than 999999.99

The following bugs, recorded in issues.openbravo.com and affecting Openbravo 2.40 alpha r1 have been fixed and included in the 2.40 alpha r2.

• 100 *** Not Found * on User Level combo of Role window
• 143 Ctrl+Backspace does not work as in r2.35
• 151 Wrong layout of options menu on spanish Role Information window
• 162 Can not access to General Ledger Report
• 163 Is not possible to logout with a non admin user
• 165 Pending goods receipt
• 170 In Session preferences and variables the name is not show correctly
• 172 Database error when updating a Org Access Role
• 180 When creating a Production Run for a Work Effort some required fields are not completed
• 190 Export.database modifies all records in AD_TEXTINTERFACES with ISUSED=N
• 191 Hearbeat initial configuration is not set
• 199 Hide audit info by default
• 201 Registration intial configuration is not set
• 202 Element production empty in Postgres for new elements
• 208 Heartbeat information not inserted into AD_Heartbeat_Log
• 224 Menu not finish loading in PostgreSQL
• 237 Missing license headers in 3 database files.
• 259 I can not select a product using Product Complete selector
• 261 When I try to delete a Physical Inventory header I get an error message that is not correct
• 262 Customer data is not filled properly when creating a Sales Invoice
• 283 CODE_REVISION column is not present in AD_SYSTEM_INFO
• 289 Error in AD_System_Info and AD_Registration_Info inserts on create.database target
• 294 Cannot save language changes
• 295 Incorrect columns in Tax import format
• 297 Locator input don't have the correct default action
• 298 Registration fails on Postpone
• 300 Servlet Containter and Version not being gathered by Heartbeat
• 301 Change Debt Payment button in Canceld Payments tab not clickable
• 302 Error testing Heartbeat configuration with PostgreSQL database
• 317 Spain currency is set to AED
• 318 PRINCIPAT D'ANDORRA appears as Spain region
• 331 Taxdate field is not completed in processes that generate Invoices
• 332 BP button fails in Create Shipments from Order
• 333 BP button fails in Create Sales Orders from Expenses
• 335 replaceCharacters doen't work for WAD textareas
• 337 Default values with quotes makes the application to not compile
• 345 Bad layout of "Language Setup" workflow
• 348 Save toolbar buttons not enabled
• 349 Cannot view imported accounts
• 361 Taxdate' instead of 'Tax Date'
• 368 Text areas with new lines are not properly shown