pgsql: cannot delete line on table.
This happens when I try to manually delete a record on the Database ERROR: update or delete on table "m_inoutline" violates […]
openbravo: delete goods receipt
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 […]
openbravo: inland freight is taken as a stockable item
Inland Freight, International Freight and other Service Items are reflected as Stockable Items and appear on the Goods Receipt. I was able […]
openbravo: accounting check
I'm working on the Financial Statement of My Company, we sell Industrial Equipment and spare parts to big companies on Latin America; […]
asterisk: zoiper + grandstream fxo bad call quality
I've got my Asterisk box Setup with a Granstream FXO to connecto to the Land Lines. I've got a FXS to connect […]
openbravo: si total not printing
Invoice Total was not printing; I replaced the Subtotal Formula on the Total Field, this is a quickfix but will not add […]
mysql: update database
SELECT * FROM crm_em.notes WHERE name LIKE '%cierre%'; UPDATE crm_em.notes SET name = 'Nota de Cierre' WHERE name LIKE '%cierre%';
openbravo: postgresql won't start after lights out.
I Made some changes on the Server Rack setup and by mistake disconnected the power to the server, upon restart got […]
jasperreports: timeouts in server
Session timeouts dictate how long a user is allowed to be inactive before being automatically logged out of JasperReports Server. Tomcat Edit […]
pgsql: cannot use extract function inside a where clause
For Exmple: AND (date_part('YEAR',fin_finacc_transaction.statementdate) = $P{Año}) or AND ((extract(Year from fin_finacc_transaction.statementdate) LIKE $P{Año}) OR $P{Año} = 'ALL') Neither of these work, […]