• Este debate está vacío.
Viendo 7 entradas - de la 1 a la 7 (de un total de 7)
  • Autor
    Entradas
  • #32346
    Ariel Vechetti
    Participante

    Hola Gente, esttoy intentando cerrar una factura cliente y me salta con un error que dice perdio cerrado. Ya rebice el calendario, habilite el año y los peridos correpodiente pero todavia no tengo solucion. Adjunto log.


    11:10:27.028 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= UPDATE C_Invoice SET ApplyPercepcion = ? , C_DocType_ID = ? , C_Letra_Comprobante_ID = ? , DocAction = ? , DocStatus = ? , DocumentNo = ? , Invoice_Adress = ? , NombreCli = ? , NumeroComprobante = ? , NumeroDeDocumento = ? , PuntoDeVenta = ? , Updated = ? , UpdatedBy = ? WHERE C_Invoice_ID=? [63]
    11:10:27.028 CPreparedStatement.: estamos en trx!=null [63]
    11:10:27.028 M_Table.getPOclass: en getPoClass con className= org.libertya.locale.ar.model.MInvoice [63]
    11:10:27.028 M_Table.getPOclass: en getPoClass con className= openXpertya.model.X_C_Invoice [63]
    11:10:27.028 M_Table.getPOclass: en getPoClass con className= org.openXpertya.model.X_C_Invoice [63]
    11:10:27.028 M_Table.getPOclass: Found:–> org.openXpertya.model.X_C_Invoice [63]
    11:10:27.028 CacheMgt.reset: (all) – CCache[C_Invoice,Exp=2, #0] [63]
    11:10:27.028 CacheMgt.reset: C_Invoice: #1 (0) [63]
    11:10:27.028 Trx.rollback: **** WF_1366035568374 [63]
    11:10:27.028 Trx.close: WF_1366035568374 [63]
    ===========> MWFActivity.run: run [63]
    java.lang.Exception: @PeriodClosed@
    at org.openXpertya.wf.MWFActivity.performWork(MWFActivity.java:1045)
    at org.openXpertya.wf.MWFActivity.run(MWFActivity.java:901)
    at java.lang.Thread.run(Thread.java:662)

    Servidor = localhost : 1099 (21-01-2013)
    Tunnel=false, Objects=false, Process=false
    Base de datos = NO017 : 5432 / guenoa
    Esquema = libertya
    Usuario = AdminLibertya
    Perfil = Ventas
    Compañía = Cooperativa de Trabajo Guenoa Ltda
    Organización = Oficina Central
    Fecha = 2013-04-15 00:00:00
    Impresora = CutePDF Writer
    Implementation-Vendor = SERVICIOS_DIGITALES
    Implementation-Title = CCTools Libertya
    Implementation-Version = Libertya 20130124-0921
    Specification-Vendor = (C) 2005-2006 FUNDESLE.
    Specification-Title = Herramientas de Cliente oxp
    Implementation-URL = http://www.openxpertya.org
    Specification-Version = Libertya
    OXPHome = XP
    Language=[Español (Argentina),Locale=es_AR,AD_Language=es_AR,DatePattern=DD.MM.YYYY,DecimalPoint=false]
    MClient[1010016-Guenoa]
    Documentos Multi-idioma = false
    BaseLanguage = false/false
    PDF License=true
    Java HotSpot(TM) 64-Bit Server VM 20.6-b01
    Windows 7 6.1 Service Pack 1
    === Environment === 403368704
    Libertya (r) Versión 13.01_21-01-2013 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 13.01 20130414-2142 – ${env.CONSULTORA_OXP}
    NO017/10.0.0.102
    CConnection[name=localhost{NO017-guenoa-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=NO017,DBport=5432,DBname=guenoa,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=libertya]
    Database=PostgreSQL – 9.1.2 – Driver =PostgreSQL Native Driver – PostgreSQL 9.0 JDBC4 (build 801) – via DataSource
    DB_PostgreSQL[jdbc:postgresql://NO017:5432/guenoa?encoding=UTF-8]
    AppsServerOK=true, DatabaseOK=true

    === Context ===
    #AD_Client_ID == 1010016
    #AD_Client_Name == Cooperativa de Trabajo Guenoa Ltda
    #AD_Language == es_AR
    #AD_Org_ID == 1010053
    #AD_Org_Name == Oficina Central
    #AD_PrintColor_ID == 100
    #AD_PrintFont_ID == 130
    #AD_PrintPaper_ID == 103
    #AD_PrintTableFormat_ID == 1000006
    #AD_Role_ID == 1010071
    #AD_Role_Name == Ventas
    #AD_Session_ID == 1028282
    #AD_User_ID == 1010717
    #AD_User_Name == AdminLibertya
    #C_BP_Group_ID == 1010045
    #C_CashBook_ID == 1010024
    #C_ConversionType_ID == 114
    #C_Country_ID == 119
    #C_Letra_Comprobante_ID == 1010039
    #C_PaymentTerm_ID == 1010083
    #C_Region_ID == 1000027
    #C_TaxCategory_ID == 1010047
    #C_Tax_ID == 1010084
    #C_UOM_ID == 1000000
    #CheckCuitControl == Y
    #Date == 2013-04-15 00:00:00
    #GL_Category_ID == 1010098
    #IsPOSJournalActive == N
    #M_Locator_ID == 1010278
    #M_PriceList_ID == 1010597
    #M_Product_Category_ID == 1010146
    #M_Warehouse_ID == 1010048
    #POSJournalSupervisor == Y
    #PasswordExpirationActive == N
    #PrintPreview == N
    #Printer == CutePDF Writer
    #SalesRep_ID == 1010717
    #ShowAcct == N
    #ShowAdvanced == Y
    #ShowTrl == Y
    #StdPrecision == 2
    #UniqueKeyActive == N
    #User_Level == CO
    #User_Org == 0,1010053
    #YYYY == Y
    $C_AcctSchema_ID == 1010016
    $C_Currency_ID == 118
    $Element_AC == Y
    $Element_BP == Y
    $Element_MC == Y
    $Element_OO == Y
    $Element_PJ == Y
    $Element_PR == Y
    $Element_SR == Y
    $HasAlias == Y
    0|WindowName == Menú
    1111|1003178|C_Letra_Comprobante.C_Letra_Comprobante_ID == SELECT C_Letra_Comprobante.C_Letra_Comprobante_ID,NULL,C_Letra_Comprobante.Letra,C_Letra_Comprobante.IsActive FROM C_Letra_Comprobante WHERE C_Letra_Comprobante.AD_Client_ID IN(0,1010016) AND C_Letra_Comprobante.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|1003185|C_Region.C_Region_ID == SELECT C_Region.C_Region_ID,NULL,C_Region.Name,C_Region.IsActive FROM C_Region WHERE C_Region.AD_Client_ID IN(0,1010016) AND C_Region.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|1014207|C_Project.C_Project_ID == SELECT C_Project.C_Project_ID,NULL,C_Project.Value ||’_’|| C_Project.Name,C_Project.IsActive FROM C_Project WHERE C_Project.AD_Client_ID IN(0,1010016) AND C_Project.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|1014896|C_POSJournal.C_POSJournal_ID == SELECT C_POSJournal.C_POSJournal_ID,NULL,(SELECT C_POS.Name FROM C_POS WHERE C_POSJournal.C_POS_ID=C_POS.C_POS_ID) ||’_’|| TO_CHAR (C_POSJournal.DateTrx ,’DD/MM/YYYY’) ||’_’|| (SELECT AD_User.Name FROM AD_User WHERE C_POSJournal.AD_User_ID=AD_User.AD_User_ID),C_POSJournal.IsActive FROM C_POSJournal WHERE C_POSJournal.DocStatus IN (‘IP’,’CO’) AND C_POSJournal.AD_Client_ID IN(0,1010016) AND C_POSJournal.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|1015629|C_POSPaymentMedium.C_POSPaymentMedium_ID == SELECT C_POSPaymentMedium.C_POSPaymentMedium_ID,NULL,C_POSPaymentMedium.Name,C_POSPaymentMedium.IsActive FROM C_POSPaymentMedium WHERE C_POSPaymentMedium.tendertype = ‘CA’ AND ‘2013-04-15 00:00:00’::date between C_POSPaymentMedium.datefrom AND C_POSPaymentMedium.dateto AND C_POSPaymentMedium.AD_Client_ID IN(0,1010016) AND C_POSPaymentMedium.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|1015785|AD_Ref_List.Value == SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language=’es_AR’) WHERE AD_Ref_List.AD_Reference_ID=1010202 ORDER BY 2 LIMIT 1000
    1111|10264|C_ConversionType.C_ConversionType_ID == SELECT C_ConversionType.C_ConversionType_ID,NULL,C_ConversionType.Name,C_ConversionType.IsActive FROM C_ConversionType WHERE C_ConversionType.AD_Client_ID IN(0,1010016) AND C_ConversionType.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|10788|C_Invoice.C_Invoice_ID == SELECT C_Invoice.C_Invoice_ID,NULL,C_Invoice.DocumentNo,C_Invoice.IsActive FROM C_Invoice WHERE C_Invoice.AD_Client_ID IN(0,1010016) AND C_Invoice.AD_Org_ID IN(0,1010053) ORDER BY C_Invoice.DocumentNo LIMIT 1000
    1111|10805|C_InvoiceLine.C_Invoice_ID == SELECT C_InvoiceLine.C_Invoice_ID,NULL,C_InvoiceLine.LineTotalAmt,C_InvoiceLine.IsActive FROM C_InvoiceLine WHERE C_InvoiceLine.AD_Client_ID IN(0,1010016) AND C_InvoiceLine.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3485|AD_Client.AD_Client_ID == SELECT AD_Client.AD_Client_ID,NULL,AD_Client.Name,AD_Client.IsActive FROM AD_Client WHERE AD_Client.AD_Client_ID <> 0 AND AD_Client.AD_Client_ID IN(0,1010016) AND AD_Client.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3486|AD_Org.AD_Org_ID == SELECT AD_Org.AD_Org_ID,NULL,AD_Org.Name,AD_Org.IsActive FROM AD_Org WHERE AD_Org.AD_Org_ID <> 0 AND AD_Org.IsSummary=’N’ AND AD_Org.AD_Client_ID IN(0,1010016) AND AD_Org.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3493|C_DocType.C_DocType_ID == SELECT C_DocType.C_DocType_ID,NULL,C_DocType_Trl.Name,C_DocType.IsActive FROM C_DocType INNER JOIN C_DocType_TRL ON (C_DocType.C_DocType_ID=C_DocType_Trl.C_DocType_ID AND C_DocType_Trl.AD_Language=’es_AR’) WHERE C_DocType.AD_Client_ID IN(0,1010016) AND C_DocType.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3494|AD_Ref_List.Value == SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language=’es_AR’) WHERE AD_Ref_List.AD_Reference_ID=131 ORDER BY 2 LIMIT 1000
    1111|3500|C_PaymentTerm.C_PaymentTerm_ID == SELECT C_PaymentTerm.C_PaymentTerm_ID,NULL,C_PaymentTerm_Trl.Name,C_PaymentTerm.IsActive FROM C_PaymentTerm INNER JOIN C_PaymentTerm_TRL ON (C_PaymentTerm.C_PaymentTerm_ID=C_PaymentTerm_Trl.C_PaymentTerm_ID AND C_PaymentTerm_Trl.AD_Language=’es_AR’) WHERE C_PaymentTerm.AD_Client_ID IN(0,1010016) AND C_PaymentTerm.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3501|C_BPartner_Location.C_BPartner_Location_ID == SELECT C_BPartner_Location.C_BPartner_Location_ID,NULL,C_BPartner_Location.Name ||’_’|| C_BPartner_Location.C_Location_ID,C_BPartner_Location.IsActive FROM C_BPartner_Location WHERE C_BPartner_Location.AD_Client_ID IN(0,1010016) AND C_BPartner_Location.AD_Org_ID IN(0,1010053) AND C_BPartner_Location.C_BPartner_ID=1012189 AND C_BPartner_Location.IsBillTo=’Y’ AND C_BPartner_Location.IsActive=’Y’ ORDER BY 3 LIMIT 1000
    1111|3505|C_Currency.C_Currency_ID == SELECT C_Currency.C_Currency_ID,NULL,C_Currency.ISO_Code,C_Currency.IsActive FROM C_Currency WHERE C_Currency.AD_Client_ID IN(0,1010016) AND C_Currency.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3509|C_Campaign.C_Campaign_ID == SELECT C_Campaign.C_Campaign_ID,NULL,C_Campaign.Name,C_Campaign.IsActive FROM C_Campaign WHERE C_Campaign.AD_Client_ID IN(0,1010016) AND C_Campaign.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3510|C_Project.C_Project_ID == SELECT C_Project.C_Project_ID,NULL,C_Project.Value ||’_’|| C_Project.Name,C_Project.IsActive FROM C_Project WHERE C_Project.AD_Client_ID IN(0,1010016) AND C_Project.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3511|C_Activity.C_Activity_ID == SELECT C_Activity.C_Activity_ID,NULL,C_Activity.Name,C_Activity.IsActive FROM C_Activity WHERE C_Activity.AD_Client_ID IN(0,1010016) AND C_Activity.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3781|C_DocType.C_DocType_ID == SELECT C_DocType.C_DocType_ID,NULL,C_DocType_Trl.Name,C_DocType.IsActive FROM C_DocType INNER JOIN C_DocType_TRL ON (C_DocType.C_DocType_ID=C_DocType_Trl.C_DocType_ID AND C_DocType_Trl.AD_Language=’es_AR’) WHERE C_DocType.AD_Client_ID=1010016 AND C_DocType.AD_Client_ID IN(0,1010016) AND C_DocType.AD_Org_ID IN(0,1010053) AND C_DocType.DocBaseType IN (‘ARI’, ‘API’,’ARC’,’APC’) AND C_DocType.IsSOTrx=’Y’ AND ( ( ‘Y’=’Y’ AND EXISTS (SELECT * FROM ad_sequence WHERE ad_sequence_id = C_DocType.docnosequence_id AND currentnext >= 10000000 and length(prefix) >= 4) ) OR ( ‘Y’=’N’ ) ) AND (C_DocType.AD_Org_ID = 0 OR C_DocType.AD_Org_ID = 1010053) ORDER BY 3 LIMIT 1000
    1111|3787|C_Charge.C_Charge_ID == SELECT C_Charge.C_Charge_ID,NULL,C_Charge.Name,C_Charge.IsActive FROM C_Charge WHERE C_Charge.AD_Client_ID=1010016 AND C_Charge.AD_Client_ID IN(0,1010016) AND C_Charge.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3789|M_PriceList.M_PriceList_ID == SELECT M_PriceList.M_PriceList_ID,NULL,M_PriceList.Name,M_PriceList.IsActive FROM M_PriceList WHERE M_PriceList.AD_Client_ID IN(0,1010016) AND M_PriceList.AD_Org_ID IN(0,1010053) AND M_PriceList.IsSOPriceList=’Y’ ORDER BY 3 LIMIT 1000
    1111|3829|AD_Client.AD_Client_ID == SELECT AD_Client.AD_Client_ID,NULL,AD_Client.Name,AD_Client.IsActive FROM AD_Client WHERE AD_Client.AD_Client_ID <> 0 AND AD_Client.AD_Client_ID IN(0,1010016) AND AD_Client.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3830|AD_Org.AD_Org_ID == SELECT AD_Org.AD_Org_ID,NULL,AD_Org.Name,AD_Org.IsActive FROM AD_Org WHERE AD_Org.AD_Org_ID <> 0 AND AD_Org.IsSummary=’N’ AND AD_Org.AD_Client_ID IN(0,1010016) AND AD_Org.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3845|C_Charge.C_Charge_ID == SELECT C_Charge.C_Charge_ID,NULL,C_Charge.Name,C_Charge.IsActive FROM C_Charge WHERE C_Charge.AD_Client_ID IN(0,1010016) AND C_Charge.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3848|C_Tax.C_Tax_ID == SELECT C_Tax.C_Tax_ID,NULL,C_Tax_Trl.Name,C_Tax.IsActive FROM C_Tax INNER JOIN C_Tax_TRL ON (C_Tax.C_Tax_ID=C_Tax_Trl.C_Tax_ID AND C_Tax_Trl.AD_Language=’es_AR’) WHERE C_Tax.C_Tax_ID IN (SELECT c_tax_id FROM C_Tax ct left join C_TaxCategory ctc on ct.c_taxcategory_id = ctc.c_taxcategory_Id WHERE ctc.isManual = ‘N’) AND C_Tax.AD_Client_ID IN(0,1010016) AND C_Tax.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3852|AD_Client.AD_Client_ID == SELECT AD_Client.AD_Client_ID,NULL,AD_Client.Name,AD_Client.IsActive FROM AD_Client WHERE AD_Client.AD_Client_ID IN(0,1010016) AND AD_Client.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|3853|AD_Org.AD_Org_ID == SELECT AD_Org.AD_Org_ID,NULL,AD_Org.Name,AD_Org.IsActive FROM AD_Org WHERE (AD_Org.IsSummary=’N’ OR AD_Org.AD_Org_ID=0) AND AD_Org.AD_Client_ID IN(0,1010016) AND AD_Org.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|4020|AD_Ref_List.Value == SELECT NULL, AD_Ref_List.Value,trl.Name, AD_Ref_List.IsActive FROM AD_Ref_List INNER JOIN AD_Ref_List_Trl trl ON (AD_Ref_List.AD_Ref_List_ID=trl.AD_Ref_List_ID AND trl.AD_Language=’es_AR’) WHERE AD_Ref_List.AD_Reference_ID=195 ORDER BY 2 LIMIT 1000
    1111|7734|A_Asset.A_Asset_ID == SELECT A_Asset.A_Asset_ID,NULL,A_Asset.Name,A_Asset.IsActive FROM A_Asset WHERE A_Asset.AD_Client_ID IN(0,1010016) AND A_Asset.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|8303|AD_Org.AD_Org_ID == SELECT AD_Org.AD_Org_ID,NULL,AD_Org.Name,AD_Org.IsActive FROM AD_Org WHERE (AD_Org.IsSummary=’N’ OR AD_Org.AD_Org_ID=0) AND AD_Org.AD_Client_ID IN(0,1010016) AND AD_Org.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|8309|AD_Client.AD_Client_ID == SELECT AD_Client.AD_Client_ID,NULL,AD_Client.Name,AD_Client.IsActive FROM AD_Client WHERE AD_Client.AD_Client_ID IN(0,1010016) AND AD_Client.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|8315|C_PaySchedule.C_PaySchedule_ID == SELECT C_PaySchedule.C_PaySchedule_ID,NULL,(SELECT C_PaymentTerm.Name FROM C_PaymentTerm WHERE C_PaySchedule.C_PaymentTerm_ID=C_PaymentTerm.C_PaymentTerm_ID) ||’_’|| CAST (C_PaySchedule.NetDays AS Text) ||’_’|| CAST (C_PaySchedule.Percentage AS Text),C_PaySchedule.IsActive FROM C_PaySchedule WHERE C_PaySchedule.AD_Client_ID IN(0,1010016) AND C_PaySchedule.AD_Org_ID IN(0,1010053) ORDER BY 3 LIMIT 1000
    1111|9333|AD_Org.AD_Org_ID == SELECT AD_Org.AD_Org_ID,NULL,AD_Org.Value || ‘-‘ || AD_Org.Name,AD_Org.IsActive FROM AD_Org WHERE AD_Org.IsSummary=’N’ AND AD_Org_ID <> 0 AND AD_Org.AD_Client_ID IN(0,1010016) AND AD_Org.AD_Org_ID IN(0,1010053) ORDER BY AD_Org.Name LIMIT 1000
    1111|9579|C_ElementValue.C_ElementValue_ID == SELECT C_ElementValue.C_ElementValue_ID,NULL,C_ElementValue.Value || ‘-‘ || C_ElementValue_Trl.Name,C_ElementValue.IsActive FROM C_ElementValue INNER JOIN C_ElementValue_TRL ON (C_ElementValue.C_ElementValue_ID=C_ElementValue_Trl.C_ElementValue_ID AND C_ElementValue_Trl.AD_Language=’es_AR’) WHERE C_ElementValue.IsSummary=’N’ AND C_ElementValue.AD_Client_ID IN(0,1010016) AND C_ElementValue.AD_Org_ID IN(0,1010053) ORDER BY C_ElementValue.Value LIMIT 1000
    1111|9580|C_ElementValue.C_ElementValue_ID == SELECT C_ElementValue.C_ElementValue_ID,NULL,C_ElementValue.Value || ‘-‘ || C_ElementValue_Trl.Name,C_ElementValue.IsActive FROM C_ElementValue INNER JOIN C_ElementValue_TRL ON (C_ElementValue.C_ElementValue_ID=C_ElementValue_Trl.C_ElementValue_ID AND C_ElementValue_Trl.AD_Language=’es_AR’) WHERE C_ElementValue.IsSummary=’N’ AND C_ElementValue.AD_Client_ID IN(0,1010016) AND C_ElementValue.AD_Org_ID IN(0,1010053) ORDER BY C_ElementValue.Value LIMIT 1000
    2|0|AD_Tab_ID == 263
    2|0|AD_Table_ID == 318
    2|0|AccessLevel == 1
    2|0|IsActive == Y
    2|0|Name == Factura
    2|0|Processed == N
    2|0|SQL == SELECT C_Invoice_ID,DatePrinted,NumeroDeDocumento,Caja,(SELECT c.Codigo FROM C_BPartner bp, C_Categoria_IVA c WHERE C_Invoice.C_BPartner_ID = bp.C_BPartner_ID AND bp.C_Categoria_IVA_ID = c.C_Categoria_IVA_ID) AS CodigoCategoriaIVA,InitialCurrentAccountAmt,AuthCode,DateAcct,TipoComprobante,Ref_Invoice_ID,C_Region_ID,C_POSJournal_ID,IsSelfService,ManageDragOrderDiscounts,IsPrinted,IsCopy,NotExchangeableCredit,IsTransferred,IsSOTrx,ManualDocumentNo,AuthMatch,IsDiscountPrinted,IsInDispute,IsPayScheduleValid,Processed,IsActive,IsApproved,IsExchange,IsTaxIncluded,SendEMail,FiscalAlreadyPrinted,Processing,GenerateTo,C_Payment_ID,C_CashLine_ID,AD_Client_ID,AD_Org_ID,C_Order_ID,DateOrdered,DocumentNo,POReference,PuntoDeVenta,NumeroComprobante,Description,C_DocTypeTarget_ID,C_Letra_Comprobante_ID,C_Invoice_Orig_ID,ApplyPercepcion,C_BPartner_ID,DateInvoiced,C_BPartner_Location_ID,NombreCli,NroIdentificCliente,Invoice_Adress,CUIT,AD_User_ID,M_PriceList_ID,C_Currency_ID,C_ConversionType_ID,SalesRep_ID,C_Charge_ID,ChargeAmt,PaymentRule,C_PaymentTerm_ID,CreateFrom,CreateCashLine,C_Project_ID,C_Activity_ID,C_POSPaymentMedium_ID,C_Campaign_ID,AD_OrgTrx_ID,User1_ID,User2_ID,TotalLines,GrandTotal,DocStatus,C_DocType_ID,ManualGeneralDiscount,CopyFrom,DocAction,Posted,IsPaid,CAI,DateCAI,Created,CreatedBy,Updated,UpdatedBy FROM C_Invoice WHERE IsSOTrx=’Y’ AND (Processed=’N’ OR Updated>(current_timestamp-cast(cast(7 as text)|| ‘days’ as interval))) AND C_Invoice.AD_Client_ID IN(0,1010016) AND C_Invoice.AD_Org_ID IN(0,1010053) ORDER BY DocumentNo DESC
    2|1|AD_Tab_ID == 270
    2|1|AD_Table_ID == 333
    2|1|AccessLevel == 1
    2|1|LinkColumnName == C_Invoice_ID
    2|1|Name == Línea de la Factura
    2|2|AD_Tab_ID == 271
    2|2|AD_Table_ID == 334
    2|2|AccessLevel == 1
    2|2|LinkColumnName == C_Invoice_ID
    2|2|Name == Impuesto de la Factura
    2|3|AD_Tab_ID == 460
    2|3|AD_Table_ID == 551
    2|3|AccessLevel == 1
    2|3|LinkColumnName == C_Invoice_ID
    2|3|Name == Programa de Pagos
    2|4|AD_Tab_ID == 1010235
    2|4|Name == Descuentos / Recargos
    2|AD_Client_ID == 1010016
    2|AD_Org_ID == 1010053
    2|ApplyPercepcion == Y
    2|AuthMatch == N
    2|AutoCommit == Y
    2|BaseTable_ID == 318
    2|CUIT == 30711789304
    2|C_BPartner_ID == 1012189
    2|C_BPartner_Location_ID == 1012201
    2|C_ConversionType_ID == 114
    2|C_Currency_ID == 118
    2|C_DocTypeTarget_ID == 1010582
    2|C_DocType_ID == 0
    2|C_Invoice_ID == 1021699
    2|C_Letra_Comprobante_ID == 1010039
    2|C_PaymentTerm_ID == 1010083
    2|C_Region_ID == 1000027
    2|ChargeAmt == 0.00
    2|CodigoCategoriaIVA == 2
    2|CopyFrom == N
    2|CreateCashLine == N
    2|CreateFrom == N
    2|Created == 2013-03-15 00:49:17.3
    2|CreatedBy == 1010759
    2|DateAcct == 2013-03-15 00:00:00
    2|DateInvoiced == 2013-03-15 00:00:00
    2|DocAction == CO
    2|DocBaseType == ARI
    2|DocStatus == DR
    2|DocTypeKey == CIA0001
    2|DocumentNo == A000100000051
    2|FiscalAlreadyPrinted == N
    2|GenerateTo == N
    2|GrandTotal == 72.60
    2|HasCharges == N
    2|InitialCurrentAccountAmt == 0.00
    2|Invoice_Adress == PRIMER ENTRERRIANO 398, GUALEGUAY, 2840, Entre Ríos
    2|IsActive == Y
    2|IsApproved == N
    2|IsCopy == N
    2|IsDiscountPrinted == N
    2|IsExchange == N
    2|IsInDispute == N
    2|IsPaid == N
    2|IsPayScheduleValid == Y
    2|IsPrinted == N
    2|IsSOTrx == Y
    2|IsSelfService == N
    2|IsTaxIncluded == N
    2|IsTransferred == N
    2|M_PriceList_ID == 1010595
    2|ManageDragOrderDiscounts == N
    2|ManualDocumentNo == N
    2|ManualGeneralDiscount == 0.00
    2|NombreCli == MARTINEZ JORGE ARTURO, PAREDES LUCIANO J
    2|NotExchangeableCredit == N
    2|NumeroComprobante == 51
    2|NumeroDeDocumento == A000100000051
    2|PaymentRule == P
    2|Posted == N
    2|Processed == N
    2|Processing == N
    2|PuntoDeVenta == 1
    2|SalesRep_ID == 1010717
    2|SendEMail == N
    2|TotalLines == 60.00
    2|Updated == 2013-04-14 15:48:17.5
    2|UpdatedBy == 1010717
    2|WindowName == Factura (clientes)
    AutoCommit == Y
    C_Currency_118 == ARS
    P1010098|InventoryKind == IO
    P103|Type == S
    P189|DataType == S
    P|AD_FTDoc == 1002145
    P|AllowExchangeDifference == 0.01
    P|AuditReferenceCurrencyISOCode == USD
    P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
    P|DIF_CAMBIO_ARTICULO == 10000001
    P|DIF_CAMBIO_PTO_VENTA == 1
    P|InfoMaxRowsAllowed == 1000
    P|InfoRowCountMethod == C
    P|LOCAL_AR == Y
    P|L_AR_CFMontoMaximo == 1000
    P|L_AR_MaxOrderLineQty == 999
    P|LookupMaxRowsAllowed == 1000
    P|MantenimientoPadron == 3
    P|OpenTrxLowerLimit == 6
    P|OpenTrxTimeOutMS == 3600000
    P|OpenTrxUpperLimit == 10
    P|POSCashJounal_ValidDiff == 0.5
    P|ReplicationEventsActive == Y
    P|TransferDueDateDays == 1
    java.naming.provider.url == jnp://localhost:1099

    === System ===
    awt.toolkit=sun.awt.windows.WToolkit
    file.encoding=UTF-8
    file.encoding.pkg=sun.io
    file.separator=
    java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
    java.awt.printerjob=sun.awt.windows.WPrinterJob
    java.class.path=C:UsersAVECHE~1AppDataLocalTemptemp1.jar;C:ServidorOXP.libbatik-awt-util.jar;C:ServidorOXP.libbatik-dom.jar;C:ServidorOXP.libbatik-svggen.jar;C:ServidorOXP.libbatik-util.jar;C:ServidorOXP.libbatik-xml.jar;C:ServidorOXP.libCMPCS.jar;C:ServidorOXP.libJasperReports.jar;C:ServidorOXP.libjboss.jar;C:ServidorOXP.libjsp-api-2.0.jar;C:ServidorOXP.liboracle.jar;C:ServidorOXP.libOXP.jar;C:ServidorOXP.libOXPApps.jar;C:ServidorOXP.libOXPInstall.jar;C:ServidorOXP.libOXPRoot.jar;C:ServidorOXP.libOXPSLib.jar;C:ServidorOXP.libOXPXLib.jar;C:ServidorOXP.libpostgresql.jar;C:ServidorOXP.libsqlj.jar;C:ServidorOXP.libsqlServer.jar;C:ServidorOXP.libsybase.jar;C:ServidorOXP.libXOXPTools.jar;C:ServidorOXP.libswing-layout-1.0.jar;C:ServidorOXP.libPDFRenderer.jar;C:ServidorOXP.libJasperReports.jar;
    java.class.version=50.0
    java.endorsed.dirs=C:jdk1.6.0_31jrelibendorsed
    java.ext.dirs=C:jdk1.6.0_31jrelibext;C:WindowsSunJavalibext
    java.home=C:jdk1.6.0_31jre
    java.io.tmpdir=C:UsersAVECHE~1AppDataLocalTemp
    java.library.path=C:jdk1.6.0_31bin;C:WindowsSunJavabin;C:Windowssystem32;C:Windows;C:jdk1.6.0_31bin;C:Program FilesCommon FilesMicrosoft SharedWindows Live;C:Program Files (x86)Common FilesMicrosoft SharedWindows Live;C:Program Files (x86)PC Connectivity Solution;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;C:Program FilesIntelWiFibin;C:Program FilesCommon FilesIntelWirelessCommon;C:Program Files (x86)Windows LiveShared;C:Program Files (x86)Common FilesRoxio SharedDLLShared;C:Program Files (x86)Common FilesRoxio SharedOEMDLLShared;C:Program Files (x86)Common FilesRoxio SharedOEMDLLShared;C:Program Files (x86)Common FilesRoxio SharedOEM12.0DLLShared;C:Program Files (x86)RoxioOEMAudioCore;C:Program FilesTortoiseSVNbin; C:Program FilesPostgreSQL9.1bin;C:Program FilesTortoiseHg;C:Program Files (x86)Nmap;C:Program Files (x86)OpenVPNbin;.
    java.runtime.name=Java(TM) SE Runtime Environment
    java.runtime.version=1.6.0_31-b05
    java.specification.name=Java Platform API Specification
    java.specification.vendor=Sun Microsystems Inc.
    java.specification.version=1.6
    java.vendor=Sun Microsystems Inc.
    java.vendor.url=http://java.sun.com/
    java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
    java.version=1.6.0_31
    java.vm.info=mixed mode
    java.vm.name=Java HotSpot(TM) 64-Bit Server VM
    java.vm.specification.name=Java Virtual Machine Specification
    java.vm.specification.vendor=Sun Microsystems Inc.
    java.vm.specification.version=1.0
    java.vm.vendor=Sun Microsystems Inc.
    java.vm.version=20.6-b01
    line.separator=

    os.arch=amd64
    os.name=Windows 7
    os.version=6.1
    path.separator=;
    sun.arch.data.model=64
    sun.boot.class.path=C:jdk1.6.0_31jrelibresources.jar;C:jdk1.6.0_31jrelibrt.jar;C:jdk1.6.0_31jrelibsunrsasign.jar;C:jdk1.6.0_31jrelibjsse.jar;C:jdk1.6.0_31jrelibjce.jar;C:jdk1.6.0_31jrelibcharsets.jar;C:jdk1.6.0_31jrelibmodulesjdk.boot.jar;C:jdk1.6.0_31jreclasses
    sun.boot.library.path=C:jdk1.6.0_31jrebin
    sun.cpu.endian=little
    sun.cpu.isalist=amd64
    sun.desktop=windows
    sun.io.unicode.encoding=UnicodeLittle
    sun.java.command=org.openXpertya.OpenXpertya
    sun.java.launcher=SUN_STANDARD
    sun.jnu.encoding=Cp1252
    sun.management.compiler=HotSpot 64-Bit Tiered Compilers
    sun.os.patch.level=Service Pack 1
    suppressSwingDropSupport=true
    user.country=AR
    user.dir=C:ServidorOXP
    user.home=C:Usersavechetti
    user.language=es
    user.name=avechetti
    user.timezone=America/Buenos_Aires
    user.variant=

    #37376
    AMEBIS
    Participante

    Anda a administracion – Contabilidad – Esquema contable y desactiva el tilde de “Control de pediodo aautomatico”

    Avisame si te funciono asi.

    Saludos

    #37377
    Luis Alberto Toba
    Participante

    Para mantener el control de periodos automático activado, primero tendrías que revisar a cuantos días tenes configurado el historial para que te permita realizar operaciones.
    Con que fecha estas realizando la factura?

    Saludos

    #37378
    Ariel Vechetti
    Participante

    Si el problema estaba en Control de pediodo aautomatico”. Estoy implemtando el sistema y registrando comprobantes de hace dos meses atras.

    #37379
    Ariel Tacon
    Participante

    Hola, ya hice todo esto que comentaron, tengo desactivado el control automatico y los periodos estan todos abiertos. No puedo grabar un pedido de proveedor. Que mas puedo hacer?

    Saludos

    #37947
    Saulo Gil
    Miembro

    ¿ Cual es el mensaje de error ? (En rojo al pie de la ventana)

    #37948
    AMEBIS
    Participante

    Hay muchos errores con los periodos de Libertya. Lo mejor es crear un calendario nuevo y luego seleccionarlo al mismo en el perfil de configuracion de la compania.

    NO hay que trabajar con el que viene por defecto en Libertya.

    Saludos

Viendo 7 entradas - de la 1 a la 7 (de un total de 7)
  • Debes estar registrado para responder a este debate.