Openbravo module upgrade can be done directly inside Openbravo UI, just like regular software update. just make sure you have backup prepared by run ant -f snapshot.xml, also if you have prior custom development inside, you need to export all your customization by run ant export.database and ant export.config.script. follow guiding pictures below: login as … Continue reading How to Upgrade Module in Openbravo
InfiniteERP + UnicentaPOS = ERP for retail solution. Full integrated, robust, flexible, and scalable.
BI solution, powered by pentaho. full integrated to InfiniteERP (powered by openbravo).
postgresql come with average confirguration for average hardware, make it available for all people across the globe. if your hardware above the average, you need to fine tune, to optimize postgresql performance. fortunately, before postgresql reach it's limit, your hardware reach the limit. for your information, I use postgresql 9.6 and linux mint (ubuntu based) … Continue reading How to tune postgresql performance for OLTP application
you can make accumulated measurement using Dynamic Dimension. instead of periodical measurement, you can make an "as per date" measurement. current stock is an perfect example of accumulated measurement of inventory transaction, that accumulated from the begining to current date. as you may know, pentaho mondrian OLAP cube build from a flat table, consist of several … Continue reading How to use Dynamic Dimension YTD, QTD, MTD, WTD in Pentaho
SqlC is a tool that builds a java class from a file with SQL statements. The java class contains the code necessary to connect it to a database, format the statement, execute it and return the resultset from the database. This is a common function for any statement execution. SqlC avoids this repetitive task building … Continue reading Practical guide to Openbravo’s SqlC
some image, when used properly, make your report more impressive. static report in openbravo, through iReport, you can add static image too. this tutorial will share how to add a static image to openbravo static report. this tutorial is follow-through sub-reports in openbravo blog post. you can read it first if you not confident enough to … Continue reading add image to openbravo report (ireport)
Report is one of the key benefit for using ERP application. More enhanced and flexible the reports are, more happy customer is. In Openbravo, we use jasper reports to provide us the flexibility to handle all report generation and rendering. Jasper Report provide us iReport, graphical tool used to design and test jasper based reports. … Continue reading Sub Reports in Openbravo
As in general, password data stored as encripted text inside database table, so is Openabravo. Beside user account's password, Openbravo also provide data type so called password. You may create a custom field, and register those field type as a password, for example SMTP password. Before used, you need to compile usually by runing ant … Continue reading How Openbravo encrypt Password
Pentaho virtual cube is a new kind of technology for report creation. You can imagine what it's best for your organization, and start getting benefits. please check this slide out!