Error en llamada de artículo al crear factura

Inicio Foros Foro principal Ayuda Error en llamada de artículo al crear factura

  • Este debate está vacío.
Viendo 3 entradas - de la 1 a la 3 (de un total de 3)
  • Autor
    Entradas
  • #32985

    Buenas que puede generar este error, no es el artículo ya que puedo facturar a otros clientes;
    Sucede al llamar al producto de un pedido, me pasa solo con un cliente.

    Error:

    @InvoiceLineSaveError: (# 10):

    #39094
    Luis Alberto Toba
    Participante

    Estimado , para analizar la situación tendrías que pasarnos el log de errores. Se encuentra en Herramientas, preferencias, la pestaña de errores, guardar archivo..

    Saludos

    #39095

    LOG

    23:15:56.893 MInvoice.set_Value: El campo es = caeerror [11]
    23:15:56.893 MInvoice.set_Value: El campo es = idcae [11]
    23:15:56.893 MInvoice.set_Value: El campo es = vtocae [11]
    23:15:56.893 MInvoice.set_Value: En po.else [11]
    23:15:56.893 MInvoice.set_Value: En po.else con value.getClass() =class java.math.BigDecimal [11]
    23:15:56.893 MInvoice.set_Value: En po.else con p_info.getColumnClass(index) =class java.math.BigDecimal [11]
    23:15:56.893 MInvoice.set_Value: En el primer if con value= 168.00 [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT SUM(it.taxamt) FROM C_InvoiceTax it WHERE (it.C_Invoice_ID = ?) [11]
    23:15:56.893 CPreparedStatement.: estamos en trx!=null [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT SUM(it.taxamt) FROM C_InvoiceTax it WHERE (it.C_Invoice_ID = ‘1021792’) [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT i.grandtotal FROM C_Invoice i WHERE (i.C_Invoice_ID = ?) [11]
    23:15:56.893 CPreparedStatement.: estamos en trx!=null [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT i.grandtotal FROM C_Invoice i WHERE (i.C_Invoice_ID = ‘1021792’) [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT it.taxbaseamt FROM C_InvoiceTax it WHERE (it.C_Invoice_ID = ?) ORDER BY it.Created DESC LIMIT 1 [11]
    23:15:56.893 CPreparedStatement.: estamos en trx!=null [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT it.taxbaseamt FROM C_InvoiceTax it WHERE (it.C_Invoice_ID = ‘1021792’) ORDER BY it.Created DESC LIMIT 1 [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT AD_Client_ID,AD_ComponentObjectUID,AD_Org_ID,AfterDelivery,ApplicationDate,C_POSPaymentMedium_ID,C_PaymentTerm_ID,Created,CreatedBy,Description,Discount,Discount2,DiscountApplicationType,DiscountApplicationType2,DiscountDays,DiscountDays2,DocumentNote,FixMonthCutoff,FixMonthDay,FixMonthDay2,FixMonthOffset,GraceDays,GraceDays2,IsActive,IsDefault,IsDueFixed,IsNextBusinessDay,IsValid,Name,NetDay,NetDays,Processing,Updated,UpdatedBy,Value FROM C_PaymentTerm WHERE C_PaymentTerm_ID=? [11]
    23:15:56.893 CPreparedStatement.: estamos en trx!=null [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT AD_Client_ID,AD_ComponentObjectUID,AD_Org_ID,AfterDelivery,ApplicationDate,C_POSPaymentMedium_ID,C_PaymentTerm_ID,Created,CreatedBy,Description,Discount,Discount2,DiscountApplicationType,DiscountApplicationType2,DiscountDays,DiscountDays2,DocumentNote,FixMonthCutoff,FixMonthDay,FixMonthDay2,FixMonthOffset,GraceDays,GraceDays2,IsActive,IsDefault,IsDueFixed,IsNextBusinessDay,IsValid,Name,NetDay,NetDays,Processing,Updated,UpdatedBy,Value FROM C_PaymentTerm WHERE C_PaymentTerm_ID=’1010144′ [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT AD_Client_ID,AD_OrgTrx_ID,AD_Org_ID,AD_User_ID,ApplyPercepcion,AuthCode,AuthMatch,CAI,CUIT,C_Activity_ID,C_BPartner_ID,C_BPartner_Location_ID,C_Campaign_ID,C_CashLine_ID,C_Charge_ID,C_ConversionType_ID,C_Currency_ID,C_DocTypeTarget_ID,C_DocType_ID,C_Invoice_ID,C_Invoice_Orig_ID,C_Letra_Comprobante_ID,C_Order_ID,C_POSJournal_ID,C_POSPaymentMedium_Credit_ID,C_POSPaymentMedium_ID,C_PaymentTerm_ID,C_Payment_ID,C_Project_ID,C_Region_Delivery_ID,C_Region_ID,Caja,ChargeAmt,(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,CopyFrom,CreateCashLine,CreateFrom,Created,CreatedBy,DateAcct,DateCAI,DateInvoiced,DateOrdered,DatePrinted,DateRecepted,Description,DocAction,DocStatus,DocumentNo,FechadeTCparaActualizarPrecios,FiscalAlreadyPrinted,FiscalDescription,GenerateTo,GrandTotal,InitialCurrentAccountAmt,Invoice_Adress,IsActive,IsApproved,IsCopy,IsDiscountPrinted,IsExchange,IsInDispute,IsPaid,IsPayScheduleValid,IsPrinted,IsSOTrx,IsSelfService,IsTaxIncluded,IsTransferred,IsVoidable,M_PriceList_ID,M_RMA_ID,ManageDragOrderDiscounts,ManualDocumentNo,ManualGeneralDiscount,NetAmount,NombreCli,NotExchangeableCredit,NroIdentificCliente,NumeroComprobante,NumeroDeDocumento,POReference,PaymentRule,Posted,PrintType,Processed,Processing,PuntoDeVenta,Ref_Invoice_ID,SalesRep_ID,SendEMail,TipoComprobante,TotalLines,UpdateOrderQty,Updated,UpdatedBy,User1_ID,User2_ID,cae,caecbte,caeerror,idcae,vtocae FROM C_Invoice WHERE C_Invoice_ID=? [11]
    23:15:56.893 CPreparedStatement.: estamos en trx!=null [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT AD_Client_ID,AD_OrgTrx_ID,AD_Org_ID,AD_User_ID,ApplyPercepcion,AuthCode,AuthMatch,CAI,CUIT,C_Activity_ID,C_BPartner_ID,C_BPartner_Location_ID,C_Campaign_ID,C_CashLine_ID,C_Charge_ID,C_ConversionType_ID,C_Currency_ID,C_DocTypeTarget_ID,C_DocType_ID,C_Invoice_ID,C_Invoice_Orig_ID,C_Letra_Comprobante_ID,C_Order_ID,C_POSJournal_ID,C_POSPaymentMedium_Credit_ID,C_POSPaymentMedium_ID,C_PaymentTerm_ID,C_Payment_ID,C_Project_ID,C_Region_Delivery_ID,C_Region_ID,Caja,ChargeAmt,(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,CopyFrom,CreateCashLine,CreateFrom,Created,CreatedBy,DateAcct,DateCAI,DateInvoiced,DateOrdered,DatePrinted,DateRecepted,Description,DocAction,DocStatus,DocumentNo,FechadeTCparaActualizarPrecios,FiscalAlreadyPrinted,FiscalDescription,GenerateTo,GrandTotal,InitialCurrentAccountAmt,Invoice_Adress,IsActive,IsApproved,IsCopy,IsDiscountPrinted,IsExchange,IsInDispute,IsPaid,IsPayScheduleValid,IsPrinted,IsSOTrx,IsSelfService,IsTaxIncluded,IsTransferred,IsVoidable,M_PriceList_ID,M_RMA_ID,ManageDragOrderDiscounts,ManualDocumentNo,ManualGeneralDiscount,NetAmount,NombreCli,NotExchangeableCredit,NroIdentificCliente,NumeroComprobante,NumeroDeDocumento,POReference,PaymentRule,Posted,PrintType,Processed,Processing,PuntoDeVenta,Ref_Invoice_ID,SalesRep_ID,SendEMail,TipoComprobante,TotalLines,UpdateOrderQty,Updated,UpdatedBy,User1_ID,User2_ID,cae,caecbte,caeerror,idcae,vtocae FROM C_Invoice WHERE C_Invoice_ID=’1021792′ [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= DELETE FROM C_InvoicePaySchedule WHERE C_Invoice_ID=1021792 [11]
    23:15:56.893 CPreparedStatement.: estamos en trx!=null [11]
    23:15:56.893 MPaymentTerm.deleteInvoicePaySchedule: C_Invoice_ID=1021792 – #0 [11]
    23:15:56.893 Trx.rollback: **** VCreateFrom_1429238035271 [11]
    23:15:56.893 ADialog.error: Error – @InvoiceLineSaveError@ (# 10):
    [11]
    23:15:56.893 : 2: org.openXpertya.apps.ADialog.error(ADialog.java:234) [11]
    23:15:56.893 : 3: org.openXpertya.grid.VCreateFrom.doSave(VCreateFrom.java:966) [11]
    23:15:56.893 : 4: org.openXpertya.grid.VCreateFrom.actionPerformed(VCreateFrom.java:509) [11]
    23:15:56.893 : 47: org.openXpertya.apps.APanel.actionButton(APanel.java:2461) [11]
    23:15:56.893 : 48: org.openXpertya.apps.APanel.actionPerformed(APanel.java:1521) [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Error [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= File [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Cancel [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= OK [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= EMailSupport [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= PrintScreen [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ScreenShot [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Preference [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= End [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Preference [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Cancel [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= OK [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ErrorsOnly [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Reset [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= SendEMail [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= SaveFile [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=? AND t.AD_Language=? [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=’AD_ROLE_ID’ AND t.AD_Language=’es_AR’ [11]
    23:15:56.893 Preference.: Preference [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= TraceLevel [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= TraceLevel [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= TraceFile [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= TraceFile [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= UITheme [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= UITheme [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= AutoCommit [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= AutoCommit [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= OXPSYS [11]


    > Msg.getMsg: NOT found: OXPSYS [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= OXPSYS [11]


    > Msg.getMsg: NOT found: OXPSYS [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= AlwaysPrintPreview [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= AlwaysPrintPreview [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= AutoLogin [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= AutoLogin [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= StorePassword [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= StorePassword [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ShowTrlTab [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ShowTrlTab [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ShowAcctTab [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ShowAcctTab [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ShowAdvancedTab [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ShowAdvancedTab [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ServerObjects [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ServerObjects [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ServerProcess [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ServerProcess [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Printer [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Date [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ChangePassword [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= ChangeUserPassword [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Preference [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Context [11]
    23:15:56.893 Preference.load: Preference.load [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=? AND t.AD_Language=? [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=’AD_USER_ID’ AND t.AD_Language=’es_AR’ [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=? AND t.AD_Language=? [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=’AD_ROLE_ID’ AND t.AD_Language=’es_AR’ [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=? AND t.AD_Language=? [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=’AD_CLIENT_ID’ AND t.AD_Language=’es_AR’ [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=? AND t.AD_Language=? [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=’AD_ORG_ID’ AND t.AD_Language=’es_AR’ [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=? AND t.AD_Language=? [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=’ISMULTILINGUALDOCUMENT’ AND t.AD_Language=’es_AR’ [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= Errors [11]
    23:15:56.893 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=? AND t.AD_Language=? [11]
    23:15:56.893 CPreparedStatement.executeQuery: estamos p_stmt= SELECT t.Name, t.PO_Name FROM AD_Element_Trl t, AD_Element e WHERE t.AD_Element_ID=e.AD_Element_ID AND UPPER(e.ColumnName)=’AD_WINDOW_ID’ AND t.AD_Language=’es_AR’ [11]
    23:15:56.893 Msg.getMsg: En getMsg:—> Ad_languaje=es_AR Y AD_Message= TraceInfo [11]

    Servidor = localhost : 1099 (No Activo)
    Tunnel=false, Objects=false, Process=false
    Base de datos = muleto01 : 5432 / libertya
    Esquema = libertya
    Usuario = AdminLibertya
    Perfil = Ventas
    Compañía = LIBERTYA
    Organización = LITOCUYO S.R.L.
    Fecha = 2015-04-17 00:00:00
    Impresora = PDFCreator
    Implementation-Vendor = SERVICIOS_DIGITALES
    Implementation-Title = CCTools Libertya
    Implementation-Version = Libertya 20150317-1058
    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-01]
    Documentos Multi-idioma = false
    BaseLanguage = false/false
    PDF License=true
    Java HotSpot(TM) Client VM 20.4-b02
    Windows 7 6.1 Service Pack 1
    === Environment === -1945738304
    Libertya (r) Versión 15.03_20-03-2015 – Software Libre de Gestión- (c) 2013 DISYTEL; Implementación: Versión 15.03 20150326-2207 – ${env.CONSULTORA_OXP}
    muleto01/192.168.3.107
    CConnection[name=localhost{muleto01-libertya-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=muleto01,DBport=5432,DBname=libertya,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=maguafra]
    Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 9.0 JDBC4 (build 801) – via DataSource
    DB_PostgreSQL[jdbc:postgresql://muleto01:5432/libertya?encoding=UTF-8]
    AppsServerOK=false, DatabaseOK=true

    === Context ===
    #AD_Client_ID == 1010016
    #AD_Client_Name == LIBERTYA
    #AD_Language == es_AR
    #AD_Org_ID == 1010053
    #AD_Org_Name == LITOCUYO S.R.L.
    #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 == 1029182
    #AD_User_ID == 1010717
    #AD_User_Name == AdminLibertya
    #C_BP_Group_ID == 1010107
    #C_CashBook_ID == 1010024
    #C_ConversionType_ID == 114
    #C_Country_ID == 119
    #C_DocTypeTarget_ID == 1010522
    #C_Letra_Comprobante_ID == 1010055
    #C_PaymentTerm_ID == 1010083
    #C_Region_ID == 1000027
    #C_TaxCategory_ID == 1010048
    #C_Tax_ID == 1010084
    #C_UOM_ID == 1000000
    #CheckCuitControl == N
    #Date == 2015-04-17 00:00:00
    #GL_Category_ID == 1010098
    #IsPOSJournalActive == N
    #M_Locator_ID == 1010337
    #M_PriceList_ID == 1010595
    #M_Product_Category_ID == 1010146
    #M_Product_Lines_ID == 1010071
    #M_Warehouse_ID == 1010048
    #POSJournalSupervisor == Y
    #PasswordExpirationActive == N
    #PrintPreview == N
    #Printer == PDFCreator
    #SalesRep_ID == 1010717
    #ShowAcct == N
    #ShowAdvanced == Y
    #ShowTrl == N
    #StdPrecision == 2
    #UniqueKeyActive == N
    #User_Level == CO
    #User_Org == 0,1010053,1010112,1010116,1010117
    #VoidingInvoicePOSJournalConfig == U
    #VoidingInvoicePaymentsPOSJournalConfig == P
    #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ú
    1113|1113|AD_User_ID == 0
    1113|1113|C_BPartner_ID == 1012145
    1113|1113|C_BPartner_Location_ID == 1012158
    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,IsSOTrx,IsTransferred,FiscalAlreadyPrinted,AuthMatch,IsApproved,C_POSJournal_ID,AuthCode,SendEMail,IsCopy,Ref_Invoice_ID,DatePrinted,GenerateTo,IsPrinted,IsTaxIncluded,C_CashLine_ID,InitialCurrentAccountAmt,C_Payment_ID,Processed,Processing,NotExchangeableCredit,IsActive,ManageDragOrderDiscounts,IsExchange,ManualDocumentNo,TipoComprobante,M_RMA_ID,DateAcct,IsDiscountPrinted,IsInDispute,IsPayScheduleValid,IsSelfService,(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,C_Region_ID,Caja,NumeroDeDocumento,AD_Client_ID,AD_Org_ID,C_Order_ID,DateOrdered,DocumentNo,UpdateOrderQty,POReference,PuntoDeVenta,NumeroComprobante,Description,C_DocTypeTarget_ID,C_Letra_Comprobante_ID,FiscalDescription,C_Invoice_Orig_ID,C_BPartner_ID,C_BPartner_Location_ID,ApplyPercepcion,NombreCli,DateInvoiced,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,C_Project_ID,C_Activity_ID,C_Campaign_ID,CreateCashLine,AD_OrgTrx_ID,C_POSPaymentMedium_ID,User1_ID,C_POSPaymentMedium_Credit_ID,User2_ID,TotalLines,GrandTotal,DocStatus,C_DocType_ID,CopyFrom,DocAction,Posted,ManualGeneralDiscount,NetAmount,IsPaid,CAI,DateCAI,PrintType,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(1010117,1010116,0,1010053,1010112) 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 == 30611486193
    2|C_BPartner_ID == 1012145
    2|C_BPartner_Location_ID == 1012158
    2|C_ConversionType_ID == 114
    2|C_Currency_ID == 118
    2|C_DocTypeTarget_ID == 1010599
    2|C_DocType_ID == 0
    2|C_Invoice_ID == 1021792
    2|C_Letra_Comprobante_ID == 1010055
    2|C_PaymentTerm_ID == 1010144
    2|C_Region_ID == 1000027
    2|ChargeAmt == 0.00
    2|CodigoCategoriaIVA == 2
    2|CopyFrom == N
    2|CreateCashLine == Y
    2|CreateFrom == N
    2|Created == 2015-04-16 23:17:27.1
    2|CreatedBy == 1010717
    2|DateAcct == 2015-04-17 00:00:00
    2|DateInvoiced == 2015-04-17 23:17:27
    2|DocAction == CO
    2|DocBaseType == ARI
    2|DocStatus == DR
    2|DocTypeKey == CIA0001
    2|DocumentNo == A000100000019
    2|EnforcePriceLimit == N
    2|FiscalAlreadyPrinted == N
    2|GenerateTo == N
    2|GrandTotal == 0.00
    2|HasCharges == N
    2|InitialCurrentAccountAmt == 0.00
    2|Invoice_Adress == RECONQUISTA 1573, CORRIENTES, 3400, Corrientes
    2|IsActive == Y
    2|IsApproved == N
    2|IsCopy == N
    2|IsDiscountPrinted == N
    2|IsExchange == N
    2|IsInDispute == N
    2|IsPaid == N
    2|IsPayScheduleValid == N
    2|IsPrinted == N
    2|IsSOTrx == Y
    2|IsSelfService == N
    2|IsTaxIncluded == N
    2|IsTransferred == N
    2|M_PriceList_ID == 1010595
    2|M_PriceList_Version_ID == 1010586
    2|ManageDragOrderDiscounts == N
    2|ManualDocumentNo == N
    2|ManualGeneralDiscount == 0.00
    2|NetAmount == 0.00
    2|NombreCli == HELADOS EL POLO CTES S.R.L.
    2|NotExchangeableCredit == N
    2|NroIdentificCliente == 30611486193
    2|NumeroComprobante == 19
    2|NumeroDeDocumento ==
    2|PaymentRule == P
    2|Posted == N
    2|Processed == N
    2|Processing == N
    2|PuntoDeVenta == 1
    2|SalesRep_ID == 1010783
    2|SendEMail == N
    2|TotalLines == 0.00
    2|UpdateOrderQty == N
    2|Updated == 2015-04-16 23:17:27.1
    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|AutoCommit == Y
    P|AutoNew == Y
    P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
    P|C_Region_ID_FACTURA_ARCIBA == 1000082
    P|Client == 1010016
    P|ConversationSecurityPolicy == E
    P|DIF_CAMBIO_ARTICULO == 10000001
    P|DIF_CAMBIO_PTO_VENTA == 1
    P|FiscalDescription_VoidedDocument == ANULADO
    P|InfoMaxRowsAllowed == 1000
    P|InfoRowCountMethod == C
    P|LOCAL_AR == Y
    P|L_AR_CFMontoMaximo == 1000
    P|L_AR_LibroIVA_CFMontoMaximoAgrupacion == 1000
    P|L_AR_MaxOrderLineQty == 999
    P|Language == Español (Argentina)
    P|LogTransactionEvents == N
    P|LookupMaxRowsAllowed == 1000
    P|Maintenance_Inventory == 6
    P|MantenimientoPadron == 3
    P|MenuCollapsed == N
    P|MultiOrgTransactionFilterRulesPropertiesFileLocation == /ServidorOXP/utils/replicacion/filters/MultiOrgTransactionFilterRules.properties
    P|NCFiscal_ComprobanteOriginal_ClaveTiposDocumentoPedido == SOSOTD;SOSOTH
    P|OpenTrxLowerLimit == 6
    P|OpenTrxTimeOutMS == 3600000
    P|OpenTrxUpperLimit == 10
    P|Organization == 1010053
    P|POSCashJounal_ValidDiff == 0.5
    P|PathPadronCSV == C:\Padron\
    P|PorcentajeDeAumentoDePrecio == 100
    P|ReasonVoid == Anulación
    P|ReplicationEventsActive == Y
    P|Role == 1010071
    P|SeparadorDeCampoEnCSVPadron == ;
    P|TransferDueDateDays == 1
    P|WAIT_FOR_WORKER_SECONDS == 0
    P|Warehouse == 1010107
    P|WindowTabCollapsible == N
    P|WindowTabPlacement == Left
    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:UsersMULETO~1AppDataLocalTemptemp58.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:Program FilesJavajdk1.6.0_29jrelibendorsed
    java.ext.dirs=C:Program FilesJavajdk1.6.0_29jrelibext;C:WindowsSunJavalibext
    java.home=C:Program FilesJavajdk1.6.0_29jre
    java.io.tmpdir=C:UsersMULETO~1AppDataLocalTemp
    java.library.path=C:Program FilesJavajdk1.6.0_29bin;C:WindowsSunJavabin;C:Windowssystem32;C:Windows;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;bin;C:Program FilesJavajdk1.6.0_29bin;C:Program FilesJavajdk1.6.0_29jrebin;C:Program FilesJavajdk1.6.0_29jrebinclient;C:Program FilesPostgreSQL8.3bin;.
    java.runtime.name=Java(TM) SE Runtime Environment
    java.runtime.version=1.6.0_29-b11
    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_29
    java.vm.info=mixed mode, sharing
    java.vm.name=Java HotSpot(TM) Client 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.4-b02
    line.separator=

    os.arch=x86
    os.name=Windows 7
    os.version=6.1
    path.separator=;
    sun.arch.data.model=32
    sun.boot.class.path=C:Program FilesJavajdk1.6.0_29jrelibresources.jar;C:Program FilesJavajdk1.6.0_29jrelibrt.jar;C:Program FilesJavajdk1.6.0_29jrelibsunrsasign.jar;C:Program FilesJavajdk1.6.0_29jrelibjsse.jar;C:Program FilesJavajdk1.6.0_29jrelibjce.jar;C:Program FilesJavajdk1.6.0_29jrelibcharsets.jar;C:Program FilesJavajdk1.6.0_29jrelibmodulesjdk.boot.jar;C:Program FilesJavajdk1.6.0_29jreclasses
    sun.boot.library.path=C:Program FilesJavajdk1.6.0_29jrebin
    sun.cpu.endian=little
    sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
    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 Client Compiler
    sun.os.patch.level=Service Pack 1
    suppressSwingDropSupport=true
    user.country=AR
    user.dir=C:ServidorOXP
    user.home=C:Usersmuleto-01
    user.language=es
    user.name=muleto-01
    user.timezone=America/Buenos_Aires
    user.variant=

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