SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, C_CURRENCY_SYMBOL ($1, 0, 'Y') AS CONVSYM, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_ISOSYM ($2) AS CONVISOSYM FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, SUM (LINENETAMT) AS AMOUNT, SUM (MOVEMENTQTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (MOVEMENTQTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, $3, to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('M_Product'), to_char (M_PRODUCT.M_PRODUCT_ID), to_char ('es_ES')) || CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char (' (' || uomsymbol || ')') END) AS NIVEL1, to_char (AD_ORG.NAME) AS NIVEL2, to_char (M_INOUT.DOCUMENTNO) AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, COALESCE (M_INOUTLINE.MOVEMENTQTY * C_ORDERLINE.PRICEACTUAL, 0) AS LINENETAMT, M_INOUTLINE.MOVEMENTQTY, M_INOUTLINE.MOVEMENTQTY * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS MOVEMENTQTYREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, C_ORDERLINE.C_CURRENCY_ID AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID FROM M_INOUTLINE LEFT JOIN C_ORDERLINE ON M_INOUTLINE.C_ORDERLINE_ID = C_ORDERLINE.C_ORDERLINE_ID LEFT JOIN C_ORDER ON C_ORDERLINE.C_ORDER_ID = C_ORDER.C_ORDER_ID, M_INOUT LEFT JOIN AD_USER ON M_INOUT.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE M_INOUT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND M_INOUT.M_INOUT_ID = M_INOUTLINE.M_INOUT_ID AND M_INOUTLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND M_INOUT.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND M_INOUTLINE.C_UOM_ID = C_UOM.C_UOM_ID AND M_INOUT.AD_ORG_ID = AD_ORG.AD_ORG_ID AND M_INOUT.ISSOTRX = 'Y' AND M_INOUT.PROCESSED = 'Y' AND 0 = 0 AND M_INOUT.AD_ORG_ID IN ('CDCEFC97D42749ABA78BA3EB973BAC89') AND M_INOUT.AD_CLIENT_ID IN ('0', '9CE5D25B1359417991AD7697D6F09896') AND 1 = 1 AND M_INOUT.MOVEMENTDATE >= to_date ($4) AND M_INOUT.MOVEMENTDATE < to_date ($5) AND M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID = $6) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9 ORDER BY NIVEL1, NIVEL2, NIVEL3;

Date: 2026-07-17 13:42:23
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT order0_.C_Order_ID AS C_Order_1_276_, order0_.AD_Client_ID AS AD_Clien2_276_, order0_.AD_Org_ID AS AD_Org_I3_276_, order0_.IsActive AS IsActive4_276_, order0_.Created AS Created5_276_, order0_.CreatedBy AS CreatedB6_276_, order0_.Updated AS Updated7_276_, order0_.UpdatedBy AS UpdatedB8_276_, order0_.IsSOTrx AS IsSOTrx9_276_, order0_.DocumentNo AS Documen10_276_, order0_.DocStatus AS DocStat11_276_, order0_.DocAction AS DocActi12_276_, order0_.Processing AS Process13_276_, order0_.Processed AS Process14_276_, order0_.C_DocType_ID AS C_DocTy15_276_, order0_.C_DocTypeTarget_ID AS C_DocTy16_276_, order0_.Description AS Descrip17_276_, order0_.IsDelivered AS IsDeliv18_276_, order0_.IsInvoiced AS IsInvoi19_276_, order0_.IsPrinted AS IsPrint20_276_, order0_.IsSelected AS IsSelec21_276_, order0_.SalesRep_ID AS SalesRe22_276_, order0_.DateOrdered AS DateOrd23_276_, order0_.DatePromised AS DatePro24_276_, order0_.DatePrinted AS DatePri25_276_, order0_.DateAcct AS DateAcc26_276_, order0_.C_BPartner_ID AS C_BPart27_276_, order0_.BillTo_ID AS BillTo_28_276_, order0_.C_BPartner_Location_ID AS C_BPart29_276_, order0_.POReference AS PORefer30_276_, order0_.IsDiscountPrinted AS IsDisco31_276_, order0_.C_Currency_ID AS C_Curre32_276_, order0_.PaymentRule AS Payment33_276_, order0_.C_PaymentTerm_ID AS C_Payme34_276_, order0_.InvoiceRule AS Invoice35_276_, order0_.DeliveryRule AS Deliver36_276_, order0_.FreightCostRule AS Freight37_276_, order0_.FreightAmt AS Freight38_276_, order0_.DeliveryViaRule AS Deliver39_276_, order0_.M_Shipper_ID AS M_Shipp40_276_, order0_.C_Charge_ID AS C_Charg41_276_, order0_.ChargeAmt AS ChargeA42_276_, order0_.PriorityRule AS Priorit43_276_, order0_.TotalLines AS TotalLi44_276_, order0_.GrandTotal AS GrandTo45_276_, order0_.M_Warehouse_ID AS M_Wareh46_276_, order0_.M_PriceList_ID AS M_Price47_276_, order0_.IsTaxIncluded AS IsTaxIn48_276_, order0_.C_Campaign_ID AS C_Campa49_276_, order0_.C_Project_ID AS C_Proje50_276_, order0_.C_Activity_ID AS C_Activ51_276_, order0_.Posted AS Posted52_276_, order0_.AD_User_ID AS AD_User53_276_, order0_.CopyFrom AS CopyFro54_276_, order0_.DropShip_BPartner_ID AS DropShi55_276_, order0_.DropShip_Location_ID AS DropShi56_276_, order0_.DropShip_User_ID AS DropShi57_276_, order0_.IsSelfService AS IsSelfS58_276_, order0_.AD_OrgTrx_ID AS AD_OrgT59_276_, order0_.User1_ID AS User60_276_, order0_.User2_ID AS User61_276_, order0_.Deliverynotes AS Deliver62_276_, order0_.C_Incoterms_ID AS C_Incot63_276_, order0_.Incotermsdescription AS Incoter64_276_, order0_.Generatetemplate AS Generat65_276_, order0_.Delivery_Location_ID AS Deliver66_276_, order0_.CopyFromPO AS CopyFro67_276_, order0_.FIN_Paymentmethod_ID AS FIN_Pay68_276_, order0_.FIN_Payment_Priority_ID AS FIN_Pay69_276_, order0_.RM_PickFromShipment AS RM_Pick70_276_, order0_.RM_ReceiveMaterials AS RM_Rece71_276_, order0_.EM_Obcma_C_Poc_Email_ID AS EM_Obcm72_276_, order0_.RM_CreateInvoice AS RM_Crea73_276_, order0_.C_Return_Reason_ID AS C_Retur74_276_, order0_.RM_AddOrphanLine AS RM_AddO75_276_, order0_.A_Asset_ID AS A_Asset76_276_, order0_.Calculate_Promotions AS Calcula77_276_, order0_.C_Costcenter_ID AS C_Costc78_276_, order0_.Convertquotation AS Convert79_276_, order0_.C_Reject_Reason_ID AS C_Rejec80_276_, order0_.validuntil AS validun81_276_, order0_.Quotation_ID AS Quotati82_276_, order0_.SO_Res_Status AS SO_Res_83_276_, order0_.Create_POLines AS Create_84_276_, order0_.EM_Obdisc_Addpack AS EM_Obdi85_276_, order0_.Iscashvat AS Iscashv86_276_, order0_.EM_OBMFM_Selectfreight AS EM_OBMF87_276_, order0_.EM_OBMFM_Delivery_Period_ID AS EM_OBMF88_276_, order0_.RM_Pickfromreceipt AS RM_Pick89_276_, order0_.Cancelandreplace AS Cancela90_276_, order0_.EM_Advcrm_Newactivity AS EM_Advc91_276_, order0_.EM_APRM_AddPayment AS EM_APRM92_276_, order0_.EM_OBMFM_Delivery_Charges AS EM_OBMF93_276_, order0_.EM_OBMFM_Freight_ID AS EM_OBMF94_276_, order0_.EM_Obwpl_Generatepicking AS EM_Obwp95_276_, order0_.EM_Advcrm_Opportunity_ID AS EM_Advc96_276_, order0_.EM_OBMFM_Weight AS EM_OBMF97_276_, order0_.EM_Obwpl_Isinpickinglist AS EM_Obwp98_276_, order0_.EM_Rcinv_Contractdate AS EM_Rcin99_276_, order0_.EM_Obwpl_Readypl AS EM_Obw100_276_, order0_.EM_Rcinv_Initialdate AS EM_Rci101_276_, order0_.EM_Rcinv_Enddate AS EM_Rci102_276_, order0_.EM_Sgpcrm_Securitygroups_ID AS EM_Sgp103_276_, order0_.EM_OBMFM_Weight_Uom_ID AS EM_OBM104_276_, order0_.EM_Rcinv_Frequency AS EM_Rci105_276_, order0_.EM_OBMFM_Set_Weight AS EM_OBM106_276_, order0_.EM_Rcinv_Renewautomatically AS EM_Rci107_276_, order0_.EM_Aeatsii_Fecha_Operacion AS EM_Aea108_276_, order0_.EM_Ml_Select_Product AS EM_Ml_109_276_, order0_.EM_Rcinv_Renovationtimes AS EM_Rci110_276_, order0_.Confirmcancelandreplace AS Confir111_276_, order0_.EM_Aeatsii_Descripcion_Sii AS EM_Aea112_276_, order0_.EM_Obpos_Applications_ID AS EM_Obp113_276_, order0_.EM_Rcinv_Freqrenovationtime AS EM_Rci114_276_, order0_.EM_Obpos_Sendemail AS EM_Obp115_276_, order0_.EM_Rcinv_Ordercontract_ID AS EM_Rci116_276_, order0_.EM_Obpos_Email_Status AS EM_Obp117_276_, order0_.EM_Rcinv_Freqtime AS EM_Rci118_276_, order0_.Cancelledorder_id AS Cancel119_276_, order0_.EM_Obpos_App_Cashup_ID AS EM_Obp120_276_, order0_.EM_Obpos_Createdabsolute AS EM_Obp121_276_, order0_.Replacedorder_id AS Replac122_276_, order0_.EM_OBPOS_NotInvoiceOnCashUp AS EM_OBP123_276_, order0_.EM_Obpos_Rejected_Quotat_ID AS EM_Obp124_276_, order0_.EM_Obpos_Isdeleted AS EM_Obp125_276_, order0_.Iscancelled AS Iscanc126_276_, order0_.EM_Obpos_Islayaway AS EM_Obp127_276_, order0_.EM_Obpos_Prepaymentamt AS EM_Obp128_276_, order0_.Replacementorder_ID AS Replac129_276_, order0_.EM_Obpos_Prepaymentlimitamt AS EM_Obp130_276_, order0_.EM_Obpos_Prepaymentlaylimitamt AS EM_Obp131_276_, order0_.EM_Obpos_Rounding_Amount AS EM_Obp132_276_, order0_.BPartner_ExtRef AS BPartn133_276_, order0_.EM_Obpos_Sequencename AS EM_Obp134_276_, order0_.EM_Prqc_Clauses_Selector AS EM_Prq135_276_, order0_.EM_Obpos_Sequencenumber AS EM_Obp136_276_, order0_.EM_Rcinv_Cancelcontract AS EM_Rci137_276_, order0_.EM_Rcinv_Cancelleddate AS EM_Rci138_276_, order0_.EM_Rcinv_Iscancelled AS EM_Rci139_276_, order0_.EM_Psat_Activity_ID AS EM_Psa140_276_, order0_.EM_OBSMAIL_EmailAddress AS EM_OBS141_276_, order0_.EM_Prouti_Order_Stock AS EM_Pro142_276_, order0_.EM_Prouti_Pregenerate_Minout AS EM_Pro143_276_, order0_.EM_Prouti_Sotopo AS EM_Pro144_276_, order0_.EM_Prouti_Generate_Pick_Inv AS EM_Pro145_276_, order0_.EM_Pricm_Order_ID AS EM_Pri146_276_, order0_.EM_Prouti_Order_ID AS EM_Pro147_276_, order0_.EM_Prouti_Grandtotalinitial AS EM_Pro148_276_, order0_.EM_Prouti_Dateclosed AS EM_Pro149_276_, order0_.EM_Prouti_Totallinesinitial AS EM_Pro150_276_, order0_.EM_Prouti_Changebpartner AS EM_Pro151_276_, order0_.EM_Prouti_Recalculate_Price AS EM_Pro152_276_, order0_.em_prqr_execute AS em_prq153_276_, order0_.EM_Prouti_Pricecalculatetdate AS EM_Pro154_276_, order0_.EM_Prqr_Execute_Purchase AS EM_Prq155_276_, order0_.EM_Prouti_Reactiveorder AS EM_Pro156_276_, order0_.EM_Prqr_Return_Select_Prod AS EM_Prq157_276_, order0_.EM_Prouti_Totalizations AS EM_Pro158_276_, order0_.em_prouti_Invoiced AS em_pro159_276_, order0_.em_prouti_Received AS em_pro160_276_, order0_.em_prouti_initial_received AS em_pro161_276_, order0_.EM_Prouti_Status_Of_Review AS EM_Pro162_276_, order0_.EM_Prouti_Validate_Order AS EM_Pro163_276_, order0_.EM_Prouti_Start_Review AS EM_Pro164_276_, order0_.EM_Ml_Select_Product_Byattrib AS EM_Ml_165_276_, order0_.EM_Prres_Reservation_ID AS EM_Prr166_276_, order0_.EM_Prres_Responsible_ID AS EM_Prr167_276_, order0_.EM_Prres_Diners AS EM_Prr168_276_, order0_.EM_Prres_Sended AS EM_Prr169_276_, order0_.EM_Prres_Printed AS EM_Prr170_276_, order0_.EM_Prouti_Initial_Bp_ID AS EM_Pro171_276_, order0_.EM_Prouti_Addlines_Btn AS EM_Pro172_276_, order0_.EM_Prtoma_Tomaticket_ID AS EM_Prt173_276_, order0_.EM_Cactl_IsCopy AS EM_Cac174_276_, order0_.EM_Prtoma_Jsonorder AS EM_Prt175_276_, order0_.EM_Prres_Paid_On_Credit AS EM_Prr176_276_, order0_.EM_Prtoma_Grossamount AS EM_Prt177_276_, order0_.EM_Cactl_Internal_Notes_Group AS EM_Cac178_276_, order0_.EM_Prouti_Changebpartner_Bgt AS EM_Pro179_276_, order0_.EM_Prrgr_Locator_ID AS EM_Prr180_276_, order0_.EM_Paytef_Transactionreference AS EM_Pay181_276_, order0_.EM_Cactl_Indirect_Cost_ID AS EM_Cac182_276_, order0_.EM_Cactl_Calculate_Cost AS EM_Cac183_276_, order0_.EM_Cactl_Totalcost AS EM_Cac184_276_, order0_.EM_Cactl_Forceselectedproject AS EM_Cac185_276_, order0_.EM_Cactl_Verified_Return AS EM_Cac186_276_, order0_.EM_Cactl_Duplicate_Budget AS EM_Cac187_276_, order0_.EM_Prres_Orig_Order_ID AS EM_Prr188_276_, order0_.EM_Prcpr_Is_Cloned AS EM_Prc189_276_, order0_.EM_Prouti_Select_Soline AS EM_Pro190_276_, order0_.EM_Prouti_Return_Quantity AS EM_Pro191_276_, order0_.EM_Prqr_Executecredit AS EM_Prq192_276_, order0_.Em_Prqr_Credit_Purchase_ID AS Em_Prq193_276_ FROM C_Order order0_ WHERE (upper ((order0_.DocumentNo || ' - ' || COALESCE (to_char (order0_.DateOrdered), '') || ' - ' || COALESCE (to_char (order0_.GrandTotal), ''))) LIKE upper ($1) ESCAPE '|') AND (EXISTS ( SELECT 1 FROM M_InOut materialmg1_ INNER JOIN C_Order order2_ ON materialmg1_.C_Order_ID = order2_.C_Order_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 order2_.C_Order_ID = order0_.C_Order_ID AND (materialmg1_.AD_Org_ID IN ('BDE84FCE50FF46FBBFAC648A621443DF', 'D575B67D82034C269C7E0FAF196D90E7', 'F7430A5D620748B19BE7915CDDDA9BE7', '09AA2CDD5352474690D9BB84C869850A', '86EB5CCF7EFE4EACAC3F2E025C137019', '6FA42D7B78034BD8994E9BA7F2CA2281', '1984C825F5534428BD6DDB0CA6D5A440', '5E311B81CDF64243B4C16520C49F3B59', 'D629402D7AE24904A093B7DC01A5CCA5', 'E007B9685155401596452F7B6CD0A6B8', '117C4CA3249B4C0993D36BA80F450C77', 'F89A6E1DA44F40868BF983D4C2384DA6', '2C9FE48909B54B599491D9F69A70A307', 'C2B9461D37104A31B9FD2C1D5E0D381E', '7DBD8F71A3C640028913A30FBCCDF7A7', '432480F1E32D48A19D89CD9A28D7DC1F', 'CDCEFC97D42749ABA78BA3EB973BAC89', 'FCD700C048BB487AA26E639649EB5A96', 'D675D150EA7D4218AF15CF6221A15349', 'DD5A08978B9D43E0ABFAD0B01A9168B0', '9FF601A70F8443138C0EF03BDFDF29F0', '25548EE38FDF4B068F7CFA9FA70FA4FF', '891AF965E0874B4F911504C515619C58', 'CF85EFF5B85A46679AA07AC10CA26CEA', '900D5488BFB64AD4BE463A30ECEDD0FF', '139ED2D4B4CE4901996E0B72E0F87F6C', '0', '4A09EF8E85474DAFA7C132836C07FFF1', '1C36F5B48E224E4D9C82D6A8202996E8', '71ED1EFD88354240BB0412C35E03BF1C', '88CD22344C324943BF5200E06A942459', 'F22E1A745C4C42BCA2386BF8DC013634', '9F797A8A00FC467F90A60E9E62873D59', 'F660F82B9E8C420CAB4FDD68F6DEA416', 'D19EF13F20CD471BB6F6664909C352AF', 'F9B7F11E4E9C43308578C4D73D2B7E00', '658F3A7A05DF4261A63E57B277843BE9', '5D0AF8482E7F489EB482A8B80E7D3F38')) AND (materialmg1_.AD_Client_ID IN ('9CE5D25B1359417991AD7697D6F09896', '0')))) ORDER BY order0_.DocumentNo, order0_.DateOrdered, order0_.GrandTotal LIMIT $2;

Date: 2026-07-17 11:39:58
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

ad_column_identifier_std ('fin_financial_account', fa.fin_financial_account_id) AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'La cuenta financiera ' || fa.name || ' descuadra ' || fa.currentbalance || ' / ' || (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) || 'DIF: ' || fa.currentbalance - (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AS description, 'Y' AS isActive, 0 AS ad_org_id, fa.ad_client_id AS ad_client_id, now () AS created, 0 AS createdBy, now () AS updated, 0 AS updatedBy FROM fin_financial_account fa WHERE fa.currentbalance <> fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) 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-07-17 08:02:01
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, C_CURRENCY_SYMBOL ($1, 0, 'Y') AS CONVSYM, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_ISOSYM ($2) AS CONVISOSYM FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, SUM (LINENETAMT) AS AMOUNT, SUM (MOVEMENTQTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (MOVEMENTQTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, $3, to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('M_Product'), to_char (M_PRODUCT.M_PRODUCT_ID), to_char ('es_ES')) || CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char (' (' || uomsymbol || ')') END) AS NIVEL1, to_char (AD_ORG.NAME) AS NIVEL2, to_char (M_INOUT.DOCUMENTNO) AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, COALESCE (M_INOUTLINE.MOVEMENTQTY * C_ORDERLINE.PRICEACTUAL, 0) AS LINENETAMT, M_INOUTLINE.MOVEMENTQTY, M_INOUTLINE.MOVEMENTQTY * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS MOVEMENTQTYREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, C_ORDERLINE.C_CURRENCY_ID AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID FROM M_INOUTLINE LEFT JOIN C_ORDERLINE ON M_INOUTLINE.C_ORDERLINE_ID = C_ORDERLINE.C_ORDERLINE_ID LEFT JOIN C_ORDER ON C_ORDERLINE.C_ORDER_ID = C_ORDER.C_ORDER_ID, M_INOUT LEFT JOIN AD_USER ON M_INOUT.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE M_INOUT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND M_INOUT.M_INOUT_ID = M_INOUTLINE.M_INOUT_ID AND M_INOUTLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND M_INOUT.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND M_INOUTLINE.C_UOM_ID = C_UOM.C_UOM_ID AND M_INOUT.AD_ORG_ID = AD_ORG.AD_ORG_ID AND M_INOUT.ISSOTRX = 'Y' AND M_INOUT.PROCESSED = 'Y' AND 0 = 0 AND M_INOUT.AD_ORG_ID IN ('CDCEFC97D42749ABA78BA3EB973BAC89') AND M_INOUT.AD_CLIENT_ID IN ('0', '9CE5D25B1359417991AD7697D6F09896') AND 1 = 1 AND M_INOUT.MOVEMENTDATE >= to_date ($4) AND M_INOUT.MOVEMENTDATE < to_date ($5) AND C_BP_GROUP.C_BP_GROUP_ID = $6 AND C_BPARTNER.C_BPARTNER_ID IN ('26A7C516D8954CBBA11B4FFBDF4BA332') AND M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID = $7) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9 ORDER BY NIVEL1, NIVEL2, NIVEL3;

Date: 2026-07-17 13:46:57
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, SUM (AMOUNT) AS AMOUNT, SUM (QTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (AMOUNTREF) AS AMOUNTREF, SUM (QTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, SUM (CONVAMOUNT) AS CONVAMOUNT, C_CURRENCY_SYMBOL ($1, 0, 'Y') AS CONVSYM, SUM (CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_ISOSYM ($2) AS CONVISOSYM FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, SUM (LINENETAMT) AS AMOUNT, SUM (MOVEMENTQTY) AS QTY, SUM (WEIGHT) AS WEIGHT, SUM (LINENETREF) AS AMOUNTREF, SUM (MOVEMENTQTYREF) AS QTYREF, SUM (WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM (LINENETAMT), TRCURRENCYID, $3, to_date (TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, 0 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID FROM ( SELECT to_char (AD_COLUMN_IDENTIFIER (to_char ('M_Product'), to_char (M_PRODUCT.M_PRODUCT_ID), to_char ('es_ES')) || CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char (' (' || uomsymbol || ')') END) AS NIVEL1, to_char (AD_ORG.NAME) AS NIVEL2, to_char ('') AS NIVEL3, to_char ('') AS NIVEL4, to_char ('') AS NIVEL5, to_char ('') AS NIVEL6, to_char ('') AS NIVEL7, to_char ('') AS NIVEL8, to_char ('') AS NIVEL9, COALESCE (M_INOUTLINE.MOVEMENTQTY * C_ORDERLINE.PRICEACTUAL, 0) AS LINENETAMT, M_INOUTLINE.MOVEMENTQTY, M_INOUTLINE.MOVEMENTQTY * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS MOVEMENTQTYREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL, C_ORDERLINE.C_CURRENCY_ID AS TRCURRENCYID, to_date (COALESCE (C_ORDER.DATEORDERED, now ())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID FROM M_INOUTLINE LEFT JOIN C_ORDERLINE ON M_INOUTLINE.C_ORDERLINE_ID = C_ORDERLINE.C_ORDERLINE_ID LEFT JOIN C_ORDER ON C_ORDERLINE.C_ORDER_ID = C_ORDER.C_ORDER_ID, M_INOUT LEFT JOIN AD_USER ON M_INOUT.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER LEFT JOIN C_BPARTNER CB ON C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE M_INOUT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND M_INOUT.M_INOUT_ID = M_INOUTLINE.M_INOUT_ID AND M_INOUTLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND M_INOUT.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND M_INOUTLINE.C_UOM_ID = C_UOM.C_UOM_ID AND M_INOUT.AD_ORG_ID = AD_ORG.AD_ORG_ID AND M_INOUT.ISSOTRX = 'Y' AND M_INOUT.PROCESSED = 'Y' AND 0 = 0 AND M_INOUT.AD_ORG_ID IN ('CDCEFC97D42749ABA78BA3EB973BAC89') AND M_INOUT.AD_CLIENT_ID IN ('0', '9CE5D25B1359417991AD7697D6F09896') AND 1 = 1 AND M_INOUT.MOVEMENTDATE >= to_date ($4) AND M_INOUT.MOVEMENTDATE < to_date ($5) AND M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID = $6) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9 ORDER BY NIVEL1, NIVEL2;

Date: 2026-07-17 13:34:05
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

INSERT INTO C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, Description, IsPrinted, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, POReference, IsDiscountPrinted, C_Currency_ID, C_PaymentTerm_ID, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, Ispaid, EM_Einv_Generated, Totalpaid, EM_Einv_Sent, OutstandingAmt, DaysTillDue, DueAmt, FIN_Paymentmethod_ID, Calculate_Promotions, EM_APRM_Addpayment, Iscashvat, EM_APRM_Processinvoice, Prepaymentamt, Createfromorders, Createfrominouts, EM_Advcrm_Newactivity, Paidamtatinvoicing, EM_Obpos_Rounding_Amount, EM_Aeatsii_Send, EM_Aeatsii_Issent, EM_Aeatsii_Fecha_Operacion, EM_Prouti_Recalculate_Price, EM_Aeatsii_Clave_Tipo_Fc, EM_Ml_Select_Product, EM_Aeatsii_Error_Registral, EM_Aeatsii_Modif, EM_Aeatsii_Modified, EM_Aeatsii_Fecha_Reg_Cont, EM_Aeatsii_Dup, EM_Aeatsii_Unsubscribe, EM_Aeatsii_Multi_Dua, EM_Aeatsii_Autofactura, EM_Aeatsii_Isauthorization, EM_Priuti_Createpurchinv, EM_Priuti_Generated, EM_Prges_Expediente_ID, EM_Prges_Annotation_ID, EM_Prges_Record_Number, EM_Priuti_Status_Of_Review, EM_Prges_Grantotal, EM_Priuti_Validate, EM_Priuti_Start_Review, EM_Prges_Poreference, em_cactl_createfromship, C_Invoice_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);

Date: 2026-07-17 08:30:24
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

INSERT INTO M_Internal_ConsumptionLine (AD_Client_ID, AD_Org_ID, IsActive, Created, Createdby, Updated, Updatedby, M_Internal_Consumption_ID, M_Locator_ID, M_Product_ID, Line, MovementQty, C_UOM_ID, M_Internal_Consumptionline_ID) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14);

Date: 2026-07-17 09:31:58
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

UPDATE C_Order SET Updated = $1, UpdatedBy = $2, BillTo_ID = $3, EM_Cactl_IsCopy = $4 WHERE C_Order_ID = $5;

Date: 2026-07-17 09:06:46
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT count (1) FROM prpass_pass_inst ppi WHERE created < '2026-01-01' ORDER BY created ASC;

Date: 2026-07-17 08:06:42
Duration: 0ms
Database: openbravo
User: tad
Remote: ::1
Application: DBeaver 24.2.1 - SQLEditor 

x Hide

SET CurrentNext = CurrentNext + IncrementNo, Updated = to_date (now ()) WHERE Name = p_SequenceName AND ad_client_id = p_ad_client_id " PL/pgSQL function ad_sequence_doc(character varying,character varying,character) line 34 at SQL statement SQL statement " SELECT * FROM Ad_Sequence_Doc ('DocumentNo_M_InOut', Cur_Order.AD_Client_ID, 'Y') " PL/pgSQL function m_inout_create(character varying,character varying,character varying,character,character varying) line 847 at SQL statement SQL statement " SELECT * FROM M_INOUT_CREATE ($1, $3, $4, $5, NULL) " PL/pgSQL function m_inout_create(character varying,character varying,character varying,character) line 3 at SQL statement SQL statement " SELECT * FROM M_Inout_Create (NULL, v_Record_ID, NULL, 'Y') " PL/pgSQL function c_order_post1(character varying,character varying,character varying) line 1599 at SQL statement SQL statement " SELECT C_ORDER_POST1 ($1, $2, 'Y') " PL/pgSQL function c_order_post1(character varying,character varying) line 3 at PERFORM SQL statement " SELECT C_ORDER_POST1 (p_PInstance_ID, NULL) PL / pgSQL FUNCTION c_order_post (CHARACTER VARYING) line 17 AT PERFORM;

Date: 2026-07-17 09:32:06
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide