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 distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-14 08:00:01
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select pruti_bpar0_.Pruti_Bpartner_Info_ID as pruti_bp1_861_, pruti_bpar0_.AD_Client_ID as ad_clien2_861_, pruti_bpar0_.AD_Org_ID as ad_org_i3_861_, pruti_bpar0_.Isactive as isactive4_861_, pruti_bpar0_.Created as created5_861_, pruti_bpar0_.Createdby as createdb6_861_, pruti_bpar0_.Updated as updated7_861_, pruti_bpar0_.Updatedby as updatedb8_861_, pruti_bpar0_.Value as value9_861_, pruti_bpar0_.Name as name10_861_, pruti_bpar0_.TaxID as taxid11_861_, pruti_bpar0_.IsCustomer as iscusto12_861_, pruti_bpar0_.IsVendor as isvendo13_861_, pruti_bpar0_.InvoiceRule as invoice14_861_, pruti_bpar0_.C_Invoiceschedule_ID as c_invoi15_861_, pruti_bpar0_.FixMonthDay as fixmont16_861_, pruti_bpar0_.FixMonthDay2 as fixmont17_861_, pruti_bpar0_.fixmonthday3 as fixmont18_861_, pruti_bpar0_.Invoicegrouping as invoice19_861_, pruti_bpar0_.FIN_Paymentmethod_ID as fin_pay20_861_, pruti_bpar0_.PO_Bp_Taxcategory_ID as po_bp_t21_861_, pruti_bpar0_.SO_Bp_Taxcategory_ID as so_bp_t22_861_, pruti_bpar0_.C_Paymentterm_ID as c_payme23_861_, pruti_bpar0_.FIN_Financial_Account_ID as fin_fin24_861_, pruti_bpar0_.M_Pricelist_ID as m_price25_861_, pruti_bpar0_.Salesrep_ID as salesre26_861_, pruti_bpar0_.PO_Paymentmethod_ID as po_paym27_861_, pruti_bpar0_.PO_Paymentterm_ID as po_paym28_861_, pruti_bpar0_.PO_Financial_Account_ID as po_fina29_861_, pruti_bpar0_.PO_Fixmonthday as po_fixm30_861_, pruti_bpar0_.PO_Fixmonthday2 as po_fixm31_861_, pruti_bpar0_.PO_Fixmonthday3 as po_fixm32_861_, pruti_bpar0_.IsBillTo as isbillt33_861_, pruti_bpar0_.IsShipTo as isshipt34_861_, pruti_bpar0_.IsPayFrom as ispayfr35_861_, pruti_bpar0_.IsRemitTo as isremit36_861_, pruti_bpar0_.Phone as phone37_861_, pruti_bpar0_.Phone2 as phone38_861_, pruti_bpar0_.Fax as fax39_861_, pruti_bpar0_.C_Salesregion_ID as c_sales40_861_, pruti_bpar0_.City as city41_861_, pruti_bpar0_.Address1 as address42_861_, pruti_bpar0_.Address2 as address43_861_, pruti_bpar0_.C_Country_ID as c_count44_861_, pruti_bpar0_.C_Region_ID as c_regio45_861_, pruti_bpar0_.Contactname as contact46_861_, pruti_bpar0_.Email as email47_861_, pruti_bpar0_.Contactphone as contact48_861_, pruti_bpar0_.Name2 as name49_861_, pruti_bpar0_.C_Bpartner_Location_ID as c_bpart50_861_, pruti_bpar0_.Customer_Blocking as custome51_861_, pruti_bpar0_.SO_Order_Blocking as so_orde52_861_, pruti_bpar0_.SO_Goods_Blocking as so_good53_861_, pruti_bpar0_.SO_Invoice_Blocking as so_invo54_861_, pruti_bpar0_.SO_Payment_Blocking as so_paym55_861_, pruti_bpar0_.Vendor_Blocking as vendor_56_861_, pruti_bpar0_.PO_Order_Blocking as po_orde57_861_, pruti_bpar0_.PO_Goods_Blocking as po_good58_861_, pruti_bpar0_.PO_Invoice_Blocking as po_invo59_861_, pruti_bpar0_.PO_Payment_Blocking as po_paym60_861_ from pruti_bpartner_info pruti_bpar0_ left outer join FIN_Financial_Account fin_financ1_ on pruti_bpar0_.FIN_Financial_Account_ID = fin_financ1_.Fin_Financial_Account_ID where (pruti_bpar0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) and (pruti_bpar0_.AD_Client_ID in ('3C5B81C4F43246A88CB0D6064A5E0530', '0')) order by fin_financ1_.Name desc, pruti_bpar0_.Pruti_Bpartner_Info_ID desc;

Date: 2026-07-14 11:23:56
Duration: 4s717ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID = product1_.M_Product_ID and product1_.C_UOM_ID = uom3_.C_UOM_ID and orderline0_.C_Order_ID = order5_.C_Order_ID and orderline0_.M_Product_ID = product7_.M_Product_ID and order5_.DocStatus = 'CO' and order5_.IsSOTrx = 'Y' and 1 = 1 and orderline0_.AD_Client_ID = '3C5B81C4F43246A88CB0D6064A5E0530' and (product7_.Name like '%') and (orderline0_.AD_Org_ID in ('0', '9F4FFFC6F7674F6F917C736776A79EFD')) group by product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit '10';

Date: 2026-07-14 15:15:19
Duration: 1s267ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide