I'm working on the Financial Statement of My Company, we sell Industrial Equipment and spare parts to big companies on Latin America; right now I want to make a report that shows my sales based on the inventory I've got […]
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. […]
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). […]
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' […]
UPDATE c_bp_vendor_acct SET v_prepayment_acct = '7521C6AF88074CFBA96E3AB7639D2902' WHERE c_acctschema_id = '092273C810444B4086ED18612E3F5833'
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 […]
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 invoice late for example)
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 […]
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')