Category: openbravo

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 = […]

  UPDATE c_bp_vendor_acct SET v_prepayment_acct = '7521C6AF88074CFBA96E3AB7639D2902' WHERE c_acctschema_id = '092273C810444B4086ED18612E3F5833'

Credit Memo Template original location: /opt/OpenbravoERP-3.0/openbravo-erp/src/org/openbravo/erpReports/RptC_Invoice_new.jrxml

Accting Process, Payment Monitor etc stopped working, so Invoices are not posted and Payment Schedules are not monitored (how long is an […]

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: […]

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 […]

I recently updated the system using the built-in Modules Window on the Admin's Side and encountered an error on the update, so […]

Went to Openbravo Admin Profile -> Windows, Tabs and Fields -> Financial Account -> Transaction -> Business Partner On Display Logic it […]

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 […]