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-28 23:09:45 - 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-28 23:09:46 - 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-28 23:09:46 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

[ Date: 2026-06-28 23:14:10 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

[ Date: 2026-06-28 23:15:59 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

[ Date: 2026-06-28 23:14:11 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

SELECT * FROM ( select record_id as referencekey_id, ;

[ Date: 2026-06-28 23:14:40 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

[ Date: 2026-06-28 23:14:10 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

[ Date: 2026-06-28 23:15:59 - 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-28 23:09:46 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

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

[ Date: 2026-06-28 23:17:18 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

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-28 23:17:21 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

[ Date: 2026-06-28 23:15:59 - 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-28 23:09:12 - Database: openbravo - User: tad - Remote: 10.3.1.7 ]

SELECT * FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED FINANCIAL ACCOUNT TRANSACTION' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('FIN_Finacc_Transaction', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '4D8C3B3C31D1410DA046140C9F024D17' GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'FF80808132AB77870132AB83CEFB0013' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-06-28 23:05:35 - Database: openbravo - User: tad - Remote: 10.3.1.7 - Bind query: yes ]

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-28 23:14:10 - Database: openbravo - User: tad - Remote: 10.3.1.7 - Bind query: yes ]

delete from OBANALY_FACT_SALESORDHEADER where AD_Client_ID = 'FE15EC7B26084C628B4BC52B148B446F' and (Updated < ( select order1_.Updated from C_Order order1_ where order1_.C_Order_ID = OBANALY_FACT_SALESORDHEADER.C_Order_ID) or exists ( select invoicelin2_.C_InvoiceLine_ID from C_InvoiceLine invoicelin2_ cross join C_Invoice invoice3_ cross join C_OrderLine orderline4_ where invoicelin2_.C_Invoice_ID = invoice3_.C_Invoice_ID and invoicelin2_.C_OrderLine_ID = orderline4_.C_OrderLine_ID and (invoicelin2_.Updated >= OBANALY_FACT_SALESORDHEADER.Updated or invoice3_.Updated >= OBANALY_FACT_SALESORDHEADER.Updated) and orderline4_.C_Order_ID = OBANALY_FACT_SALESORDHEADER.C_Order_ID));

[ Date: 2026-06-28 23:04:51 - Database: openbravo - User: tad - Remote: 10.3.1.7 - Bind query: yes ]

select distinct * from ( WITH filtered_comb AS ( SELECT * FROM prpres_combination WHERE m_product_id IS NOT NULL), filtered_product AS ( SELECT prpres_product_id, ps_product_id, prpres_conf_id FROM prpres_product WHERE ps_product_id IS NOT NULL AND prpres_conf_id = '5695DB7E18DF4724940A983674427AFA'), valid_doctypes AS ( SELECT c_doctype_id FROM c_doctype WHERE docsubtypeso NOT LIKE 'OB'), conf_sync AS ( SELECT last_inventory_sync FROM prpres_conf WHERE prpres_conf_id = '5695DB7E18DF4724940A983674427AFA'), filtered_orderline AS ( SELECT ol.* FROM c_orderline ol JOIN conf_sync c ON ol.updated >= c.last_inventory_sync), filtered_order AS ( SELECT o.* FROM c_order o JOIN conf_sync c ON o.updated >= c.last_inventory_sync WHERE o.docstatus != 'DR' AND o.issotrx = 'Y'), filtered_sales_product AS ( SELECT DISTINCT ol.m_product_id FROM c_orderline ol JOIN c_order o ON o.c_order_id = ol.c_order_id JOIN prpres_product p ON ol.m_product_id = p.m_product_id JOIN m_product mp ON mp.m_product_id = p.m_product_id AND mp.isgeneric = 'N' JOIN c_doctype dt ON dt.c_doctype_id = o.c_doctypetarget_id AND dt.docsubtypeso NOT LIKE 'OB' JOIN conf_sync c ON ol.updated >= c.last_inventory_sync OR o.updated >= c.last_inventory_sync WHERE o.docstatus != 'DR' AND o.issotrx = 'Y' AND p.ps_product_id IS NOT NULL AND p.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA'), filtered_sales_comb AS ( SELECT DISTINCT ol.m_product_id FROM c_orderline ol JOIN c_order o ON o.c_order_id = ol.c_order_id JOIN prpres_combination comb ON ol.m_product_id = comb.m_product_id JOIN prpres_product p ON p.prpres_product_id = comb.prpres_product_id JOIN m_product mp ON mp.m_product_id = comb.m_product_id AND mp.isgeneric = 'N' JOIN c_doctype dt ON dt.c_doctype_id = o.c_doctypetarget_id AND dt.docsubtypeso NOT LIKE 'OB' JOIN conf_sync c ON ol.updated >= c.last_inventory_sync OR o.updated >= c.last_inventory_sync WHERE o.docstatus != 'DR' AND o.issotrx = 'Y' AND p.ps_product_id IS NOT NULL AND p.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA' ) SELECT DISTINCT pprod.m_product_id, pprod.ps_product_id AS baseprodid, '0' AS combinationid, pprod.stock_id, pprod.shop_id, COALESCE(pprod.group_id, '0') as group_id, COALESCE(pprod.out_of_stock, '2') as out_of_stock, COALESCE(pprod.depends_on_stock, '0') as depends_on_stock FROM prpres_product pprod JOIN prpres_conf conf ON conf.prpres_conf_id = pprod.prpres_conf_id JOIN m_product mp ON mp.m_product_id = pprod.m_product_id AND mp.isgeneric = 'N' JOIN m_transaction trx ON trx.m_product_id = pprod.m_product_id AND trx.trxprocessdate >= conf.last_inventory_sync WHERE pprod.ps_product_id IS NOT NULL AND pprod.m_product_id IS NOT NULL AND pprod.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA' UNION ALL SELECT DISTINCT pprod.m_product_id, pprod.ps_product_id, '0', pprod.stock_id, pprod.shop_id, COALESCE(pprod.group_id, '0') as group_id, COALESCE(pprod.out_of_stock, '2') as out_of_stock, COALESCE(pprod.depends_on_stock, '0') as depends_on_stock FROM prpres_product pprod JOIN prpres_conf conf ON conf.prpres_conf_id = pprod.prpres_conf_id JOIN m_product mp ON mp.m_product_id = pprod.m_product_id AND mp.isgeneric = 'N' WHERE pprod.ps_product_id IS NOT NULL AND pprod.m_product_id IS NOT NULL AND pprod.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA' AND COALESCE(pprod.inventory_date, pprod.created) >= conf.last_inventory_sync UNION ALL SELECT DISTINCT pprod.m_product_id, pprod.ps_product_id, '0', pprod.stock_id, pprod.shop_id, COALESCE(pprod.group_id, '0') as group_id, COALESCE(pprod.out_of_stock, '2') as out_of_stock, COALESCE(pprod.depends_on_stock, '0') as depends_on_stock FROM prpres_product pprod JOIN m_product mp ON mp.m_product_id = pprod.m_product_id AND mp.isgeneric = 'N' JOIN filtered_orderline ol ON ol.m_product_id = pprod.m_product_id JOIN filtered_order o ON o.c_order_id = ol.c_order_id JOIN valid_doctypes dt ON dt.c_doctype_id = o.c_doctypetarget_id WHERE pprod.ps_product_id IS NOT NULL AND pprod.m_product_id IS NOT NULL AND pprod.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA' UNION ALL SELECT DISTINCT pcomb.m_product_id, pprod.ps_product_id, pcomb.ps_combination_id, pcomb.stock_id, pcomb.shop_id, COALESCE(pcomb.group_id, '0') as group_id, COALESCE(pcomb.out_of_stock, '2') as out_of_stock, COALESCE(pcomb.depends_on_stock, '0') as depends_on_stock FROM prpres_combination pcomb JOIN prpres_product pprod ON pprod.prpres_product_id = pcomb.prpres_product_id JOIN prpres_conf conf ON conf.prpres_conf_id = pprod.prpres_conf_id JOIN m_product mp ON mp.m_product_id = pcomb.m_product_id AND mp.isgeneric = 'N' JOIN m_transaction trx ON trx.m_product_id = pcomb.m_product_id AND trx.trxprocessdate >= conf.last_inventory_sync WHERE pprod.ps_product_id IS NOT NULL AND pcomb.m_product_id IS NOT NULL AND pprod.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA' UNION ALL SELECT DISTINCT pcomb.m_product_id, pprod.ps_product_id, pcomb.ps_combination_id, pcomb.stock_id, pcomb.shop_id, COALESCE(pcomb.group_id, '0') as group_id, COALESCE(pcomb.out_of_stock, '2') as out_of_stock, COALESCE(pcomb.depends_on_stock, '0') as depends_on_stock FROM prpres_combination pcomb JOIN prpres_product pprod ON pprod.prpres_product_id = pcomb.prpres_product_id JOIN prpres_conf conf ON conf.prpres_conf_id = pprod.prpres_conf_id JOIN m_product mp ON mp.m_product_id = pcomb.m_product_id AND mp.isgeneric = 'N' WHERE pprod.ps_product_id IS NOT NULL AND pcomb.m_product_id IS NOT NULL AND pprod.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA' AND COALESCE(pcomb.inventory_date, pcomb.created) >= conf.last_inventory_sync UNION ALL SELECT DISTINCT comb.m_product_id, prod.ps_product_id, comb.ps_combination_id, comb.stock_id, comb.shop_id, COALESCE(comb.group_id, '0') as group_id, COALESCE(comb.out_of_stock, '2') as out_of_stock, COALESCE(comb.depends_on_stock, '0') as depends_on_stock FROM filtered_comb comb JOIN filtered_product prod ON prod.prpres_product_id = comb.prpres_product_id JOIN m_product mp ON mp.m_product_id = comb.m_product_id AND mp.isgeneric = 'N' JOIN filtered_orderline ol ON ol.m_product_id = comb.m_product_id JOIN filtered_order o ON o.c_order_id = ol.c_order_id JOIN valid_doctypes dt ON dt.c_doctype_id = o.c_doctypetarget_id WHERE prod.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA' UNION ALL SELECT DISTINCT pprod.m_product_id, pprod.ps_product_id, '0', pprod.stock_id, pprod.shop_id, COALESCE(pprod.group_id, '0') as group_id, COALESCE(pprod.out_of_stock, '2') as out_of_stock, COALESCE(pprod.depends_on_stock, '0') as depends_on_stock FROM prpres_product pprod JOIN filtered_sales_product fsp ON fsp.m_product_id = pprod.m_product_id WHERE pprod.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA' UNION ALL SELECT DISTINCT comb.m_product_id, pprod.ps_product_id, comb.ps_combination_id, comb.stock_id, comb.shop_id, COALESCE(comb.group_id, '0') as group_id, COALESCE(comb.out_of_stock, '2') as out_of_stock, COALESCE(comb.depends_on_stock, '0') as depends_on_stock FROM prpres_combination comb JOIN prpres_product pprod ON pprod.prpres_product_id = comb.prpres_product_id JOIN filtered_sales_comb fsc ON fsc.m_product_id = comb.m_product_id WHERE pprod.prpres_conf_id = '5695DB7E18DF4724940A983674427AFA') f;