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 production ready status, which means that:

• This release is for ready for general usage, including evaluation and production.
• We recommend new implementation projects to start with this release
• We recommend existing production deployments to upgrade to this release.
• An upgrade path is available from earlier releases to 2.40.

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
• 371 No 'lower than' check is done in dates
• 372 Remove "Synchronize Column" from Column tab
• 378 trunk r4352 fails to create the database
• 390 Access level for import tables

Fixes Included in ERP 2.40 alpha r3

• 101 Compilation slow in PostgreSQL
• 104 Review all the triggers for Accounting
• 116 If I try to type on a read only field, Save buttons reacts as if something change
• 124 Openbravo database schame has dba privileges
• 304 AT235mp4 - If I click on Help icon while creating a record I get a message about loosing changes
• 315 AT235mp4 - On PostgreSQL, when I try to complete a Sales Order, I get an error
• 316 Static content problem in Purchase order report.
• 327 Issue in the Language setup page.
• 338 AT235mp4 - If there are no clients and I execute Delete Client process, message is not correct
• 340 Grammatical error
• 355 AT240alpha - Information folder on left menu should be hidden if I have no options to see below it
• 373 Service and Expenses Margin fields auto-calculated
• 393 Complete deprecation
• 396 AttributeSetInstance multiframe html should be converted to a single html
• 399 AD_PInstance_Log. Inserts in that table should be remove from some PL's
• 401 Project Profitability report issues
• 403 Heartbeat and Registration htmls don't have keyboard shortcuts
• 405 Database error creating new Settlement
• 406 ArrayIndexOutOfBoundsException exception in windows with search by default
• 414 TabAttachments grid has wrong format
• 419 Dabase Error in windows with new mode as default
• 425 AD_USER and AD_USER_ROLES should be filtered by AD_USER_ID instead of by AD_CLIENT_ID
• 426 User without warehouse will not login
• 436 Blank required fields don't take the focus
• 437 Audit dates not shown in relational mode
• 442 Project Proposal Tracker functionality
• 444 'CreateFrom' popups should not have frames
• 446 CopyFromSettlement multiframe html should be converted to a single html
• 449 No feedback when trying to login without organization-warehouse
• 453 Summarized results in database.preimport
• 455 Heartbeat and Registration pop ups are too similar
• 456 Missing database constraints in Project: Tax Payment
• 459 Project Building Site Report issues
• 461 Initial client setup. Default action button
• 467 Organization (*) when user level=Organization and Access level=Client/Organization
• 470 Create From Multiple window without styles
• 471 Invoice selector has html code in the tittle
• 476 The menu gets block when a user has role without organization
• 484 Improve the message for constraint. AD_ROLE table
• 485 Change the flow on disable/later buttons of Heartbeat configuration window
• 488 Sales reports names
• 496 Sales invoice document cannot be printed. It shows up an error
• 497 Grid query optimization
• 506 Price list window is marked as sales transaction type
• 509 Grid error when navigating back from single record view
• 510 Ctrl + arrow left or right navigation
• 511 Rubbish code on ActionButton windows
• 525 Due to Clean-up project Conversion rates window crash
• 529 trunk fails to compile ComboReloads java files
• 533 Some process button do not work
• 535 Organization combo reloads all the accessible organizations
• 539 Tree for product category is not working
• 543 Remittance when creating the file still with old format
• 544 Multiphase project - project type listbox missing
• 547 Linked items does not work for tables with double PK
• 548 Linked items warning message is doesn't fit the common message style
• 552 ReportBankJR_data.xsql fails to compile in pgsql
• 555 javascript error in Create Accounting Report
• 559 <onCreateDefault/> missing in C_PROJECT.xml and C_PROJECTTASK.xml tables
• 571 Cannot see the region tab
• 575 Test Hearbeat fails due to a missing to_number
• 578 MRP icon is ugly
• 581 Typo in Payment Terms pulldown in Sales Order: should be BANK REMITTANCE
• 587 Planned Purchase Price and Planned Margin in Service Project lines
• 588 Search/Filter button has disappeared
• 594 ExpenseSOrder and RequisitionToOrder processes fail in PostgreSQL
• 601 AT240r3 - Selectors issue on Firefox 2 and FF3. Save button keeps disabled
• 979 Openbravo do not bring sales price
• 989 C_CASH_POST & ENDINGBALANCE=0
• 1025 Forced org at ChangeOrderOrg process
• 1303 Old CSS classes in xsql files
• 1480 Differences in the Location window on Business Partner
• 1492 Incorrect message trying to reactivate an Order
• 1534 Alerts empty tables
• 1750 Not well format. Repor Cashflow forecast
• 1778 Atributte set. Locked
• 1845 Field settlement cancel missing
• 1926 fixed due date error?
• 1927 payment term details fields
• 1986 Mandatory fields on button create a payment
• 1987 Payment selector
• 1988 error searching in a customer tab in bussines partner window
• 2037 Error when attaching a file to a document with no lines
• 2056 Goods shipment print
• 2081 Price list report in PDF.
• 2129 Validation Rules on list references
• 2137 AT235: Create Accounting Report incorrect error message
• 2150 AT235: Matched Purchase Orders & Invoices error messages
• 2151 AT235: Product Movements Report mandatory fields
• 2153 Error SELECT in Rpt_Etiquetas_data.xsql
• 2159 AT235: \'Create Invoices from Orders\' process message
• 2201 AT235 Terminology: Balance Sheet instead of Trial Balance
• 2231 App. doesn\\\'t clear session info when changing role or cli
• 2247 Account tree elements screen
• 2248 Product Import fails because of wrong field size
• 2258 Error when pressing "Create from multiple" button
• 2264 Change the element name 'Service Point'
• 2274 Attribute Title shows up as Position
• 2292 No messages importing products.From temporal table
• 2293 No messages importing taxes. From temporal tables
• 2294 No messages show importing Business partner.
• 2358 Null insertion in manufacturing plan
• 2434 When doing an attachment some file descriptions are Spanish
• 2437 Parsing failed on orderby clause
• 2459 AT235MP1: The "Delete imported" check does not work
• 2477 AT235MP1: Dropdown width
• 2492 M_Product_Org has no SYSDATE as default
• 2500 Complete an order with no lines
• 2502 Warning when you click recalculate dates/quantities button
• 2554 Error in Application translation check window
• 2569 Type columns: Buttons
• 2572 Import file loader. Loose information in the filters
• 2573 Initial Client Setup: default users language is spanish
• 2581 Bank report. Initial balance
• 2585 Hide the field Write-off Amount in settlement manual window
• 2598 Pending Goods Receipts: Wrong DocumentNo
• 2615 Creating a duplicated Client shows success message
• 2616 Can't insert data on Vendor Details window
• 2621 Storage bin overwritten on Shipment In Lines
• 2634 POS- OpenbravoERP-Pricelist
• 2661 QA-MAS Account selector don't fill accounts
• 2717 Callouts with message and focus setting
• 2738 Message when deleting an Inventory is not correct
• 2799 Price precisions initially set to 0
• 2836 QA-KBS Incorrect password message window
• 2837 QA-KBS Change password. User info window
• 2838 QA-KBS User info. Session options
• 2842 QA-KBS Opening selectors
• 2861 QA-SER Remove buttons when edit action is not allowed
• 2889 QA-KBS When selecting a Warehouse parent window reacts also
• 2894 Insert Maintenances process doesn't work correctly
• 2900 Production field empty at production run
• 2911 QA-IUI Ctrl+S is taken as an update
• 2916 Charge-type cash lines do not post
• 2931 Hide audit button
• 2957 Not properly treatment for messages in CopyFromPOOrder
• 2965 wharehouse-organization location
• 2968 The sumatory on in th Invoice Taxes Report is wrong
• 2969 Unknown chars in xml files
• 2974 Grid export bug
• 2975 Error feedback message doesn't disappear
• 2979 Business Partner selector does not work properly
• 2987 Error: AccessTableNoView in two reports in Sales
• 2988 Error filtering by date in generated windows
• 2989 Copy process plan versions overlaps dates in some cases
• 2990 ExportGrid: Don't show complete name
• 3944 AT240r3 - Cursor keys do not work on pop up generated windows

Fixes Included in ERP 2.40 beta

• 124 Openbravo database schame has dba privileges
• 144 Product search does not work if launched from Edit / New mode
• 169 QA-CLEANUP Call-out in sales order window
• 222 AT235MP4 - Export language fails Test 3
• 231 AT235MP4 - Javascript password window fails
• 239 AT235MP4 - Back UI button not working
• 271 AT235MP4 - Error attaching a file in PostgreSQL
• 410 Son tab relation view error
• 411 Database error creating new Settlement
• 419 Dabase Error in windows with new mode as default
• 484 Improve the message for constraint. AD_ROLE table
• 564 Not enough length for a field
• 601 AT240r3 - Selectors issue on Firefox 2 and FF3. Save button keeps disabled
• 1112 A_ASSET_POST PL has spanish months
• 1541 Arrows in Product selector don\'t work
• 1639 The servlet-api.jar is included in the generated war file
• 1676 Error in the ImportTax window
• 1731 Business Partner Setup Steps Fail
• 1934 Pending goods receipts process
• 1983 the Export Budget to Excel button doesn\\\\\\\'t work
• 2016 ant compile.complete deletes the war file from contenxt
• 2037 Error when attaching a file to a document with no lines
• 2052 BP keying in Requisition Header
• 2077 Grid view results in very large number of db queries
• 2084 System.gc() should never be called
• 2105 Login screen does not work after login failure
• 2138 AT235: Invoice Customer Report filter
• 2142 AT235: Calendar does not work on Pending Work Requirement
• 2152 ORA-06512: C_CONVERSION_RATE_TRG
• 2163 AT235: Mandatory comboboxes color
• 2166 Javascript alerts messages on WAD generated windows
• 2171 Application Image in Relation view error
• 2180 Error on renderJR when an execption occurred
• 2195 AT235: \'Change Order Organization\' mandatory field
• 2196 AT235: Java error on Change Payment Status
• 2205 Versioned files are modified during the setup process
• 2213 AT235: Message box color in \'Create Shipments from Orders'
• 2226 Empty string error in Payment Report
• 2260 Inconsistent attribute value size
• 2262 Dates not working in Insert Maintenances
• 2274 Attribute Title shows up as Position
• 2275 Error adding shipment in line
• 2279 Cannot login if ad_role_id=0 is the only one
• 2280 DB generated from XML files don't allow to post documents
• 2288 Project profitability report error in PostgreSQL
• 2301 Create SO from Expenses & AP Expense Invoice messages review
• 2321 Worker checkbox in Employee tab of Partner
• 2338 Product field is not mandatory on Purchase Orde Line
• 2352 jrxml translation depends on external DTD
• 2363 Recalculate amortization does not work in postgres in 2.35
• 2366 Not possible to acivate/deactivate windows
• 2367 Openbravo admin role not manual
• 2368 Right scrollbar doesn't appear in relation view of Workflow
• 2373 Export PostgreSql model
• 2378 WAD broken on postgresql in trunk (1794)
• 2382 Data fields should be mandatory in Invoice Consignment Repor
• 2383 Enabling / Disabling constraints does not log errors
• 2384 Conversion rate trigger error
• 2385 Index loading too slow
• 2386 Oracle recycle bin not purged after modifying model
• 2387 Compilation in PostgreSQL fails in ExternalSalesProductDate
• 2389 Primary keys name not created properly
• 2390 Error in Sales Order in PostgreSQL
• 2393 Drop rules not generated properly
• 2394 Prescript not executed when modifying model
• 2395 Data is not deleted when updating data
• 2397 Postgre parameters not properly read
• 2398 Delete key in Relation view
• 2400 For Postgre BLOB types must be translated to OID
• 2402 Change property to development.environment.id
• 2415 AT235MP1: Amount issues in Purchase Dimensional Report
• 2427 AT235MP1-Postgres-Some data error on attributes
• 2428 AT235MP1-Postgres-Still some source code using sysdate
• 2429 AT235MP1 Invoice process fails for some type of invoices
• 2433 Remittance>CreateFile: Decimals in PostgreSQL
• 2435 Attach description encoding not properly displayed
• 2439 isPeriodOpen NO
• 2451 AT235MP1-Install from svn fails with postgresql
• 2452 AT235MP1-README.txt is not up to date in svn
• 2456 Creating column from DB does not work properly in PostgreSQL
• 2467 AT235MP1: Create a goods shipment from a sales order
• 2486 Saving records in Payment Status Management Lines
• 2488 All tables are rebuilt when updating in postgre
• 2496 Error page when selecting Products to POS
• 2497 Typo: 'Busines' instead of 'Business'
• 2504 Passwords with more than 10 characters
• 2515 Error saving a purchase order when diferents date ordered
• 2516 ** in Incoming Shipment line selecting Product
• 2522 BPartner selector doesn't load name with quotes
• 2532 attach a invoice line in the tab outsourced
• 2533 Background accounting process doesn't mind active param
• 2541 MRP_Run_Initialize function doesn't work in PostgreSQL
• 2546 Sales Order: Dates Filter don't work
• 2548 NUMBER_TO_TEXT_ES function does not work in PostgreSQL
• 2551 Alert Rule definition in PG needs fields in capitals
• 2553 OBN: error fillign order ref. after copy lines on PO
• 2560 Automatic creation of payments in invoices with manual paym.
• 2569 Type columns: Buttons
• 2582 Create process (reports) in the Report Access
• 2590 New client does not default its lang to en_US
• 2594 Remove System Installation check in Initial Client Setup
• 2596 KeyMap class construction
• 2600 Warehouse combobox in valuate stock report
• 2604 Openbravo PostgreSQL 8.3 compatible
• 2613 *DIRECT* command on generated window with two primary keys
• 2618 *DIRECT* must set edit mode to parent tab of a record
• 2619 Error 2.35 MP1 bajo PostgreSQL
• 2621 Storage bin overwritten on Shipment In Lines
• 2625 PROC. GENERATE_AVERAGE_COSTS: Delete Production Costs
• 2636 ExportGrid: Don't show complete name
• 2639 Problem PLAN_TABLE in update.database
• 2640 Not correct order calculating price in Get_Purchase_Price
• 2641 No setup binaries for multiple platforms and OSs
• 2642 Base64 encoding uses non standard class from sun.misc
• 2656 Error in filters of Sales and Invoice Dimensional Reports
• 2659 Print Invoice , print all invoice´s
• 2681 Wrong values in C_GREETING and C_GREETING_TRL
• 2688 Invoice Dimensional Report dimensions
• 2696 ERROR in M_INOUT_POST - Updating Org in Lines
• 2698 Error renumbering in 'Price List Schema' in PostgreSQL
• 2703 Business partner on selectors does not work
• 2704 Files with missing licenses
• 2710 Alert Management window shows duplicated records
• 2734 Calculate Standard Cost Error
• 2737 Non correct ranges in core tables
• 2743 QA-KBS Strange behaviour in table records for Selector
• 2772 Use numbering vs string ordination in dimensional rpts
• 2790 Commision field length
• 2791 Credit memo invoices
• 2793 Invoice date in those manually created is badly stored
• 2800 Space characters in functions and triggers will be deleted
• 2807 Error in the Edi File import
• 2810 QA-Postgres83 User window does not work: LPAD cast
• 2818 QA-Postgres83 Tax import file loader error
• 2821 QA-Postgres83 Generate invoice process fails
• 2822 QA-Postgres83 G/L journal window. Call-out fails
• 2823 AcctServer.IsPeriodOpen, wrong message in the log file
• 2832 asset amortization lines
• 2840 QA-KBS Lost focus in the menu
• 2843 Expense Sheet Lines: Converted Amount
• 2845 Expense Sheet Lines: Mandatory fields
• 2850 Disable Import EDI file functionality
• 2852 Clear Session button doesn't work correct.
• 2855 Error compiling Warehouse window
• 2858 log4j.lcf must exist to start the servlet container context
• 2875 Generated pages do not allow double quotes (")
• 2883 QA-KBS "Browse..." button do not respond to Enter key
• 2886 Is not possible to create 34 bank rules where lines<>1
• 2891 The date filter in the Offers Report doesn't work correct
• 2907 Audit dates without time in PostgreSQL
• 2915 QA-IBAN: Incorrect formatting of control digit
• 2917 Disabled buttons
• 2918 Filtering dates in Purchase Order Report does not work prope
• 2922 Not possible to edit data for employee for BPartner window
• 2924 QA-AJAXG Strange behavior on Business Partner selector.
• 2927 Set version to SVN revision instead of dev
• 2938 Copy From Settlement does not work
• 2939 IBAN accounts, multiple issues
• 2945 Can't see the text of the bottoms
• 2947 You can only create an org at once
• 2955 Deprecate AD_COLUMN_SYNC
• 2960 Focus not on the correct field after pressing TAB
• 2964 P&L report - Wrong operands calculation
• 2969 Unknown chars in xml files
• 3943 AT240r3 - Cursor keys do not work on pop up generated windows
• 3954 Calendar widget do not activate Save button
• 3960 Cross-site scripting vulnerability
• 4049 OBN: Pick Date Calendar does not work
• 4090 Keyboard navigation in the menu does not work
• 4112 It's no possible to navigate to parent tab in a empty grid
• 4145 I get an error message trying to import accounts
• 4212 AT240beta - When importing an Account schema, elements not imported are deleted also
• 4248 AT240beta - Inconsistent display logic of tabs
• 4254 AT240beta - Using Oracle, AD_TABLE_POST_V view is in an invalid state
• 4361 Information tab under Organization window does not work

Fixes Included in ERP 2.40

• 374 AT235mp4 - On PostgreSQL, when I try to complete a Sales Order, I get an error
• 568 Create accounting report
• 2147 Project Profitability Discount
• 2582 Create process (reports) in the Report Access
• 2779 QA-PSM Create SO from Expenses discount round
• 2997 Create Element Value Operands as part of Initial Client Setup
• 3458 Add Eclipse launchs, enhance existing ones
• 3751 Bank report. Initial balance
• 4060 Generate 347 Model error when no data
• 4077 Functions and variables in javascript have Spanish names
• 4085 On PostgreSQL I cannot create IBAN accounts
• 4129 Eliminate Frames
• 4169 Simple production accounting
• 4184 In Out Order Line with description column shorter than in Sales Order Line
• 4199 Initial client setup.Default role
• 4244 AT240beta - Copy Lines button on Purchase Order is too big
• 4257 Heartbeat and Registration windows are partially linked
• 4260 On attachments, "Browse..." button do not get focus navigating with Tab key
• 4269 Tax Report: print provider invoice number
• 4286 Replace internal account with in-transit account
• 4312 Payment Report shows link icon for non existent links
• 4326 Bank Account Current Balance
• 4329 Bank Account Current Balance
• 4342 'Actual password' should be changed to 'Current password' in Role Information window.
• 4344 "You have not permission to access this page" message when clicking Back button on Expense Sheet
• 4347 Pending Goods Receipt process shows a success message without the "Process Finished Successfully" text
• 4348 Pending Goods Receipt process: Mandatory fields are not marked
• 4358 MRP Purchase Plan - Safety Stock Calc and Calc closed purchased orders
• 4363 Alert Management: If there are no displayed alerts Save button gives a Null Pointer Exception error
• 4364 Alert Management: When saving, there is no "Process Success" message
• 4365 Change "Interest Area" and "Interesting Area" for "Areas of Interest"
• 4369 Wrong report names "Jasper Bank Report" and "Jasper Cash Report"
• 4373 "Invoice detail - Jasper" report name
• 4381 I get an error message when trying to open the Invoiced Sales Order Report
• 4382 User window > First name is mandatory
• 4393 Improve the message for constraint. AD_ORG table
• 4405 Remittance process
• 4408 Typo: Work Effort field labelled 'Donequantity' instead of 'Done Quantity'
• 4425 OpenBravo should be changed to Openbravo in the code (wrong capitalization)
• 4441 C_ELEMENTVALUE_TRL.NAME should have same properties as C_ELEMENTVALUE.NAME does
• 4449 IGNORE_ACCENT function is not used on info/BusinessPartner_data.xsql
• 4453 Head diff & Base diff targets should be removed
• 4454 Initial Client Setup: spelling mistake in Currency list
• 4457 Create SO from Expenses & AP Expense Invoice info messages not translated
• 4458 Error when saving Budget Lines
• 4488 Currency issues in Projects
• 4489 Create AP Invoices window does not resize
• 4496 Error Message on wrong SQL in Window 'Alert Rule' does stay on screen, after the error is resolved.
• 4501 Read-only logic do not work properly with combos and callouts
• 4517 Requisitions do not control UOM properly
• 4531 Print Error
• 4532 Service Project tab: issue with SQL Where and Filter clauses
• 4535 Field values in Spanish in Product Movements Report
• 4539 Focus not set in 'HTML format' button in Expense Report
• 4546 Multicurrency issues in 'Expense Sheet' and in 'Create AP Expenses Invoices' and 'Create Sales Orders from Expenses' processes
• 4548 DateTimeData.today(this) is incorrectly used in 'Create AP Expenses Invoices' and 'Create Sales Orders from Expenses' processes
• 4549 Process class tab should have a default be not editable and have a fixed value for the action
• 4554 Focus not set in 'Process' button in Create AP Expense Invoices process
• 4556 The 'Insert Maintenances' process does not work on postgresql-8.3
• 4558 Posting Amortization cause blocks in database
• 4561 'Create AP Expense Invoices' process do not cut by project
• 4567 Copy details from journal batch. The button does not work
• 4580 Balance Sheet: Error in filter
• 4582 Process Copy from G/J Journal does not work on postgresql 8.3
• 4594 Export translation process adds an extra / to the path
• 4597 setup-tool included in WebContent
• 4602 Create PriceList - Get PL/SQL Error
• 4605 Deleting closing entry
• 4606 In remittance cancelation/return process, in remittance combo are remittances unconsolidated
• 4613 withholding amount decimalplaces
• 4615 Dirección no se muestra correctamente cuando la segunda linea es nula
• 4623 Balance Sheet: Error in filter
• 4624 Base64 encoding uses non standard class from sun.misc
• 4637 The function update_dateFormat in the PostgreSQL pre-script must be volatile
• 4643 ant create.database fails with postgresql-8.3 after merge of uuid-branch to r2.5x
• 4645 Function update_dateformat not in OpenbravoExcludeFilter.jave
• 4648 "Enter" key does not work in "Create lines from"- Goods receipt window
• 4650 Remove the blank option from organization combo box. Remittance window
• 4653 Is not possible to write in the log using log4j.debug("text") order
• 4655 It is not possible to unprocess a VAT register. PostgreSQL
• 4657 Remove format hardcode 'DD/MM/YYYY' from VAT register
• 4665 Some JasperReports are using the .jasper compiled version of subreports
• 4667 Manual code clean-up: delete unused imports in Java files
• 4668 Hardcoded date formats in manual src files
• 4675 The c_tax table has new columns, and no OnCreateDefault value has been set
• 4691 Database XML files not coherent
• 4698 Printing a proposal inside Service Project doesn't work
• 4700 Can't save Purchase Order Lines after uuid merge.
• 4704 OnCreateDefault command doesn't work in PostgreSQL
• 4726 Several indexes are not exported in Oracle
• 4738 Problem compiling ExpenseSOrder_data.xsql afer uuid merge due to_number() function
• 4742 Two PL procedures (in r2.5x) dont compile after the uuid merge
• 4776 Cannot complete an invoice with a BOM product
• 4777 Session filter breaks charset filter
• 4779 Copy Client process fails
• 4782 Changes in SQL_Record_Identifier after compilation
• 4787 Remove javascript functions which have been deprecated before the 2.40 release
• 4792 Remittance Cancellation/Return doesn't work with PostgresSQL
• 4796 compile.translate gives error message after the uuid merge
• 4802 Cannot complete an invoice with a BOM product
• 4806 In remittance cancelation/return process, in remittance combo are remittances unconsolidated
• 4818 Is not possible to change the alias in Account Combination window
• 4819 Is not possible to change the alias in Account Combination window
• 4869 Tax payment post
• 4990 Copy client does not work in PostgreSQL
• 5007 Create AP Expense Invoices process does not take the sequences number well
• 5142 Custom code range 2.40 version. Table AD_MODEL_OBJECT_MAPPING
• 5145 Custom code 2.40 that is wrong. AD_Textinfaces table
• 5160 "arrTeclas" fails in updated windows form 2.35MP5 to 2.40
• 5162 Is not possible to change the alias in Account Combination window
• 5274 AD_TEXTINTERFACES_TRL has 2 primary keys, and causes db create/export inconsistencies
• 5321 Importing translation some labels are not translated in form view under BigBazar (or whatever entity different than System)
• 5370 On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing
• 5372 On PostgreSQL, when deleting a client with errors (some constraints are missing) no error message is shown

Browser Configuration for Usage with JasperReports

Openbravo ERP 2.40 leverages JasperReports to generate high quality reports. In order to properly print reports, the following browser configuration is recommended.

Internet Explorer. In the Tools menu, click Internet Options and select the Advanced tab. Under Settings, scroll down until you find the Printing category. Make sure Print background colors and images is checked, and then click OK.

Firefox & SeaMonkey.In the File menu, click Page Setup. In the Format & Options tab, under Options, select Print background (colors & images). Click OK.

Chart of Accounts and Translation Files

Openbravo ERP 2.40 is compatible with chart of account and translation files created for version 2.35 and those files can be safely used with 2.40.

Acknowledgements

Openbravo wants to thank:

	Centigrade for their creativity and help in improving the Openbravo User Interface.
	Cosmic Blue Team S.p.A for contributing two key core features like VAT Registers and Withholding Tax.

A special thank to all the people in the community that helped us in the testing and stabilization of this release. In particular, Openbravo thanks, the following people who participated in the 2.40 alpha Acceptance Testing:

• Paulo Leandro (PlanB)
• Laurie Brown (jVolution)
• Golo Meierhenrich (Veloton)
• Naveen Chanda
• Daniel Nyaga
• Ville Lindfors (Bonware)
• Andrea Ilari
• Ben Smith
• Ravi (SoftPro)
• Phaneendra (SoftPro)
• Venkatakrishna.T (SoftPro)
• Milange Rivero (Sen)
• Fabiano de Freitas
• Eduardo Fernández

Downloading and installing it

You can download Openbravo 2.40 from SourceForge and install it following our quick installation guide.

Communicate

We want to hear from you! You can reach Openbravo community at:

• Openbravo ERP forums: http://forge.openbravo.com/projects/openbravoerp/forum
• IRC: #openbravo (English) and #openbravo-es (Spanish) on irc.freenode.net

To keep up to date with Openbravo community news, be sure to visit Planet Openbravo for blog posts from the Openbravo community.

Do you want to contribute? To get involved with Openbravo ERP see our Contributor's guide.

Known issues

• 2591 Oracle error filtering data in some windows: this defect applies to Openbravo installations running on Oracle and it is caused by Oracle bug 4626732. This bug is resolved starting from Oracle 10.2.0.2 and 11.1.0.6. For previous versions, a patch is available for all Oracle editions supported by Openbravo with the exception of Oracle XE. Oracle XE users can workaround this issue by disabling the filter predicate pullup feature of the Oracle optimizer, editing the config/Openbravo.properties file:

bbdd.sessionConfig=ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY' NLS_NUMERIC_CHARACTERS='.,' "_optimizer_filter_pred_pullup"=false

This workaround is effective in all editions but it is recommended only for XE as it causes a theoretical reduction in database performance.

• 5451 When upgrading from 2.35MP5 or 2.40beta to 2.40, the translate process doesn't update correctly the column isused in the table ad_textinterfaces. This doesn't affect the functionality of Openbravo ERP.

• 5452 When upgrading from 2.40beta to 2.40, there are "oncreate default" problems in the C_Glitem and c_Project tables. This issue doesn't affect the functionality of openbravo ERP.

• 5453 The Delete Client process tries to deactivate the primary keys and cannot do it. It gives an error but it doesn't affect the functionality and the process removes the client.