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 […]
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 […]
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
UPDATE c_bp_vendor_acct SET v_prepayment_acct = '7521C6AF88074CFBA96E3AB7639D2902' WHERE c_acctschema_id = '092273C810444B4086ED18612E3F5833'