select businesspa0_.C_BPartner_Location_ID as c_bpartn1_203_, businesspa0_.AD_Client_ID as ad_clien2_203_, businesspa0_.AD_Org_ID as ad_org_i3_203_, businesspa0_.IsActive as isactive4_203_, businesspa0_.Created as created5_203_, businesspa0_.CreatedBy as createdb6_203_, businesspa0_.Updated as updated7_203_, businesspa0_.UpdatedBy as updatedb8_203_, businesspa0_.Name as name9_203_, businesspa0_.IsBillTo as isbillt10_203_, businesspa0_.IsShipTo as isshipt11_203_, businesspa0_.IsPayFrom as ispayfr12_203_, businesspa0_.IsRemitTo as isremit13_203_, businesspa0_.Phone as phone14_203_, businesspa0_.Phone2 as phone15_203_, businesspa0_.Fax as fax16_203_, businesspa0_.C_SalesRegion_ID as c_sales17_203_, businesspa0_.C_BPartner_ID as c_bpart18_203_, businesspa0_.C_Location_ID as c_locat19_203_, businesspa0_.IsTaxLocation as istaxlo20_203_, businesspa0_.UPC as upc21_203_, businesspa0_.Isdefault_Shipto as isdefau22_203_, businesspa0_.Isdefault_Billto as isdefau23_203_, businesspa0_.EM_Cbp_Name as em_cbp_24_203_, businesspa0_.EM_Cbp_Email as em_cbp_25_203_, businesspa0_.EM_Prpres_Taxid as em_prpr26_203_, businesspa0_.EM_Cbp_Deliverynotes as em_cbp_27_203_, businesspa0_.EM_Prpres_Mail as em_prpr28_203_, businesspa0_.EM_Prpres_Add_Prestashop_ID as em_prpr29_203_, businesspa0_.EM_Prpres_Firstname as em_prpr30_203_, businesspa0_.EM_Prpres_Lastname as em_prpr31_203_, businesspa0_.EM_Prpres_Company as em_prpr32_203_ from C_BPartner_Location businesspa0_ where (upper(businesspa0_.Name) like upper($1) escape '|') and (exists ( select 1 from M_InOut materialmg1_ inner join C_BPartner_Location businesspa2_ on materialmg1_.C_BPartner_Location_ID = businesspa2_.C_BPartner_Location_ID cross join C_DocType documentty3_ where materialmg1_.C_DocType_ID = documentty3_.C_DocType_ID and (materialmg1_.MovementType in ('C-', 'C+')) and materialmg1_.Islogistic = 'N' and documentty3_.IsReturn = 'N' and businesspa2_.C_BPartner_Location_ID = businesspa0_.C_BPartner_Location_ID and (materialmg1_.AD_Org_ID in ('1719A04199DC4DFD8A8CC20FF3B2DF84', '745D3456480F46E6861190B2B4BFEC56', '276F34585F7646A496549D1A9F798D18', '9C9C680303C7417CBE51A6D034CC19F9', '924516A77B2F4CFB8A1A453B10C7EC8F', '66A8901AFC44466C8BAD957D688FF2E9', 'D51DF6E77C264F288CDDFB32796CEA2E', '0534338A16B346CDA9811368A0ABD8DA', '1375D2F14D194AFE9F37876037EBD817', '0', '02DA0564A9634B0DB99689D181E27EBA', '0C5E0BFF321A497FBD15E8C1460657EF', 'CF1F05A03BD94C22AB1C2A293B018D18', '83E3BE9B06BD4DB3B7CC4BB6353ED7AD')) and (materialmg1_.AD_Client_ID in ('FE15EC7B26084C628B4BC52B148B446F', '0')))) order by businesspa0_.Name limit $2;

Date: 2026-06-30 14:52:08
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.7

x Hide

SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

Date: 2026-06-29 23:14:24
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.7

x Hide

SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'C87680E3A48C4739BCE988CAC7C28554' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-06-29 23:14:24
Duration: 6m54s
Database: openbravo
User: tad
Remote: 10.3.1.7

SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7697CC9B2F454CB895D48D7C04A0C5DF' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-06-29 23:16:20
Duration: 1m
Database: openbravo
User: tad
Remote: 10.3.1.7

SELECT * FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-06-29 23:08:29
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.7

x Hide

SELECT * FROM ( select record_id as referencekey_id, ;

Date: 2026-06-29 23:15:10
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.7

x Hide

SELECT * FROM ( select f.c_invoice_id as referencekey_id, ;

Date: 2026-06-29 23:17:41
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.7

x Hide

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-06-29 23:17:44
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.7

x Hide

'Y' as SHOWLOGO, m_product.ad_client_id, m_product.ad_org_id as ORGANIZATIONID, m_product.c_bpartner_id AS codprv, m_product.m_product_category_id AS codcat, m_product.m_product_id AS codprd, m_product_category.value AS catvalue, m_product_category.name AS catname, m_product_category.em_alndap_calctype AS calctype, m_product_category.em_alndap_margin AS margin, right (m_product.value, 8) AS prdvalue, m_product.name AS prdname, m_product.upc AS prdupc, m_product.sku AS prcsku, m_product.em_alndap_bp_ref AS prvref, lc.pricelist as coste, lc.pricestd as neto, m_product.em_alndap_surchgamount as rec, m_product.em_alndap_surchg as porcrec, m_product.em_alndap_sale_unit as uv, m_product.em_alndap_buy_unit as uc, m_product.em_alndap_exclude as bloq, c_bpartner.value as prvval, c_bpartner.name as prvnom, c_currency.iso_code as moneda, coalesce(disc1.discount, 0) as dto1, coalesce(disc2.discount, 0) as dto2, coalesce(disc3.discount, 0) as dto3, coalesce(disc4.discount, 0) as dto4, coalesce(m_product.stockmin, 0) as stockmin, coalesce(( select sum(sd.qtyonhand) from public.m_storage_detail sd where sd.m_product_id = m_product.m_product_id and sd.m_locator_id in ( select m_locator_id from m_locator where m_warehouse_id in ('B70148B5DC6C4A07AF886559881CBC79', 'EA8BA9C5515D41288BF585619CD93EE9'))), 0) as stock, coalesce(( select sum(sd.reservedqty) from public.m_storage_detail sd where sd.m_product_id = m_product.m_product_id and sd.m_locator_id in ( select m_locator_id from m_locator where m_warehouse_id in ('B70148B5DC6C4A07AF886559881CBC79', 'EA8BA9C5515D41288BF585619CD93EE9'))), 0) as stockreservado, round(coalesce(( select sum(ol.qtyordered) from c_order o inner join c_orderline ol on o.c_order_id = ol.c_order_id where o.dateordered >= 'Tue Jun 30 00:00:00 CEST 2026' and o.dateordered <= 'Tue Jun 30 00:00:00 CEST 2026' and o.docstatus in ('CO', 'CL') and ol.m_product_id = m_product.m_product_id and o.issotrx = 'Y'), 0), 0) as vtaperiodo, round(coalesce(( select sum(ol.qtyordered) from c_order o inner join c_orderline ol on o.c_order_id = ol.c_order_id where o.dateordered >= 'Tue Jun 30 00:00:00 CEST 2026' and o.dateordered <= 'Tue Jun 30 00:00:00 CEST 2026' and o.docstatus in ('CO', 'CL') and ol.m_product_id = m_product.m_product_id and o.issotrx = 'N'), 0), 0) as cpraperiodo, coalesce(( select sum(( case when ol.qtyordered > 0 then ( case when abs(ol.qtyordered) > coalesce(( select sum(abs(sl.movementqty)) from m_inoutline sl where sl.c_orderline_id = ol.c_orderline_id), 0) then abs(ol.qtyordered) - coalesce(( select sum(abs(sl.movementqty)) from m_inoutline sl where sl.c_orderline_id = ol.c_orderline_id), 0) else 0 end) else 0 end)) from c_order o inner join c_orderline ol on o.c_order_id = ol.c_order_id where o.dateordered > '2019-01-01' and o.docstatus in ('CO') and ol.m_product_id = m_product.m_product_id and o.issotrx = 'Y'), 0) as pdteservir, coalesce(( select sum(( case when ol.qtyordered > 0 then ( case when abs(ol.qtyordered) > coalesce(( select sum(abs(sl.movementqty)) from m_inoutline sl where sl.c_orderline_id = ol.c_orderline_id), 0) then abs(ol.qtyordered) - coalesce(( select sum(abs(sl.movementqty)) from m_inoutline sl where sl.c_orderline_id = ol.c_orderline_id), 0) else 0 end) else 0 end)) from c_order o inner join c_orderline ol on o.c_order_id = ol.c_order_id where o.dateordered > '2019-01-01' and o.docstatus in ('CO') and ol.m_product_id = m_product.m_product_id and o.issotrx = 'N'), 0) as pdterecibir FROM m_product INNER JOIN m_productprice as lc on lc.m_product_id = m_product.m_product_id INNER JOIN m_pricelist_version as lv on lv.m_pricelist_version_id = lc.m_pricelist_version_id INNER join m_pricelist on m_pricelist.m_pricelist_id = lv.m_pricelist_id INNER join c_bpartner on c_bpartner.po_pricelist_id = m_pricelist.m_pricelist_id LEFT join c_currency on c_currency.c_currency_id = m_pricelist.c_currency_id left join m_product_category on m_product.m_product_category_id = m_product_category.m_product_category_id left join m_product_po on m_product_po.c_bpartner_id = c_bpartner.c_bpartner_id and m_product_po.m_product_id = m_product.m_product_id and m_product_po.isactive = 'Y' left join alndap_bp_cascadedis on alndap_bp_cascadedis.alndap_bp_cascadedis_id = m_product_po.em_alndap_bp_cascadedis_id left join c_discount as disc1 on disc1.c_discount_id = alndap_bp_cascadedis.c_disc1_id left join c_discount as disc2 on disc2.c_discount_id = alndap_bp_cascadedis.c_disc2_id left join c_discount as disc3 on disc3.c_discount_id = alndap_bp_cascadedis.c_disc3_id left join c_discount as disc4 on disc4.c_discount_id = alndap_bp_cascadedis.c_disc4_id WHERE m_product.ad_client_id in ('0', 'FE15EC7B26084C628B4BC52B148B446F') and (c_bpartner.c_bpartner_id = 'B7E0B9555EDD468B80D4647A135583E7') and c_bpartner.isvendor = 'Y' and m_product.m_product_status_id in ('74024489627B42B0B50F3447A5D315CD') and m_product.issold = 'Y' ORDER BY c_bpartner.c_bpartner_id, m_product_category.value, m_product.em_alndap_bp_ref, m_product.m_product_category_id;

Date: 2026-06-30 07:25:26
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.7

x Hide