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('84%') escape '|' or upper(product1_.Value) like upper('84%') 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('84%') escape '|' or do_m_produ0_.Qtyavaliable = '84' or upper(attributes3_.Description) like upper('84%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('84%') escape '|' or do_m_produ0_.Stocktotal = '84' or upper(product1_.Name) like upper('84%') 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 = '15028879C18A4127845C292F0C72D56F') = '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-15 09:18:50
Duration: 5s13ms
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('84102%') escape '|' or upper(product1_.Value) like upper('84102%') 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('84102%') escape '|' or do_m_produ0_.Qtyavaliable = '84102' or upper(attributes3_.Description) like upper('84102%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('84102%') escape '|' or do_m_produ0_.Stocktotal = '84102' or upper(product1_.Name) like upper('84102%') 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 = '15028879C18A4127845C292F0C72D56F') = '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-15 09:18:52
Duration: 4s982ms
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('8410%') escape '|' or upper(product1_.Value) like upper('8410%') 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('8410%') escape '|' or do_m_produ0_.Qtyavaliable = '8410' or upper(attributes3_.Description) like upper('8410%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('8410%') escape '|' or do_m_produ0_.Stocktotal = '8410' or upper(product1_.Name) like upper('8410%') 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 = '15028879C18A4127845C292F0C72D56F') = '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-15 09:18:51
Duration: 4s779ms
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('14-07-2026', 'dd-mm-yyyy') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') >= to_date('14-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-15 07:12:44
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select coalesce(m_inout.ad_org_id, c_order.ad_org_id) as ad_org_id, coalesce(M_INOUT.M_INOUT_ID, ( select M_INOUT_ID from M_INOUT mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1)) as "M_INOUT_ID", coalesce(M_INOUT.DOCUMENTNO, ( select documentno from M_INOUT mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1)) AS "AlabranNp", coalesce(M_INOUT.MOVEMENTDATE, c_order.dateordered) AS "MOVEMENTDATE", coalesce(m_inout.c_order_id, c_order.c_order_id) AS "C_ORDER_ID", c_order.documentno as "PedidoNo", c_bpartner.value as "ValueTercero", C_BPARTNER.TAXID AS "TaxTercero", C_BPARTNER.NAME AS "NameTercero", m_product.name "NameProduct", m_product.value "ValueProduct", coalesce(m_inoutline.movementqty, c_orderline.qtyordered) as movementqty, c_orderline.pricestd, c_order.grandtotal, c_orderline.description as "descLine", FIN_PAYMENTMETHOD.NAME as "FORMAPAGO", c_paymentterm.name "ConPago", c_uom.uomsymbol "Unidad", c_tax.rate "IVA", c_orderline.em_do_udtarifa "UdTarifa", c_orderline.em_do_nombreauxiliar as "nombreAux", case m_product.em_do_udtarifa when 'K' then (c_orderline.priceactual * 1000) / ( case when trunc(((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100), 2) = 0.00 then 1 else ((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100) end) when 'U' then c_orderline.priceactual / ( case when trunc(((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100), 2) = 0.00 then 1 else ((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100) end) end as "priceSinDto", case m_product.em_do_udtarifa when 'K' then c_orderline.priceactual * 1000 when 'U' then c_orderline.priceactual end as "price", case m_product.em_do_udtarifa when 'K' then coalesce(m_inoutline.movementqty, c_orderline.qtyordered) when 'U' then coalesce(m_inoutline.movementqty, c_orderline.qtyordered) end as "qty", case m_product.em_do_udtarifa when 'K' then ((c_orderline.priceactual * 1000) * (coalesce(m_inoutline.movementqty, c_orderline.qtyordered) / 1000)) / ( case when trunc(((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100), 2) = 0.00 then 1 else ((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100) end) when 'U' then ((c_orderline.priceactual) * coalesce(m_inoutline.movementqty, c_orderline.qtyordered)) / ( case when trunc(((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100), 2) = 0.00 then 1 else ((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100) end) end as "totalLine", case m_product.em_do_udtarifa when 'K' then ((c_orderline.priceactual * 1000) * (coalesce(m_inoutline.movementqty, c_orderline.qtyordered) / 1000)) * ((c_tax.rate / 100) + 1) when 'U' then ((c_orderline.priceactual) * coalesce(m_inoutline.movementqty, c_orderline.qtyordered)) * ((c_tax.rate / 100) + 1) end as "totalLineConIva", case m_product.em_do_udtarifa when 'K' then (c_orderline.priceactual * 166.386) * 1000 when 'U' then (c_orderline.priceactual * 166.386) end as "pricePTS", c_orderline.em_do_descuento as "dtoLine", coalesce(m_inout.c_doctype_id, ( select c_doctype_id from M_INOUT mi where mi.c_order_id = c_order.c_order_id limit 1)) as "tipoDoc", coalesce(c_doctype.name, ( select cd.name from M_INOUT mi inner JOIN c_doctype cd on cd.c_doctype_id = mi.c_doctype_id where mi.c_order_id = c_order.c_order_id limit 1)) as "NameDoc", ( select sum(m_transaction.movementqty) from m_transaction where m_transaction.m_product_id = m_product.m_product_id) as STOCK_PROD, round(c_orderline.em_do_margen, 3) as margen, c_orderline.em_pr592_line_generated_auto from c_orderline left join m_inoutline on c_orderline.c_orderline_id = m_inoutline.c_orderline_id left join m_inout on m_inoutline.m_inout_id = m_inout.m_inout_id inner join c_order on c_order.c_order_id = c_orderline.c_order_id inner join c_bpartner on coalesce(M_INOUT.C_BPARTNER_ID, c_order.C_BPARTNER_ID) = C_BPARTNER.C_BPARTNER_ID inner join c_paymentterm on c_order.c_paymentterm_id = c_paymentterm.c_paymentterm_id inner join m_product on m_product.m_product_id = c_orderline.m_product_id inner join c_uom on c_orderline.c_uom_id = c_uom.c_uom_id inner join c_tax on c_tax.c_tax_id = c_orderline.c_tax_id inner JOIN FIN_PAYMENTMETHOD ON c_order.FIN_PAYMENTMETHOD_ID = FIN_PAYMENTMETHOD.FIN_PAYMENTMETHOD_ID left JOIN c_doctype on c_doctype.c_doctype_id = m_inout.c_doctype_id where coalesce(m_inout.issotrx, c_order.issotrx) = 'Y' and c_order.invoicerule <> 'N' and coalesce(m_inout.docstatus, coalesce(( select mi.docstatus from m_inout mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1), 'VO')) != 'VO' and (c_orderline.qtyordered <> c_orderline.qtyinvoiced or (c_orderline.em_pr592_line_generated_auto = 'Y' and ( select mi.iscompletelyinvoiced from m_inout mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1) = 'N')) and (m_inoutline.c_orderline_id is not null or (c_orderline.em_pr592_line_generated_auto = 'Y' and ( select mi.iscompletelyinvoiced from m_inout mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1) = 'N')) and exists ( select 1 from m_inout mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO') and coalesce(m_inout.ad_client_id, c_order.ad_client_id) = '91B132A281B64330AF076174A673A546' and coalesce(m_inout.ad_org_id, c_order.ad_org_id) = '50D4CE8A010D45029F09C6357BE1CF04' AND coalesce(m_inout.movementdate, c_order.dateordered) >= to_date('01-01-2026', 'DD-MM-YYYY') AND coalesce(m_inout.movementdate, c_order.dateordered) >= to_date('01-01-2026', 'DD-MM-YYYY') order by coalesce(M_INOUT.AD_ORG_ID, c_order.AD_ORG_ID), coalesce(c_doctype.name, ( select cd.name from M_INOUT mi inner JOIN c_doctype cd on cd.c_doctype_id = mi.c_doctype_id where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1)) DESC, coalesce(m_inout.c_doctype_id, ( select c_doctype_id from M_INOUT mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1)), c_bpartner.value, c_order.documentno, c_orderline.line;

Date: 2026-07-15 16:31:32
Duration: 4s326ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select coalesce(m_inout.ad_org_id, c_order.ad_org_id) as ad_org_id, coalesce(M_INOUT.M_INOUT_ID, ( select M_INOUT_ID from M_INOUT mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1)) as "M_INOUT_ID", coalesce(M_INOUT.DOCUMENTNO, ( select documentno from M_INOUT mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1)) AS "AlabranNp", coalesce(M_INOUT.MOVEMENTDATE, c_order.dateordered) AS "MOVEMENTDATE", coalesce(m_inout.c_order_id, c_order.c_order_id) AS "C_ORDER_ID", c_order.documentno as "PedidoNo", c_bpartner.value as "ValueTercero", C_BPARTNER.TAXID AS "TaxTercero", C_BPARTNER.NAME AS "NameTercero", m_product.name "NameProduct", m_product.value "ValueProduct", coalesce(m_inoutline.movementqty, c_orderline.qtyordered) as movementqty, c_orderline.pricestd, c_order.grandtotal, c_orderline.description as "descLine", FIN_PAYMENTMETHOD.NAME as "FORMAPAGO", c_paymentterm.name "ConPago", c_uom.uomsymbol "Unidad", c_tax.rate "IVA", c_orderline.em_do_udtarifa "UdTarifa", c_orderline.em_do_nombreauxiliar as "nombreAux", case m_product.em_do_udtarifa when 'K' then (c_orderline.priceactual * 1000) / ( case when trunc(((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100), 2) = 0.00 then 1 else ((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100) end) when 'U' then c_orderline.priceactual / ( case when trunc(((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100), 2) = 0.00 then 1 else ((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100) end) end as "priceSinDto", case m_product.em_do_udtarifa when 'K' then c_orderline.priceactual * 1000 when 'U' then c_orderline.priceactual end as "price", case m_product.em_do_udtarifa when 'K' then coalesce(m_inoutline.movementqty, c_orderline.qtyordered) when 'U' then coalesce(m_inoutline.movementqty, c_orderline.qtyordered) end as "qty", case m_product.em_do_udtarifa when 'K' then ((c_orderline.priceactual * 1000) * (coalesce(m_inoutline.movementqty, c_orderline.qtyordered) / 1000)) / ( case when trunc(((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100), 2) = 0.00 then 1 else ((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100) end) when 'U' then ((c_orderline.priceactual) * coalesce(m_inoutline.movementqty, c_orderline.qtyordered)) / ( case when trunc(((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100), 2) = 0.00 then 1 else ((100 - coalesce(c_orderline.em_do_descuento, 0)) / 100) end) end as "totalLine", case m_product.em_do_udtarifa when 'K' then ((c_orderline.priceactual * 1000) * (coalesce(m_inoutline.movementqty, c_orderline.qtyordered) / 1000)) * ((c_tax.rate / 100) + 1) when 'U' then ((c_orderline.priceactual) * coalesce(m_inoutline.movementqty, c_orderline.qtyordered)) * ((c_tax.rate / 100) + 1) end as "totalLineConIva", case m_product.em_do_udtarifa when 'K' then (c_orderline.priceactual * 166.386) * 1000 when 'U' then (c_orderline.priceactual * 166.386) end as "pricePTS", c_orderline.em_do_descuento as "dtoLine", coalesce(m_inout.c_doctype_id, ( select c_doctype_id from M_INOUT mi where mi.c_order_id = c_order.c_order_id limit 1)) as "tipoDoc", coalesce(c_doctype.name, ( select cd.name from M_INOUT mi inner JOIN c_doctype cd on cd.c_doctype_id = mi.c_doctype_id where mi.c_order_id = c_order.c_order_id limit 1)) as "NameDoc", ( select sum(m_transaction.movementqty) from m_transaction where m_transaction.m_product_id = m_product.m_product_id) as STOCK_PROD, round(c_orderline.em_do_margen, 3) as margen, c_orderline.em_pr592_line_generated_auto from c_orderline left join m_inoutline on c_orderline.c_orderline_id = m_inoutline.c_orderline_id left join m_inout on m_inoutline.m_inout_id = m_inout.m_inout_id inner join c_order on c_order.c_order_id = c_orderline.c_order_id inner join c_bpartner on coalesce(M_INOUT.C_BPARTNER_ID, c_order.C_BPARTNER_ID) = C_BPARTNER.C_BPARTNER_ID inner join c_paymentterm on c_order.c_paymentterm_id = c_paymentterm.c_paymentterm_id inner join m_product on m_product.m_product_id = c_orderline.m_product_id inner join c_uom on c_orderline.c_uom_id = c_uom.c_uom_id inner join c_tax on c_tax.c_tax_id = c_orderline.c_tax_id inner JOIN FIN_PAYMENTMETHOD ON c_order.FIN_PAYMENTMETHOD_ID = FIN_PAYMENTMETHOD.FIN_PAYMENTMETHOD_ID left JOIN c_doctype on c_doctype.c_doctype_id = m_inout.c_doctype_id where coalesce(m_inout.issotrx, c_order.issotrx) = 'Y' and c_order.invoicerule <> 'N' and coalesce(m_inout.docstatus, coalesce(( select mi.docstatus from m_inout mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1), 'VO')) != 'VO' and (c_orderline.qtyordered <> c_orderline.qtyinvoiced or (c_orderline.em_pr592_line_generated_auto = 'Y' and ( select mi.iscompletelyinvoiced from m_inout mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1) = 'N')) and (m_inoutline.c_orderline_id is not null or (c_orderline.em_pr592_line_generated_auto = 'Y' and ( select mi.iscompletelyinvoiced from m_inout mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1) = 'N')) and exists ( select 1 from m_inout mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO') and coalesce(m_inout.ad_client_id, c_order.ad_client_id) = $1 and coalesce(m_inout.ad_org_id, c_order.ad_org_id) = '50D4CE8A010D45029F09C6357BE1CF04' AND coalesce(m_inout.movementdate, c_order.dateordered) >= to_date('01-01-2026', 'DD-MM-YYYY') AND coalesce(m_inout.movementdate, c_order.dateordered) >= to_date('01-01-2026', 'DD-MM-YYYY') order by coalesce(M_INOUT.AD_ORG_ID, c_order.AD_ORG_ID), coalesce(c_doctype.name, ( select cd.name from M_INOUT mi inner JOIN c_doctype cd on cd.c_doctype_id = mi.c_doctype_id where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1)) DESC, coalesce(m_inout.c_doctype_id, ( select c_doctype_id from M_INOUT mi where mi.c_order_id = c_order.c_order_id and mi.docstatus <> 'VO' limit 1)), c_bpartner.value, c_order.documentno, c_orderline.line;

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

x Hide