OpenBravo

Openbravo: Latest Version Install

Posted on

We have an old Community Version of Openbravo, which is super buggy and corrupted, so starting this new year, we're interested on trying the latest version of OB. In this case we'll be installing Openbravo Community Edition PR18Q4.1.  Additionally one of the reasons we want to install this is that we are going to install it […]

iDempiere

Jasper Reports: JAVA Compatibility

Posted on

We user Jasper Reports on multiple projects: We have a stand-alone Jasper Server that runs all types of reports from our server We have an Openbravo ERP Instance¬† We have an iDempiere ERP Instance Running (same fork root as Openbravo). The Jasper Studio is used to configure the reports and compile them, the problem is […]

OpenBravo

Openbravo: Custom Query to find Invoice's Product Account

Posted on

SELECT c_invoice.documentno, c_invoiceline.linenetamt, --m_product_acct.m_product_id, --m_product_acct.ad_org_id, m_product_acct.p_expense_acct, c_elementvalue.name FROM c_invoice LEFT JOIN c_invoiceline ON c_invoice.c_invoice_id = c_invoiceline.c_invoice_id LEFT JOIN m_product_acct ON c_invoiceline.m_product_id = m_product_acct.m_product_id LEFT JOIN c_elementvalue ON c_elementvalue.c_elementvalue_id = m_product_acct.p_expense_acct WHERE dateinvoiced > '2017-01-01 00:00:00' AND dateinvoiced < '2017-12-31 00:00:00' AND issotrx = 'N' AND m_product_acct.c_acctschema_id = '092273C810444B4086ED18612E3F5833' ORDER BY --c_invoice.dateinvoiced ASC p_expense_acct asc