[368 total ]
Jordi Mas: Openbravo community highlights 17/02/2007

This is the first of a series of posts that I will write regularly to highlight the news and accomplishments around the Openbravo community.

Some recent news:

Openbravo roadmap has been updated and extended a few days back providing ... [More] extra detail on new features. You are welcome to give your feedback in our developers forum.Our engineering team have been successfully tested Openbravo on Microsoft Windows Vista and Java 6.The III Libro blanco de software libre en España (3rd white book on free software in Spain) was presented last week. Openbravo was invited to write an article about "Creating Value" in open source companies. Decio Franchin, a student mastering at Bournemouth University in UK, is requesting help for his research around the viability of ERPs for SME. Can you help him?

I will try to keep this compilation rolling every week. Feel free to send me achievements that you have done around Openbravo. [Less]

Jordi Mas (Personal feed): Technology Pioneers Report 2007

The World Economic Forum, that elite business forum that we all love, announced a few weeks back his list of 47 visionary companies selected as Technology Pioneers for 2007. The companies products include microscopic pill cameras, bio sensors that ... [More] localize landmines and implantable medical devices for the treatment of brain tumors and software. The companies are classified in four categories: Biotechnology/Health, Energy, Photographs and Information Technology.

I was happily surprised to see the Mozilla and Alfresco open source projects listed. There is an interview with Mitchell Baker where she explains briefly the objectives of Mozilla foundation and similar interview with John Newton from Alfresco.

It's cool to see open source projects listed everywhere. However, I find it more interesting when open source projects are mention in materials done by public institutions as a result of a peer reviewed method. [Less]

Openbravo ERP R2.22 has been released

--- What is new in Openbravo R2.22 ---

Bugs fixed

* Import Account in Oracle was failing due to the changes done in the Import_Acount_data.xsql file made to show error messages when working with PostgreSQL. This has been fixed and ... [More] now works in Oracle and PostgreSQL.
* Modified web services implementation to solve a problem related to the date format configuration.
* In a processed Invoice, it was possible to modify or delete the associated invoice and shipment. Now this is not allowed.
* Taxes with business partner tax category were not applied correctly. It applied taxes with BP tax category defined to BP that had not defined that category. Now it applies taxes with tax category only to those BP that have defined the same tax category.
* Default taxes are now selected taking into account how tax is defined (for Purchase or Sales transactions).
* Creating an invoice from orders did not work properly, and now has been fixed:
-If it was invoked by selecting orders from the Generate Invoice Manually window, it only worked for orders with the invoice rule "Customer Schedule after Delivery".
-If it was invoked from Generate Invoices, it only worked if an order was selected, but not if it was blank (it is supposed to take all available orders).
* In the remittance window "Create From" has been fixed, it did not show any record.
* Some constraints that were not applied in last versions have been applied.
* Procurement/Expense invoice error solved by fixing the combo creation.
* Improved Purchase planning processes. It is now possible to plan the purchases with a given time horizon. Afterwards, the purchase proposals can be converted automatically to purchase orders.

Enhancements

*** Translated and improved the data in the online demo ***
* Database Information
- Business Partners updated
- Names, relevant information, etc.
* Products Updated
- Updated relevant information in the Project Management section
(products, employees, business partners, etc)
-Configured business partners to be used for project management
* Project Management
Hid project (budget) and project (order).
Hid the field "commitment is ceiling
Hid the history section on page 1 (invoice, planned amount)
Hid the unused project categories (only project (service)
shows now)
Added Project Profitability Report to BBAdmin user (0 comments) [Less]

Josep Mitjà: LinuxWorld Open Solutions Summit

In a couple of weeks I will participate in a roundtable on the next edition of the LinuxWorld which will be held in New York, NY. This time the event is dubbed Open Solutions Linux.

The rountable will be the official presentation of the Open ... [More] Solutions Alliance and will be moderated by Collabnet's Founder and CTO, Brian Behlendorf. I will be sharing the panel with executives from participating alliance member companies, including:
- Kim Polese, CEO, SpikeSource
- Tom Manos, CTO, Centric CRM
- Javier Soltero, CEO, Hyperic
- Barry Klawans, CTO, JasperSoft
- William Soward, CEO, Adaptive Planning
- Andy Astor, President & CEO, EnterpriseDB Corp.

I would love to see you there. This is Thursday, February the 15th at 10:15 am. You can find the details for the session, at "Open Solutions AllianceForms to Promote Interoperability Between Open Source Solutions" [Less]

Josep Mitjà: To Share or Not To Share

Last Friday I had the pleasure to participate in a roundtable to discuss about “Ideas, Enterprises and Open Knowledge”. The roundtable was part of the Powerful Ideas Summit (see my previous post).

A number of powerful ideas (honoring the ... [More] name of the event) were put forward, but I would like to single out here one of the thesis of John Perry Barlow (a real character and co-founder of the Electronic Frontier Foundation) about the benefits of sharing.

He talked about the dynamics of intellectual property as opposed to physical property, and highlighted an interesting difference. Whereas with physical goods, its value increases with the scarcity, with intellectual property exactly the opposite happens. The value of an idea increases with its diffusion. Obviously there are many businesses based on owning ideas (call it licenses, patents or copyrights). And very profitable businesses indeed: software and pharmaceutical companies among them. However, these businesses are still successful because their ideas have reached a wide dissemination: Windows and Office for Microsoft or Aspirin for Bayer to name a couple of examples

In my keynote, titled “Building Global Open Source Enterprises” I also presented a similar argument: “Sharing your assets, strengthens your business”. This is a counterintuitive argument to many, but I can tell you that every day I see more tangible evidence that the statement is true. What other, more powerful, mechanisms exist to spread an idea than freely sharing it (with the help of the Internet, I might add)?

For me, being an entrepreneur who is trying to build a successful business following this concept, the beauty of it is that sharing is not an attitude easily replicated by your competitors. Many businessmen are not prepared (or even afraid) to embrace this concept, or they don’t know how to do it (Should I share all or just a part of my knowledge? What tools should I use to ensure that sharing is an activity that works both ways in and out of the company?) [Less]

Jordi Mas (Personal feed): New positions opened at Openbravo

In the last days a few new positions at Openbravo have been opened in the Engineering, Professional Services, Finance & Control and Partner Management departments. For those of you have engineering background with strong development and ... [More] management experience we are looking for a
VP of Engineering.

From our web site:
Openbravo is looking to attract the very best people and offers a
complete HR plan structured around the logical professional
opportunities that are created in a fast growing technology company, a
very attractive compensation system and a young culture that fosters
innovation and value creation.
All the information about these positions is available in our web site. I have no more information or details that the ones that we have already published. We have plans to keep hiring regularly new people during this year. I recommend for those interested to keep an eye to the Openbravo Careers page.

We are looking forward to new people to join the team: [Less]

Openbravo ERP R2.21 has been released

--- What is new in Openbravo 2.21 ---

Openbravo 2.21 is the first stable release of the branch 2.20. It has all the functionality and fixes introduced in version 2.20 plus additionally the following new functionalities and fixes:

* ... [More] Material Requirements Planning (MRP) is a software based production planning and inventory control system used to manage manufacturing processes. MRPs help companies keep a lower level of inventory, plan activities & schedules, and ensure that materials are always available.

o Automate the processes that define the work requirements and the procurement orders. This includes defining the processes that generate the requirements based on sales orders, product stocks, sales forecasting & other input data, and functionalities that impact the allocation of resources.

o Each product has its own planning method and can be assigned to the documents to be used (sales & purchase orders, sales forecasts, work requirements, material requirements and/or initial stocks). Lot types, quantities, and process times for each product are defined here.

o The product BOM is expanded such that all related products are planned for.

o After both the purchase and the manufacturing processes are complete, the user can modify lines and recalculate each plan.

* Added new reference to the MDA (Model-Driven Architecture) and implemented a new menu element type for external URL links.

* Bug fixing: 33 bugs have been fixed in this release.

--- Downloading and installing it ---

You can download Openbravo 2.2 from SourceForge and install it following our quick installation guides for Oracle and PostgreSQL.

--- Migrating developments from a previous version ---

If you have your code customizations or developments based on previous versions of Openbravo, please check the document How to Migrate Code (http://wiki.openbravo.com/wiki/index.php/How_to_Migrate_Code) to learn about what changes your developments may need to accommodate. If you have any questions, you can use our developers forum.

--- Full Change Log ---

*In search referencing a table field now is shown the
identifiers associated to it, instead of the value of the field as it was done
before.

*When a Bank Statement is accounted and it has a negative currency conversion
charge, it was taken the same account as it is were positive. Now it takes
different accounts depending on if it is positive or negative (one for gain
and another one for loss).

*Modified whereclause of the tab to change the in clause

*We have modified Attribute.xsql file to avoid the problem with IN(0,?) in
PostgreSQL. We have also modified Notice window validation to avoid this
problem.

*It was not possible to access to Copy Client process, an error was shown when
trying to enter to this window, this was caused by a misspell in the parameter
name.

If pace was for a password upon entering, OB crashed. Now it is not allowed.

*Now the Copy Client process copies the element value tree (accounting tree)
to the created client. This was not done before.

*The BP selector at Banks window, had the customer radio button selected when
is opened. Banks are providers instead of customers. So, the provider radio
button is now selected by default.

*Remittance window was defined as maintenance and now it is a transaction
window. A Processing" field has been added to this table and now it is used to
block the remittance in the post process."

*Creating time report invoiced to a partner do not generate an expense not
reimbrused to the employee.

*When creating a new Sales Order, Shipment (Customer), Material Receipment,
Purchase Order or Invoice (Customer and Vendor) the Partner Address field was
filled in with the partner address of the last Business Partner which the user
has been working. Now this field is empty.

*Show business partner filter in sales order window

*When an invoice (vendor) is created by the process "Create AP Expense
Invoices" (Service) the Unit Price field of the invoice lines is not the
amount of the corresponding Report Line of the Expense Report but the Price
List amount.

*Previsted quantity on hand, Quantity order on hand and Previsted quantity
order on hand fields weren't translated in the Warehouse window.

*After creating a new version of a price list you generate the process "Create
Price List" to create the product price lines an error message appeared. This
has been fixed.

*In Year tab was not possible to modify data because Error: Request parameter
required: inpprocessing" was showed when saving it. This has been fixed."

*We have modified the procedure AD_SEQUENCE_DOCTYPE in order to return NULL
and not '' because invoking procedures are waiting for a NULL value and not
''. This bug is only for PostgreSQL version because Oracle doesn't make difference between NULL and ''

* We have corrected Ma_Standard_Cost_Sequence function because it is in invalid state and it it doesn't work in PostgreSQL. We have added some needed cursor declarations and now it works.

* Window Offers has been renamed because this was a direct translation of Spanish Ofertas". Now it is called "Price Adjustment"."

* We have modified AD_VALIDCOMBINATION_TRG to solve a problem when it compounds combination: in postgreSQL, concatenation of strings with a null value return null, and that's happenning. Now combination composition works fine even in Postgre and Oracle.

*We have modified ReportProductionCostData to make it compile in PostgreSQL

*We have modified Org specific tab in Product window making non editable the Product field (parent) and looking for and correcting more windows with a similar problem.

*Changed the sqlc composer to change the log message to debug level

*Green arrow to navigate between tabs (in windows with many of them) has been translated to English, before it was in Spanish.

*In Product tab, UOM was disabled so it was not possible to choose a UOM for the product, it has been made enabled.

*When a new order line is created, discount is calculated and rounded. The actual price for that line was calculated based on this discount. The problem was that depending on how is rounded the price will not be the one it should.
Now, the discount only is applied if it doesn't differ (once rounded) with the previous one.

*In Business partner window, Vendor tab the fix month days were not translated for this tab. In English were also incorrect. In Business partner tab Las_Days element was not correct too.

*In DB were columns that should have a foreign key to other tables but they had not. A complete review of these columns has been done and FKs have been created where necessary.

*After creating a new version of a price list you generate the process "Create Price List" to create the product price lines an error message appeared. This has been fixed.

*Create invoices from expenses process update address field with partner address.

*In the reverse process of Bank Statement with Debt/Payments that are returned from remittances an error was raised due to the DP status (it was not pending as it was supposed to be). This problem was caused because of the order of the process, it has been reordered in order not to raise this error.

*Bank Statement has a restriction in order to avoid changing between bank accounts with different currencies, this restriction should be triggered only if there are lines for this statement but it was being triggered always so it was not possible to change the bank though there's no lines. Now it only avoids to change it if there are lines.

*We have modified the trigger A_Asset_Group_TRG because Postgre doesn't accept functions without parameter to be invoked without brackets.

*We have modified the ImportAccountData.xsql file to show the import account errors occurred during the process in PostgreSQL.

*** Other ***

*Passed test over PostgreSQL 8.2

*Updated all date fields to 10 in column length and field length

*In the Business Partner Selector Pop-up there were the fields Village and Province that didn't match the actual field names City and Region, now they do.

*Added to the windows a check to see if the role has permission to execute the insert, update or delete action

*We have modified some PL to fit them to style rules of Openbravo for PLs due they use the SQL%ROWCOUNT in a non proper way. (0 comments) [Less]

Josep Mitjà: Powerful Ideas Summit

Next Friday 26th I have been invited to participate on the Powerful Ideas Summit. The event has been beautifuly organized under the direction of Adolfo Plasencia by the University and Science Department of the Generalitat Valenciana and the Valencian ... [More] Institute of Small and Medium-Sized Enterprises (IMPIVA).

The objectives of the summit are the following: This Meeting has as a main objective to be a meeting point for sharing different visions, expertise, best practices, ways to see and do things differently in the world, joined by a common interest that cannot be given for granted: that of imaginative creative intelligence that boosts business creation, and which will be the shearest measure of its liveliness and high standard on a long and short term basis, as well as one of the most significant data for its future configuration.
In a keynote speech I will talk about Openbravo's experience delivering an open source application to small and midsize enterprises worldwide. Later I will also join a very promising round table to discuss about open source business models with:
- John Perry Barlow, co-founder of the Electronic Frontier Foundation
- Juan Tomas García, blogger and MonoLabs founder and CEO
- Alfredo Romeo, Blobject.es founder and CEO
- Julio Yuste Tosina, Vivernet managing director and creator of LinexEmpresas
- Juan Reig, President of the Malaga's Open Source World Conference
There are also a number of high profile participants, who will account for a very interesting gathering of ideas. I really look forward to positive energy that this type of events generate. I will keep you posted with my conclusions. [Less]

Jordi Mas (Personal feed): Attending to the Open Source meets Business in Germany

From the 22 of January I will be attending to the Open Source meets Business congress in Nuernberg, Germany and enjoying a -5 Celsius degree temperature...

According to their literature the congress targets CIOs, CTOs, and IT
decision ... [More] makers interested in open source. It features presentations on best practices and the future of open source as well as workshops, top keynote addresses and poster sessions. The first day is focus on
investment, the second on technology and the last two ones in
enterprise.

There is going to be people from MySQL, Jboss, IBM, Ingres, Pentaho, Zimbra, Eclipse, Compiere, Alfresco among others showing their technology and products. Also people from Airbus, Opators showing what open source is doing for them at their organisations. In the investments sessions, there is people from Atlas Venture, Index Ventures and other VC funds.

Manel Sarasa and myself from Openbravo are going to be talking about Openbravo ERP on the 23th of January at 15.00 and we are also going to be present in the poster sessions. If you are interested in Openbravo please come to visit us.

If you hack Gnome, Abiword, Mono or Openbravo write me a note and we can meet there. [Less]

Josep Mitjà: Community built slideshows

Hafed Benteftifa at blidainfo has created a handful slideshows to describe some of the basic operations with Openbravo. He has made them available to the community and posted them in Slideshare.net (see ... [More] www.slideshare.net/tag/openbravo).

Topics currently covered include:
- Creating a new vendor invoice document
- Creating a new material receipt
- Creating a new purchase order
- Creating a new sales invoice document
- Creating a new sales order document
- Creating a new shipment document

The slides are really good, and frankly pretty useful. Again, yet another example of the nice things that happen when you share your software with the community. :-) [Less]