select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('290831%') escape '|' or upper(product1_.Value) like upper('290831%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('290831%') escape '|' or do_m_produ0_.Qtyavaliable = '290831' or upper(attributes3_.Description) like upper('290831%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('290831%') escape '|' or do_m_produ0_.Stocktotal = '290831' or upper(product1_.Name) like upper('290831%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = 'F0E92FF4C5D24B2DA3B6706AB3921D25') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF8081812FBA40E4012FBA619FB00011' and do_m_produ0_.M_Warehouse_ID = 'FF8081812FBB6FE4012FBB8A4239007A' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-16 08:51:33
Duration: 5s333ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('2908310%') escape '|' or upper(product1_.Value) like upper('2908310%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('2908310%') escape '|' or do_m_produ0_.Qtyavaliable = '2908310' or upper(attributes3_.Description) like upper('2908310%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('2908310%') escape '|' or do_m_produ0_.Stocktotal = '2908310' or upper(product1_.Name) like upper('2908310%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = 'F0E92FF4C5D24B2DA3B6706AB3921D25') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF8081812FBA40E4012FBA619FB00011' and do_m_produ0_.M_Warehouse_ID = 'FF8081812FBB6FE4012FBB8A4239007A' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-16 08:51:33
Duration: 4s727ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('50%') escape '|' or upper(product1_.Value) like upper('50%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('50%') escape '|' or do_m_produ0_.Qtyavaliable = '50' or upper(attributes3_.Description) like upper('50%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('50%') escape '|' or do_m_produ0_.Stocktotal = '50' or upper(product1_.Name) like upper('50%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = 'ADF37312CC014CACB369ABCCE024CF88') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF8081812FBA40E4012FBA619FB00011' and do_m_produ0_.M_Warehouse_ID = 'FF8081812FBB6FE4012FBB8A4239007A' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-16 17:09:36
Duration: 4s328ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT fin_payment.created, c_invoice.dateinvoiced as "dataFactura", c_invoice.documentno as "numFactura", fin_paymentmethod.name as "tipoCobro", c_bpartner.value as "valuePartner", c_bpartner.name as "namePartner", max(FIN_Payment_Sched_Inv_V.duedate) as "fechaVencimiento", c_invoice.grandtotal as "total", c_invoice.totalpaid as "totalPagado", case when count(*) = 1 then 'A' when count(*) = 2 then 'B' when count(*) = 3 then 'C' else '-' END as "rebut", c_invoice.ispaid as "pagado", ad_sequence.prefix as "prefijo", sum(fin_payment_detail_v.Paidamt) as "paidamt", fin_payment_detail_v.Paymentdate from c_invoice LEFT JOIN FIN_Payment_Sched_Inv_V ON FIN_Payment_Sched_Inv_V.c_invoice_id = c_invoice.c_invoice_id left join c_bpartner on c_bpartner.c_bpartner_id = c_invoice.c_bpartner_id left join c_doctype on c_doctype.c_doctype_id = c_invoice.c_doctype_id left join ad_sequence on ad_sequence.ad_sequence_id = c_doctype.docnosequence_id left join fin_payment_detail_v on fin_payment_detail_v.fin_payment_sched_inv_id = fin_payment_sched_inv_V.fin_payment_sched_inv_v_id left join fin_paymentmethod on fin_paymentmethod.fin_paymentmethod_id = fin_payment_detail_v.fin_paymentmethod_id left join fin_payment on fin_payment.fin_payment_id = fin_payment_detail_v.fin_payment_id where 1 = 1 --and isreceipt='Y' and c_invoice.ad_client_id = $1 and c_invoice.ad_org_id in ('FF8081813510684B01354402F76B59F3') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') <= to_date('15-07-2026', 'dd-mm-yyyy') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') >= to_date('15-07-2026', 'dd-mm-yyyy') and (c_doctype.name = 'Factura D' or c_doctype.name = 'Factura N' or c_doctype.name = 'Factura P3D' or c_doctype.name = 'Factura P3N' or c_doctype.name = 'Factura Compra') group by c_invoice.dateinvoiced, c_invoice.documentno, fin_paymentmethod.name, c_bpartner.value, c_bpartner.name, c_invoice.grandtotal, c_invoice.totalpaid, c_invoice.ispaid, ad_sequence.prefix, fin_payment_detail_v.Paymentdate, fin_payment.created order by ad_sequence.prefix, c_invoice.dateinvoiced, c_invoice.documentno;

Date: 2026-07-16 07:12:14
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT fin_payment.created, c_invoice.dateinvoiced as "dataFactura", c_invoice.documentno as "numFactura", fin_paymentmethod.name as "tipoCobro", c_bpartner.value as "valuePartner", c_bpartner.name as "namePartner", max(FIN_Payment_Sched_Inv_V.duedate) as "fechaVencimiento", c_invoice.grandtotal as "total", c_invoice.totalpaid as "totalPagado", case when count(*) = 1 then 'A' when count(*) = 2 then 'B' when count(*) = 3 then 'C' else '-' END as "rebut", c_invoice.ispaid as "pagado", ad_sequence.prefix as "prefijo", sum(fin_payment_detail_v.Paidamt) as "paidamt", fin_payment_detail_v.Paymentdate from c_invoice LEFT JOIN FIN_Payment_Sched_Inv_V ON FIN_Payment_Sched_Inv_V.c_invoice_id = c_invoice.c_invoice_id left join c_bpartner on c_bpartner.c_bpartner_id = c_invoice.c_bpartner_id left join c_doctype on c_doctype.c_doctype_id = c_invoice.c_doctype_id left join ad_sequence on ad_sequence.ad_sequence_id = c_doctype.docnosequence_id left join fin_payment_detail_v on fin_payment_detail_v.fin_payment_sched_inv_id = fin_payment_sched_inv_V.fin_payment_sched_inv_v_id left join fin_paymentmethod on fin_paymentmethod.fin_paymentmethod_id = fin_payment_detail_v.fin_paymentmethod_id left join fin_payment on fin_payment.fin_payment_id = fin_payment_detail_v.fin_payment_id where isreceipt = 'Y' and c_invoice.ad_client_id = $1 and c_invoice.ad_org_id in ('FF8081812FBA2641012FBA3528033423', 'FF8081812FBA2641012FBA2DCB5E001E', 'A15AA70C8D23453DA93ACD1442681D80') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') <= to_date('15-07-2026', 'dd-mm-yyyy') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') >= to_date('15-07-2026', 'dd-mm-yyyy') and c_doctype.name != 'Factura D' and c_doctype.name != 'Factura N' group by c_invoice.dateinvoiced, c_invoice.documentno, fin_paymentmethod.name, c_bpartner.value, c_bpartner.name, c_invoice.grandtotal, c_invoice.totalpaid, c_invoice.ispaid, ad_sequence.prefix, fin_payment_detail_v.Paymentdate, fin_payment.created order by ad_sequence.prefix, c_invoice.dateinvoiced, c_invoice.documentno;

Date: 2026-07-16 07:12:10
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('60993%') escape '|' or upper(product1_.Value) like upper('60993%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('60993%') escape '|' or do_m_produ0_.Qtyavaliable = '60993' or upper(attributes3_.Description) like upper('60993%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('60993%') escape '|' or do_m_produ0_.Stocktotal = '60993' or upper(product1_.Name) like upper('60993%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = '29B3A8E6BA3942BC8CB3CFDD9A1FEBA2') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF808181309287D001309309FC030155' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-16 10:55:33
Duration: 6s978ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('609%') escape '|' or upper(product1_.Value) like upper('609%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('609%') escape '|' or do_m_produ0_.Qtyavaliable = '609' or upper(attributes3_.Description) like upper('609%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('609%') escape '|' or do_m_produ0_.Stocktotal = '609' or upper(product1_.Name) like upper('609%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = '29B3A8E6BA3942BC8CB3CFDD9A1FEBA2') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF808181309287D001309309FC030155' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-16 10:55:33
Duration: 6s955ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('6099341%') escape '|' or upper(product1_.Value) like upper('6099341%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('6099341%') escape '|' or do_m_produ0_.Qtyavaliable = '6099341' or upper(attributes3_.Description) like upper('6099341%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('6099341%') escape '|' or do_m_produ0_.Stocktotal = '6099341' or upper(product1_.Name) like upper('6099341%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = '29B3A8E6BA3942BC8CB3CFDD9A1FEBA2') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF808181309287D001309309FC030155' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-16 10:55:33
Duration: 6s939ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

insert into C_Order (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, C_DocType_ID, C_DocTypeTarget_ID, IsDelivered, IsInvoiced, IsPrinted, IsSelected, DateOrdered, DatePromised, DateAcct, C_BPartner_ID, BillTo_ID, C_BPartner_Location_ID, IsDiscountPrinted, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, InvoiceRule, DeliveryRule, FreightCostRule, FreightAmt, DeliveryViaRule, ChargeAmt, PriorityRule, TotalLines, GrandTotal, M_Warehouse_ID, M_PriceList_ID, IsTaxIncluded, Posted, CopyFrom, IsSelfService, Generatetemplate, Delivery_Location_ID, CopyFromPO, FIN_Paymentmethod_ID, RM_PickFromShipment, RM_ReceiveMaterials, RM_CreateInvoice, RM_AddOrphanLine, Calculate_Promotions, Convertquotation, Create_POLines, Iscashvat, RM_Pickfromreceipt, Cancelandreplace, EM_APRM_AddPayment, EM_Obwpl_Generatepicking, EM_Obwpl_Isinpickinglist, EM_Obwpl_Readypl, Confirmcancelandreplace, Iscancelled, EM_Do_Portes, EM_Do_Albaranvalorado, EM_Prouti_Order_Stock, EM_Prouti_Pregenerate_Minout, EM_Prouti_Sotopo, EM_Do_Entregado, EM_Prouti_Generate_Pick_Inv, EM_Do_Esinterno, EM_Do_Aceptaprecios, EM_Do_Preparado, EM_Prouti_Changebpartner, EM_Prouti_Recalculate_Price, EM_Do_Createinout, EM_Prouti_Reactiveorder, EM_Do_Inoutdone, em_prouti_Invoiced, EM_Do_Tercerocontado, em_prouti_Received, EM_Do_Crearpedidooferta, EM_Pbsp_Sigcaptured, em_prouti_initial_received, EM_Do_Mediosenvio_ID, EM_Do_Cierrepedido, em_do_validate_usr_processing, EM_Do_Issended, EM_Do_Resend, EM_Prouti_Status_Of_Review, EM_Prouti_Validate_Order, EM_Prouti_Start_Review, EM_Pr592_Exclude_Tax, C_Order_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95);

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

x Hide

update C_BPartner set Updated = $1, InvoiceRule = $2 where C_BPartner_ID = $3;

Date: 2026-07-16 16:10:25
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

ROLLBACK;

Date: 2026-07-16 07:30:00
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

insert into M_ProductPrice (M_PriceList_Version_ID, M_Product_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, PriceList, PriceStd, PriceLimit, Cost, Algorithm, EM_Pruti_Inheritprice, M_ProductPrice_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16);

Date: 2026-07-16 10:09:04
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

update C_Order set Updated = $1, UpdatedBy = $2, C_PaymentTerm_ID = $3, InvoiceRule = $4, DeliveryRule = $5, DeliveryViaRule = $6 where C_Order_ID = $7;

Date: 2026-07-16 08:06:55
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide