OpenBravo

OB: SI Total not printing

Posted on

Invoice Total was not printing; I replaced the Subtotal Formula on the Total Field, this is a quickfix but will not add in the case were there is Tax. I suspect that the variable¬†$V{TOTAL_TAXAMT} is not being passed corrrectly from the subreport which makes the formula fail. Subtotal: ($V{TOTAL_LINENETAMT}!=null)?$P{NUMBERFORMAT}.format($V{TOTAL_LINENETAMT}):new String(” “) Total: ($V{TOTAL_LINENETAMT}.add($V{TOTAL_TAXAMT})!=null)?$P{NUMBERFORMAT}.format($V{TOTAL_LINENETAMT}.add($V{TOTAL_TAXAMT})):new String(” “)

OpenBravo

OpenBravo: Goods Receipt & Purchase Invoice not Posting on C_Order Table

Posted on

Proposed Solution: https://issues.openbravo.com/view.php?id=11820   This issue is duplicated of 0011233. Please find below how these values are used in Procurement. This feature request is rejected because the way Openbravo manages quantities for goods receipts and purchase invoice is completely different than for sales. For procurement Openbravo uses 2 tables: 1. M_Matchpo ============ Here you match […]

OpenBravo

OpenBravo: Document Disabled for Posting

Posted on

Error Message 1: Account could not be found. Solution 1: Payment method needs to get adjusted so that the Posting process is configured. Error Message 2: Account Not Defined For: Customer Receivables || Owner: Cargill de Nicaragua S.A || Accounting Schema: World Bridge Trading – Dollar Solution 2: The is not Accounting Configuration on the […]

Backup Strategies

OpenBravo: Backup

Posted on

http://wiki.openbravo.com/wiki/Installation/Ubuntu:_advanced_topics#Restore Procedure I will describe the procedure I use to backup my Openbravo Production environment, I’m well aware this is not the best and most efficient way and will try to continually find better options to do it. Backup 1. Go to Production environment and Sign in through SSH Console (you can use Putty or […]

OpenBravo

OpenBravo: Show Accounting Windows

Posted on

The button is not displayed for the second user because it’s configured this way in the session preferences.To see the Post button (and everything else related to accounting), you must follow this steps: 1. Log in with your “second user”, i.e. the one that couldn’t see the Post button 2. Go to Session Preferences window […]

OpenBravo

Openbravo: Performance Tips

Posted on

  http://wiki.openbravo.com/wiki/Performance_and_Security_Tips   Introduction This document describes some performance and security tips, recommended for production environments. Performance tips This is a list of tips to enhance Openbravo performance. Tomcat Compression If you want to use Tomcat in conjunction with Apache httpd then you can skip this part. In case you want to run a standalone […]

OpenBravo

Openbravo: Issues

Posted on

  – Financial Invoice cannot be Reactivated. (They can only be Voided) SOLVED, this cannot be done under my profile, but if I log in as System Admin I can do it.   – How to add System Admin to my Profile

OpenBravo

OpenBravo: Modifying Document Templates

Posted on

The original and operating templates are in the following path:   /opt/OpenbravoERP-3.0/tomcat/webapps/openbravo/src-loc/design/org/openbravo/erpCommon/ad_reports Note that there are other paths where you’re able to find the same reports but this is the “production” location.   Modify Templates The first thing you will want to do when you have a production OpenBravo instance is to modify the Document […]

OpenBravo

OpenBravo: Conecting to PostgreSQL

Posted on

For regular configuration you will need to connect to the PostgreSQL, some of the basic programs you will be connecting from are: Jasper Reports (Ireport) A GUI Desktop Database Manager (PgAdmin) Jasper Server   To resolve this you will need to add the IP where you’ll be connecting from to the pg “firewall” The pg_hba.conf […]