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’
hibernate sessionfactoryimpl memory leak
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 important are: org org.openbravo But am not completely sure which processes control each log.
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’)
I recently updated the system using the built-in Modules Window on the Admin’s Side and encountered an error on the update, so I decided to do a complete rebuild of the system using ANT SMARTBUILD just to wipe any problem that could have been created on the incomplete update process. Prior to this, I had manually […]
Went to Openbravo Admin Profile -> Windows, Tabs and Fields -> Financial Account -> Transaction -> Business Partner On Display Logic it appeard: @ACCT_DIMENSION_DISPLAY@ & @Trxtype@!” I just deleted that and was able to update the Business Partner.
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
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 […]
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 […]
ant export.database ant compile.complete ant compile.deploy ant compile.complete.deploy
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;
I cannot Post “Goods Receipt”, I believe there is an error when opening the Physical Inventory. I have created a couple of Physical Inventories but get the “Post Document Disabled”
It is not posting because the Costing Algorithm is not working, probably because it is not recognizing the Currency.
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 […]
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’
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 […]