iDempiere

Jasper Studio: 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

OpenBravo

Openbravo: Check los Logs

Posted on

The Openbravo Logs are located in: /opt/OpenbravoERP-3.0/tomcat/logs To change the Log Reporting Settings “Error, Debug, Info, Warn etc” you should go to: Session Preferences -> Change Logs -> And Set the desired Level for each category I believe the most important are: org org.openbravo But am not completely sure which processes control each log.

OpenBravo

OpenBravo: Custom Changes

Posted on

Keep track of the custom changes that can be lost when rebuilding: ADD DB Column c_order.po_refernce_no ADD DB Column c_order.tracking_number Display Logic for Business Partner on Financial Account Display Logic for Tracking Number on Goods Shipment — DELETED (@DeliveryViaRule@=’S’)

OpenBravo

Openbravo: Add Field

Posted on

Create Field on Table ALTER TABLE c_order ADD COLUMN tracking_number VARCHAR(32); Create Record on “Tables and Colums” Only Click Create Columns from DB Add Field to “Windows, Tabs and Fields Only Click Create Fields After you do this you need to restart openbravo  sudo /etc/init.d/openbravo stop

OpenBravo

Openbravo: Our instance is Broken

Posted on

Our Openbravo instance has broken (I suspuct upon an update).  Why do I think this?: Period Control is empty on the Organization Data Sets are empty on the Organization I cannot Post a Goods Receipt or Goods Shipment I installed a fresh copy of OB on a Virtualbox server to test if this was the new normal […]

OpenBravo

Openbravo: NEW Installation (Old way Discontinued)

Posted on

The old way of installing Openbravo on your server using the PPA Repository is discontinued. This means that using this old way of installing can only allow you to install the instance on a 12.04 Server (which is an old Ubuntu Version). If you want to install OB on a new server you should follow […]

OpenBravo

PgSQL: List and Remove Triggers

Posted on

I want to delete directly on the PgSQL database on my OpenBravo application but it has a los of triggers that prevent certain actions, first I want to list them and after that will want to disable them. List: SELECT event_object_table,trigger_name,event_manipulation,action_statement,action_timing FROM information_schema.triggers WHERE event_object_table=’m_inventoryline‘ ORDER BY event_object_table,event_manipulation Disable: DROP TRIGGER m_inventoryline_trg ON m_inventoryline;

OpenBravo

PgSQL: Cannot Delete Line on Table.

Posted on

This happens when I try to manually delete a record on the Database   ERROR: update or delete on table “m_inoutline” violates foreign key constraint “m_inoutline_canceled_inoutline” on table “m_inoutline” DETAIL: Key (m_inoutline_id)=(8310BD9D63A94DB5A2294EC8E48C6C9F) is still referenced from table “m_inoutline”. ********** Error ********** ERROR: update or delete on table “m_inoutline” violates foreign key constraint “m_inoutline_canceled_inoutline” on table […]

OpenBravo

OpenBravo: Delete Goods Receipt

Posted on

I have not found an immediate way to do it. Manually Delete Records from: m_matchpo m_transaction m_inout   SELECT m_inout.documentno, m_inoutline.line, m_matchpo.updatedby FROM m_inout LEFT JOIN m_inoutline ON m_inout.m_inout_id = m_inoutline.m_inout_id LEFT JOIN m_matchpo ON m_inoutline.m_inout_id = m_matchpo.m_inoutline_id WHERE m_inout.m_inout_id = ‘936753D37E954F72AA8C111F950EB2EB’

OpenBravo

OpenBravo: Inland Freight is taken as a Stockable Item

Posted on

Inland Freight, International Freight and other Service Items are reflected as Stockable Items and appear on the Goods Receipt. I was able to “duct tape” a solution forcing this items not to print on the GS Template, but it still accounted as an Item that was shipped from our warehouse (It even has to specify […]