Viendo 10 entradas - de la 1 a la 10 (de un total de 10)
  • Autor
    Entradas
  • #65369
    DNG
    Participante

    Hola buenas tardes, estoy intentando generar un recibo a cliente y el ingresar el numero de cliente no me muestra lo que tiene pendiente.

    No encuentro cual es el motivo, ya que en otros reportes si salen como pendientes esas facturas y por aca no aparecen.

    les paso la info, espero me puedan ayudar. gracias!!!!

    ——————————-
    ———–> Msg.getMsg: NOT found: OXPSYS [14]
    ———–> Msg.getMsg: NOT found: OXPSYS [14]
    ===========> AccessSqlParser.getTableInfo: parse – could not remove ON C_BPartner, AD_User c, C_BPartner_Location l, C_Location a foo ON l.C_BPartner_Location_ID = foo.C_BPartner_Location_ID [700]
    ——————————-
    ===========> AccessSqlParser.getTableInfo: parse – could not remove ON C_BPartner, AD_User c, C_BPartner_Location l, C_Location a foo ON l.C_BPartner_Location_ID = foo.C_BPartner_Location_ID [701]
    ——————————-
    ===========> AccessSqlParser.getTableInfo: parse – could not remove ON C_BPartner, AD_User c, C_BPartner_Location l, C_Location a foo ON l.C_BPartner_Location_ID = foo.C_BPartner_Location_ID [702]
    ——————————-
    ===========> VOrdenPagoModel.actualizarFacturas: Error en actualizarFacturas. [14]
    java.lang.NullPointerException
    at org.openXpertya.rc.ReciboDeCliente.isApplyPaymentTerm(ReciboDeCliente.java:1099)
    at org.openXpertya.apps.form.VOrdenCobroModel.updatePaymentTermInfo(VOrdenCobroModel.java:610)
    at org.openXpertya.apps.form.VOrdenCobroModel.actualizarFacturas(VOrdenCobroModel.java:535)
    at org.openXpertya.apps.form.VOrdenPagoModel.setBPartnerFacturas(VOrdenPagoModel.java:1315)
    at org.openXpertya.apps.form.VOrdenPagoModel.updateBPartner(VOrdenPagoModel.java:1296)
    at org.openXpertya.apps.form.VOrdenCobroModel.updateBPartner(VOrdenCobroModel.java:620)
    at org.openXpertya.apps.form.VOrdenPago$38.run(VOrdenPago.java:3063)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
    at java.awt.EventQueue.access$500(EventQueue.java:97)
    at java.awt.EventQueue$3.run(EventQueue.java:709)
    at java.awt.EventQueue$3.run(EventQueue.java:703)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

    Servidor = localhost1 : 1099 (No Activo)
    Tunnel=false, Objects=false, Process=false
    Base de datos = DESKTOP-7E1LCIG : 5432 / libertya2
    Esquema = libertya
    Usuario = Supervisor
    Perfil = Administración
    Compañía = DNG Distribucion
    Organización = DISTRIBUCION
    Fecha = 2022-07-19 00:00:00
    Impresora = Microsoft Print to PDF
    Implementation-Title = CCTools Libertya
    Implementation-Version = Libertya 20220504-1143
    Specification-Vendor = (C) 2005-2006 FUNDESLE.
    Specification-Title = Herramientas de Cliente oxp
    Specification-Version = Libertya
    Implementation-URL = http://www.openxpertya.org
    Implementation-Vendor = SERVICIOS_DIGITALES
    OXPHome = XP
    Language=[Español (Argentina),Locale=es_AR,AD_Language=es_AR,DatePattern=DD.MM.YYYY,DecimalPoint=false]
    MClient[1010016-Libertya]
    Documentos Multi-idioma = true
    BaseLanguage = false/false
    PDF License=true
    Java HotSpot(TM) Client VM 25.131-b11
    Windows 10 10.0
    === Environment === 1716786205
    Libertya (r) Versión 22.0_03-05-2022 – Software Libre de Gestión- (c) 2022 DISYTEL; Implementación: Versión 22.0 20220716-1800 – ${env.CONSULTORA_OXP}
    DESKTOP-7E1LCIG/192.168.54.128
    CConnection[name=localhost1{DESKTOP-7E1LCIG-libertya2-libertya},AppsHost=localhost1,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=DESKTOP-7E1LCIG,DBport=5432,DBname=libertya2,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=cordoba2015]
    Database=PostgreSQL – 9.5.7 – Driver =PostgreSQL JDBC Driver – 42.0.0.jre6 – via DataSource
    DB_PostgreSQL[jdbc:postgresql://DESKTOP-7E1LCIG:5432/libertya2?encoding=UTF-8]
    AppsServerOK=false, DatabaseOK=true

    === Context ===
    #AD_Client_ID == 1010016
    #AD_Client_Name == DNG Distribucion
    #AD_Language == es_AR
    #AD_Org_ID == 1010053
    #AD_Org_Name == DISTRIBUCION
    #AD_PrintColor_ID == 100
    #AD_PrintFont_ID == 130
    #AD_PrintPaper_ID == 103
    #AD_PrintTableFormat_ID == 1000006
    #AD_Role_ID == 1010076
    #AD_Role_Name == Administración
    #AD_Session_ID == 1030374
    #AD_User_ID == 100
    #AD_User_Name == Supervisor
    #C_BP_Group_ID == 1010290
    #C_BankAccount_ID == 1010277
    #C_ConversionType_ID == 114
    #C_Country_ID == 119
    #C_DocTypeTarget_ID == 1010524
    #C_Letra_Comprobante_ID == 1010228
    #C_PaymentTerm_ID == 1010329
    #C_Region_ID == 1000027
    #C_TaxCategory_ID == 1010047
    #C_Tax_ID == 1010086
    #C_UOM_ID == 1000000
    #CheckCuitControl == N
    #Date == 2022-07-19 00:00:00
    #GL_Category_ID == 1010098
    #ImportClearanceActive == N
    #IsPOSJournalActive == N
    #M_Locator_ID == 1010278
    #M_PriceList_ID == 1010597
    #M_Product_Category_ID == 1010397
    #M_Warehouse_ID == 1010048
    #POSJournalSupervisor == Y
    #PasswordExpirationActive == N
    #PrintPreview == Y
    #Printer == Microsoft Print to PDF
    #SalesRep_ID == 100
    #ShowAcct == Y
    #ShowAdvanced == Y
    #ShowTrl == Y
    #StdPrecision == 2
    #SysAdmin == Y
    #UniqueKeyActive == N
    #User_Level == CO
    #User_Org == 0,1010053
    #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
    $FactAcctBalanceActive == Y
    $HasAlias == Y
    0|C_Currency_ID == 118
    0|WindowName == Menú
    1110|Find_Table_ID == 318
    1113|1113|AD_User_ID == 0
    1113|1113|C_BPartner_ID == 1012392
    1113|1113|C_BPartner_Location_ID == 1012404
    3|0|AD_Tab_ID == 220
    3|0|AD_Table_ID == 291
    3|0|AccessLevel == 3
    3|0|IsActive == Y
    3|0|Name == Entidad Comercial
    3|0|SQL == SELECT C_BPartner_ID,M_PriceList_ID,PO_PriceList_ID,M_DiscountSchema_ID,PO_DiscountSchema_ID,C_POSPaymentMedium_ID,PaymentRule,PaymentRulePO,C_BankAccount_ID,NAICS,CreditSituation,program_amt_used,Goal,min_order_qty,program_amt,CopyVendorProducts,UpdateBalance,A_Name_Check,ProcessPO,AD_OrgBP_ID,FlatDiscount,C_Location_ID,Rating,Emitir_Mi_Pyme,AD_ComponentObjectUID,isiso,SendEMail,paymentblocked,IsTaxExempt,TotalOpenBalance,StartHolidays,EndHolidays,EndHolidays2,StartHolidays2,ActualLifeTimeValue,CreditMinimumAmt,SO_CreditUsed,paymentblockeddescr,IsGroupInvoices,SO_Description,IsDiscountPrinted,IsCompoundtax,POReference,IsOneTime,IsSummary,IsSalesRep,ReferenceNo,AutomaticCreditNotes,IsMandatoryCAI,ShareOfCustomer,C_Dunning_ID,C_JobCategory_ID,ShelfLifeMinPct,C_PaymentTerm_ID,C_Greeting_ID,C_InvoiceSchedule_ID,DocumentCopies,M_Shipper_ID,Invoice_PrintFormat_ID,BPartner_Parent_ID,PO_PaymentTerm_ID,AD_Language,SalesRep_ID,InvoiceRule,FreightCostRule,DeliveryRule,Batch_Payment_Rule,SecondaryCreditStatus,NumberEmployees,DiscountContext,SOCreditStatus,CustomerType,DeliveryViaRule,MinimumPurchasedAmt,SO_CreditLimit,AD_Client_ID,AD_Org_ID,Value,Name,Name2,Description,IIBBType,IIBB,IsConvenioMultilateral,C_Region_Sede_ID,C_Categoria_Iva_ID,IsActive,TaxIdType,TrxEnabled,TaxID,C_BP_Group_ID,URL,IsProspect,SearchUnallocatedPayments,BuiltCabaJurisdiction,PotentialLifeTimeValue,AcqusitionCost,IsMultiCUIT,SalesVolume,FirstSale,IsCustomer,AllowAdvancedPaymentReceipts,IsVendor,IsEmployee,AllowPartialPayment,CopyFrom,Created,CreatedBy,Updated,UpdatedBy FROM C_BPartner WHERE C_BPartner.AD_Client_ID IN(0,1010016) AND C_BPartner.AD_Org_ID IN(0,1010053) ORDER BY Value
    3|10|AD_Tab_ID == 1000163
    3|10|AD_Table_ID == 1000143
    3|10|AccessLevel == 3
    3|10|LinkColumnName == C_BPartner_Retencion_ID
    3|10|Name == Período de Excepción
    3|11|AD_Tab_ID == 1010371
    3|11|AD_Table_ID == 1010373
    3|11|AccessLevel == 3
    3|11|LinkColumnName == C_BPartner_ID
    3|11|Name == Pagos Electrónicos
    3|12|AD_Tab_ID == 1010455
    3|12|AD_Table_ID == 1010465
    3|12|AccessLevel == 3
    3|12|LinkColumnName == C_BPartner_ID
    3|12|Name == CAI
    3|13|AD_Tab_ID == 225
    3|13|AD_Table_ID == 291
    3|13|AccessLevel == 3
    3|13|LinkColumnName == C_BPartner_ID
    3|13|Name == Empleado
    3|14|AD_Tab_ID == 226
    3|14|AD_Table_ID == 298
    3|14|AccessLevel == 3
    3|14|LinkColumnName == C_BPartner_ID
    3|14|Name == Cuenta Bancaria
    3|15|AD_Tab_ID == 222
    3|15|AD_Table_ID == 293
    3|15|AccessLevel == 3
    3|15|LinkColumnName == C_BPartner_ID
    3|15|Name == Localización
    3|16|AD_Tab_ID == 496
    3|16|AD_Table_ID == 114
    3|16|AccessLevel == 3
    3|16|LinkColumnName == C_BPartner_ID
    3|16|Name == Contacto (Usuario)
    3|17|AD_Tab_ID == 439
    3|17|AD_Table_ID == 528
    3|17|AccessLevel == 3
    3|17|LinkColumnName == AD_User_ID
    3|17|Name == Area de Interés
    3|1|AD_Tab_ID == 223
    3|1|AD_Table_ID == 291
    3|1|AccessLevel == 3
    3|1|IsActive == Y
    3|1|LinkColumnName == C_BPartner_ID
    3|1|Name == Cliente
    3|1|SQL == SELECT C_BPartner_ID,PO_PriceList_ID,PO_DiscountSchema_ID,AD_ComponentObjectUID,DiscountContext,IsConvenioMultilateral,TaxIdType,CustomerType,DeliveryViaRule,FreightCostRule,IIBBType,FirstSale,SO_CreditUsed,MinimumPurchasedAmt,ActualLifeTimeValue,PotentialLifeTimeValue,DocumentCopies,ShelfLifeMinPct,SalesVolume,ShareOfCustomer,NumberEmployees,IIBB,URL,Rating,Description,DUNS,POReference,paymentblockeddescr,NAICS,A_Name_Check,TaxID,Name2,ReferenceNo,PaymentRulePO,C_BankAccount_ID,AcqusitionCost,min_order_qty,Goal,program_amt_used,program_amt,ProcessPO,CopyVendorProducts,AD_OrgBP_ID,CopyFrom,C_Location_ID,IsCompoundtax,IsMultiCUIT,IsProspect,IsSummary,AllowPartialPayment,AllowAdvancedPaymentReceipts,paymentblocked,SearchUnallocatedPayments,BuiltCabaJurisdiction,Emitir_Mi_Pyme,IsMandatoryCAI,IsOneTime,IsSalesRep,isiso,IsVendor,IsDiscountPrinted,IsTaxExempt,IsEmployee,SendEMail,TrxEnabled,C_Greeting_ID,C_BP_Group_ID,C_Dunning_ID,C_JobCategory_ID,C_InvoiceSchedule_ID,M_Shipper_ID,C_Categoria_Iva_ID,PO_PaymentTerm_ID,AD_Language,BPartner_Parent_ID,Invoice_PrintFormat_ID,Batch_Payment_Rule,AD_Client_ID,AD_Org_ID,Value,Name,IsActive,IsCustomer,SalesRep_ID,DeliveryRule,InvoiceRule,M_PriceList_ID,M_DiscountSchema_ID,FlatDiscount,PaymentRule,C_PaymentTerm_ID,C_POSPaymentMedium_ID,SOCreditStatus,SecondaryCreditStatus,SO_CreditLimit,CreditMinimumAmt,TotalOpenBalance,UpdateBalance,CreditSituation,IsGroupInvoices,AutomaticCreditNotes,SO_Description,StartHolidays,EndHolidays,StartHolidays2,EndHolidays2,Created,CreatedBy,Updated,UpdatedBy FROM C_BPartner WHERE C_BPartner_ID=1012397 AND C_BPartner.AD_Client_ID IN(0,1010016) AND C_BPartner.AD_Org_ID IN(0,1010053) ORDER BY Name
    3|2|AD_Tab_ID == 1010250
    3|2|AD_Table_ID == 1010246
    3|2|AccessLevel == 3
    3|2|LinkColumnName == C_BPartner_ID
    3|2|Name == Excepciones de Crédito
    3|3|AD_Tab_ID == 1010292
    3|3|AD_Table_ID == 1010287
    3|3|AccessLevel == 3
    3|3|LinkColumnName == C_BPartner_ID
    3|3|Name == Percepción
    3|4|AD_Tab_ID == 1010293
    3|4|AD_Table_ID == 1010288
    3|4|AccessLevel == 3
    3|4|LinkColumnName == C_BPartner_ID
    3|4|Name == Exención de Percepciones
    3|5|AD_Tab_ID == 212
    3|5|AD_Table_ID == 183
    3|5|AccessLevel == 3
    3|5|LinkColumnName == C_BPartner_ID
    3|5|Name == Contabilidad del Cliente
    3|6|AD_Tab_ID == 224
    3|6|AD_Table_ID == 291
    3|6|AccessLevel == 3
    3|6|LinkColumnName == C_BPartner_ID
    3|6|Name == Proveedor
    3|7|AD_Tab_ID == 1000101
    3|7|AD_Table_ID == 210
    3|7|AccessLevel == 3
    3|7|LinkColumnName == C_BPartner_ID
    3|7|Name == Artículos del proveedor
    3|8|AD_Tab_ID == 213
    3|8|AD_Table_ID == 185
    3|8|AccessLevel == 3
    3|8|LinkColumnName == C_BPartner_ID
    3|8|Name == Contabilidad del Proveedor
    3|9|AD_Tab_ID == 1000162
    3|9|AD_Table_ID == 1000144
    3|9|AccessLevel == 3
    3|9|LinkColumnName == C_BPartner_ID
    3|9|Name == Retenciones
    3|AD_Client_ID == 1010016
    3|AD_Language == es_AR
    3|AD_Org_ID == 1010053
    3|AcqusitionCost == 0.0000
    3|ActualLifeTimeValue == 0.00
    3|AllowAdvancedPaymentReceipts == Y
    3|AllowPartialPayment == Y
    3|AutoCommit == Y
    3|AutomaticCreditNotes == Y
    3|BaseTable_ID == 291
    3|Batch_Payment_Rule ==
    3|BuiltCabaJurisdiction == N
    3|C_BP_Group_ID == 1010290
    3|C_BPartner_ID == 1012397
    3|C_Categoria_Iva_ID == 1010238
    3|C_PaymentTerm_ID == 1010329
    3|CopyFrom == Y
    3|CopyVendorProducts == N
    3|Created == 2022-05-02 19:12:09.6821
    3|CreatedBy == 100
    3|CreditMinimumAmt == 0.00
    3|DUNS ==
    3|DeliveryRule == F
    3|DiscountContext == B
    3|DocumentCopies == 0
    3|Emitir_Mi_Pyme == N
    3|FlatDiscount == 0.000000
    3|Goal == 0
    3|InvoiceRule == I
    3|IsActive == Y
    3|IsCompoundtax == N
    3|IsCustomer == Y
    3|IsDiscountPrinted == N
    3|IsEmployee == N
    3|IsGroupInvoices == N
    3|IsMandatoryCAI == N
    3|IsMultiCUIT == N
    3|IsOneTime == N
    3|IsProspect == N
    3|IsSOTrx == Y
    3|IsSalesRep == N
    3|IsSummary == N
    3|IsTaxExempt == N
    3|IsVendor == N
    3|M_PriceList_ID == 1010596
    3|MinimumPurchasedAmt == 0E-9
    3|Name == YAMIL RICARDO DANIEL
    3|NumberEmployees == 0
    3|PaymentRule == P
    3|PotentialLifeTimeValue == 0.00
    3|ProcessPO == N
    3|SOCreditStatus == S
    3|SO_CreditLimit == 120000.00
    3|SO_CreditUsed == 0.00
    3|SalesRep_ID == 1010964
    3|SalesVolume == 0
    3|SearchUnallocatedPayments == Y
    3|SecondaryCreditStatus == FN
    3|SendEMail == N
    3|ShareOfCustomer == 0
    3|ShelfLifeMinPct == 0
    3|TotalOpenBalance == 65350.84
    3|TrxEnabled == Y
    3|UpdateBalance == N
    3|Updated == 2022-07-19 17:40:59.8666
    3|UpdatedBy == 100
    3|Value == 1003
    3|WindowName == Entidades Comerciales
    3|isiso == N
    3|min_order_qty == 0.0000
    3|paymentblocked == N
    3|program_amt == 0.0000
    3|program_amt_used == 0.0000
    4|AutoCommit == Y
    4|IsSOTrx == Y
    5|AD_Org_ID == 1010053
    5|C_BPartner_ID == 1012397
    5|C_Currency_ID == 118
    5|ConsolidateDocument == Y
    5|DateInvoiced == 2022-07-19 00:00:00
    5|DocAction == CO
    5|IsSOTrx == Y
    5|PaymentRule == P
    5|WindowName == Recibos de Clientes
    7|C_BPartner_ID == 1012424
    7|C_Currency_ID == 118
    7|IsSOTrx == Y
    7|PaymentRule == P
    7|WindowName == Recibos de Clientes
    8|IsSOTrx == Y
    8|WindowName == Asignación de Cobros y Pagos
    9|0|AD_Tab_ID == 263
    9|0|AD_Table_ID == 318
    9|0|AccessLevel == 1
    9|0|IsActive == Y
    9|0|Name == Factura
    9|0|Processed == Y
    9|0|SQL == SELECT C_Invoice_ID,C_POSJournal_ID,AuthCode,FiscalAlreadyPrinted,C_Payment_ID,Processed,Processing,AuthMatch,IsSOTrx,IsTransferred,InitialCurrentAccountAmt,IsPrinted,IsTaxIncluded,C_CashLine_ID,NotExchangeableCredit,ManageDragOrderDiscounts,IsExchange,IsVoidable,DateRecepted,SkipIPNoCaeValidation,NumeroDeDocumento,IsInDispute,IsDiscountPrinted,IsPayScheduleValid,DateAcct,TotalLines,OldGrandTotal,M_AuthorizationChain_ID,(SELECT dt.docsubtypeinv FROM C_DocType dt WHERE dt.C_DocType_ID = C_Invoice.C_DocTypeTarget_ID) AS docsubtypeinv,IsCopy,Ref_Invoice_ID,DatePrinted,IsApproved,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,ImportClearance,IsSelfService,SendEMail,FechadeTCparaActualizarPrecios,GenerateTo,C_Region_Delivery_ID,ManualDocumentNo,C_Region_ID,M_RMA_ID,TipoComprobante,IsActive,(SELECT pl.actualizarpreciosconfacturadecompra FROM M_PriceList pl WHERE pl.M_PriceList_ID = C_Invoice.M_PriceList_ID) AS ActualizarPreciosConFacturaDeCompra,Authorize,M_AuthorizationChain_ID,AuthorizationChainStatus,ManageDragOrderSurcharges,(SELECT pl.c_Currency_ID FROM M_PriceList pl WHERE pl.M_PriceList_ID = C_Invoice.M_PriceList_ID) AS PriceListCurrency,M_InOutTransport_ID,OldGrandTotal,C_Order_Orig_ID,(SELECT pl.actualizarpreciosconfacturadecompra FROM M_PriceList pl WHERE pl.M_PriceList_ID = C_Invoice.M_PriceList_ID) AS ActualizarPreciosConFacturaDeCompra,M_AuthorizationChain_ID,AuthorizationChainStatus,Authorize,ManageDragOrderSurcharges,OldGrandTotal,C_Order_Orig_ID,(SELECT pl.c_Currency_ID FROM M_PriceList pl WHERE pl.M_PriceList_ID = C_Invoice.M_PriceList_ID) AS PriceListCurrency,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,ApplyPercepcion,OrigInvTipo,OrigInvFecha,OrigInvPtoVta,OrigInvNro,DateInvoiced,C_BPartner_ID,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,CreateCashLine,CreateFrom,C_POSPaymentMedium_ID,C_POSPaymentMedium_Credit_ID,C_Project_ID,C_Activity_ID,C_Campaign_ID,AD_OrgTrx_ID,User1_ID,User2_ID,ManualGeneralDiscount,NetAmount,GrandTotal,DocStatus,C_DocType_ID,CopyFrom,DocAction,Posted,IsPaid,CAI,DateCAI,Authorize,cae,AuthorizationChainStatus,caeerror,M_InOutTransport_ID,M_InOutTransport_ID,DeliveryViaRule,PrintType,ManageElectronicInvoice,Created,CreatedBy,Updated,UpdatedBy FROM C_Invoice WHERE IsSOTrx=’Y’ AND UPPER(DocumentNo) LIKE ‘%510%’ AND C_Invoice.AD_Client_ID IN(0,1010016) AND C_Invoice.AD_Org_ID IN(0,1010053) ORDER BY DocumentNo DESC
    9|1|AD_Tab_ID == 270
    9|1|AD_Table_ID == 333
    9|1|AccessLevel == 1
    9|1|LinkColumnName == C_Invoice_ID
    9|1|Name == Línea de la Factura
    9|2|AD_Tab_ID == 271
    9|2|AD_Table_ID == 334
    9|2|AccessLevel == 1
    9|2|LinkColumnName == C_Invoice_ID
    9|2|Name == Impuesto de la Factura
    9|3|AD_Tab_ID == 460
    9|3|AD_Table_ID == 551
    9|3|AccessLevel == 1
    9|3|LinkColumnName == C_Invoice_ID
    9|3|Name == Programa de Pagos
    9|4|AD_Tab_ID == 1010235
    9|4|AD_Table_ID == 1010230
    9|4|AccessLevel == 3
    9|4|LinkColumnName == C_Invoice_ID
    9|4|Name == Descuentos / Recargos
    9|99|FindSQL == SELECT COUNT(*) FROM C_Invoice WHERE IsSOTrx=’Y’ AND UPPER(DocumentNo) LIKE ‘%510%’ AND AD_Client_ID IN(0,1010016) AND AD_Org_ID IN(0,1010053)
    9|AD_Client_ID == 1010016
    9|AD_Org_ID == 1010053
    9|ActualizarPreciosConFacturaDeCompra == N
    9|ApplyPercepcion == Y
    9|AuthMatch == N
    9|Authorize == N
    9|AutoCommit == Y
    9|BaseTable_ID == 318
    9|C_BPartner_ID == 1012424
    9|C_BPartner_Location_ID == 1012436
    9|C_ConversionType_ID == 114
    9|C_Currency_ID == 118
    9|C_DocTypeTarget_ID == 1010793
    9|C_DocType_ID == 1010793
    9|C_Invoice_ID == 1022558
    9|C_Order_ID == 1014774
    9|C_PaymentTerm_ID == 1010329
    9|C_Region_ID == 1000027
    9|ChargeAmt == 0.00
    9|CodigoCategoriaIVA == 1
    9|CopyFrom == N
    9|CreateCashLine == Y
    9|CreateFrom == Y
    9|Created == 2022-07-19 10:00:11.2488
    9|CreatedBy == 100
    9|DateAcct == 2022-07-19 00:00:00
    9|DateInvoiced == 2022-07-19 10:00:11
    9|DateOrdered == 2022-07-19 00:00:00
    9|DeliveryViaRule == P
    9|DocAction == CL
    9|DocBaseType == ARI
    9|DocStatus == CO
    9|DocTypeKey == CIC0001
    9|DocumentNo == C000100000510
    9|Find_Table_ID == 318
    9|FiscalAlreadyPrinted == N
    9|GenerateTo == N
    9|GrandTotal == 3673.85
    9|HasCharges == N
    9|InitialCurrentAccountAmt == 3673.85
    9|IsActive == Y
    9|IsApproved == Y
    9|IsCopy == N
    9|IsDiscountPrinted == N
    9|IsExchange == N
    9|IsInDispute == N
    9|IsPaid == N
    9|IsPayScheduleValid == Y
    9|IsPrinted == N
    9|IsSOTrx == Y
    9|IsSelfService == N
    9|IsTaxIncluded == Y
    9|IsTransferred == N
    9|IsVoidable == N
    9|M_PriceList_ID == 1010595
    9|ManageDragOrderDiscounts == N
    9|ManageDragOrderSurcharges == N
    9|ManageElectronicInvoice == N
    9|ManualDocumentNo == N
    9|ManualGeneralDiscount == 0.00
    9|NetAmount == 3673.85
    9|NotExchangeableCredit == N
    9|NumeroComprobante == 510
    9|NumeroDeDocumento == <C000100000510>
    9|OldGrandTotal == 0.00
    9|OrigInvNro == 0
    9|OrigInvPtoVta == 0
    9|PaymentRule == S
    9|Posted == N
    9|PriceListCurrency == 118
    9|Processed == Y
    9|Processing == N
    9|PuntoDeVenta == 0
    9|SalesRep_ID == 1010964
    9|SendEMail == N
    9|SkipIPNoCaeValidation == N
    9|TotalLines == 3673.85
    9|UpdateOrderQty == N
    9|Updated == 2022-07-19 10:00:25.1005
    9|UpdatedBy == 100
    9|WindowName == Factura (clientes)
    9|docsubtypeinv == NF
    AutoCommit == Y
    C_Currency_118 == ARS
    P1010098|InventoryKind == IO
    P103|Type == S
    P143|C_DocTypeTarget_ID == 1010532
    P143|M_Warehouse_ID == 1010048
    P167|C_DocTypeTarget_ID == 1010793
    P181|C_DocTypeTarget_ID == 1010524
    P181|M_Warehouse_ID == 1010048
    P181|SalesRep_ID == 1010717
    P184|C_DocType_ID == 1010521
    P184|M_Warehouse_ID == 1010048
    P189|DataType == S
    P|AD_FTDoc == 1002145
    P|AllowExchangeDifference == 0.01
    P|AuditReferenceCurrencyISOCode == USD
    P|C_DocType_ID == 1010522
    P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
    P|C_Region_ID_FACTURA_ARCIBA == 1000082
    P|CategoriaIVA_LeyendaFiscal_5 == Crédito fiscal computable solo a efectos de la Ley Nº 27.618.
    P|CentralPosBaseURL == https://liquidacion.centralpos.com/api/v1
    P|CentralPosEmail == usuario@server.net
    P|CentralPosPageSize == 100
    P|CentralPosPassword == unPassword
    P|ConversationSecurityPolicy == E
    P|DIF_CAMBIO_ARTICULO == DIFCAMBIO
    P|DIF_CAMBIO_PTO_VENTA == 1
    P|DIF_CAMBIO_TARIFA_CREDITO == DIF_DE_CAMBIO_CREDITO
    P|DIF_CAMBIO_TARIFA_DEBITO == DIF_DE_CAMBIO_DEBITO
    P|DeclaracionValores_FilterProductValues == RECUPERO;RECHAZO
    P|DocAction == CO
    P|EmailValidControl_BPLocation == V
    P|EmailValidControl_User == V
    P|FindAddEndWildcard_Description == N
    P|FindAddEndWildcard_Documentno == N
    P|FindAddEndWildcard_Name == N
    P|FindAddEndWildcard_Value == N
    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|LogTransactionEvents == N
    P|LookupMaxRowsAllowed == 1000
    P|MProductPO_UniqueVendorProductNo == N
    P|Maintenance_Inventory == 6
    P|MantenimientoPadron == 3
    P|MultiOrgTransactionFilterRulesPropertiesFileLocation == /ServidorOXP/utils/replicacion/filters/MultiOrgTransactionFilterRules.properties
    P|NCFiscal_ComprobanteOriginal_ClaveTiposDocumentoPedido == SOSOTD;SOSOTH
    P|OpenTrxLowerLimit == 6
    P|OpenTrxTimeOutMS == 3600000
    P|OpenTrxUpperLimit == 10
    P|POSCashJounal_ValidDiff == 0.5
    P|PathPadronCSV == C:\\Padron\\
    P|PorcentajeDeAumentoDePrecio == 100
    P|ReasonVoid == Anulación
    P|RejectedCheckDocTypeKey_Sales == RCD
    P|ReplicationEventsActive == Y
    P|SeparadorDeCampoEnCSVPadron == ;
    P|Show_Status_Bar_Info_Sales_Invoice == Y
    P|SinPercepcionNCManual == ‘N’
    P|SkipColumnsFilterRulesPropertiesFileLocation == /ServidorOXP/utils/replicacion/filters/SkipColumnsFilterRules.properties
    P|TransferDueDateDays == 1
    P|URL_IMAGE_OP == URL_IMAGE_OP
    P|URL_IMAGE_RC == URL_IMAGE_RC
    P|VAllocation_LoginOrgTrx == N
    P|WAIT_FOR_WORKER_SECONDS == 0
    P|WSFEX_PROVIDER_CLASS == org.libertya.locale.ar.electronicInvoice.utils.LYEIWSFEX
    P|WSFE_PROVIDER_CLASS == org.libertya.locale.ar.electronicInvoice.utils.LYEIWSFE
    java.naming.provider.url == jnp://localhost1: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:\Users\feded\AppData\Local\Temp\temp16.jar;C:\ServidorOXP\.\lib\batik-awt-util.jar;C:\ServidorOXP\.\lib\batik-dom.jar;C:\ServidorOXP\.\lib\batik-svggen.jar;C:\ServidorOXP\.\lib\batik-util.jar;C:\ServidorOXP\.\lib\batik-xml.jar;C:\ServidorOXP\.\lib\CMPCS.jar;C:\ServidorOXP\.\lib\JasperReports.jar;C:\ServidorOXP\.\lib\jboss.jar;C:\ServidorOXP\.\lib\jsp-api-2.0.jar;C:\ServidorOXP\.\lib\oracle.jar;C:\ServidorOXP\.\lib\OXP.jar;C:\ServidorOXP\.\lib\OXPApps.jar;C:\ServidorOXP\.\lib\OXPInstall.jar;C:\ServidorOXP\.\lib\OXPRoot.jar;C:\ServidorOXP\.\lib\OXPSLib.jar;C:\ServidorOXP\.\lib\OXPXLib.jar;C:\ServidorOXP\.\lib\postgresql.jar;C:\ServidorOXP\.\lib\sqlj.jar;C:\ServidorOXP\.\lib\sqlServer.jar;C:\ServidorOXP\.\lib\sybase.jar;C:\ServidorOXP\.\lib\XOXPTools.jar;C:\ServidorOXP\.\lib\swing-layout-1.0.jar;C:\ServidorOXP\.\lib\PDFRenderer.jar;C:\ServidorOXP\.\lib\JasperReports.jar;
    java.class.version=52.0
    java.endorsed.dirs=C:\Java\jdk1.8.0_131\jre\lib\endorsed
    java.ext.dirs=C:\Java\jdk1.8.0_131\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
    java.home=C:\Java\jdk1.8.0_131\jre
    java.io.tmpdir=C:\Users\feded\AppData\Local\Temp\
    java.library.path=C:\Java\jdk1.8.0_131\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\PostgreSQL\9.5bin;C:\Java\jdk1.8.0_131\bin;C:\Java\jdk1.8.0_131\jre\bin;C:\Java\jdk1.8.0_131\jre\bin\client;C:\PostgreSQL\9.5\bin;C:\Users\feded\AppData\Local\Microsoft\WindowsApps;;.
    java.runtime.name=Java(TM) SE Runtime Environment
    java.runtime.version=1.8.0_131-b11
    java.specification.name=Java Platform API Specification
    java.specification.vendor=Oracle Corporation
    java.specification.version=1.8
    java.vendor=Oracle Corporation
    java.vendor.url=http://java.oracle.com/
    java.vendor.url.bug=http://bugreport.sun.com/bugreport/
    java.version=1.8.0_131
    java.vm.info=mixed mode
    java.vm.name=Java HotSpot(TM) Client VM
    java.vm.specification.name=Java Virtual Machine Specification
    java.vm.specification.vendor=Oracle Corporation
    java.vm.specification.version=1.8
    java.vm.vendor=Oracle Corporation
    java.vm.version=25.131-b11
    line.separator=

    os.arch=x86
    os.name=Windows 10
    os.version=10.0
    path.separator=;
    sun.arch.data.model=32
    sun.awt.enableExtraMouseButtons=true
    sun.boot.class.path=C:\Java\jdk1.8.0_131\jre\lib\resources.jar;C:\Java\jdk1.8.0_131\jre\lib\rt.jar;C:\Java\jdk1.8.0_131\jre\lib\sunrsasign.jar;C:\Java\jdk1.8.0_131\jre\lib\jsse.jar;C:\Java\jdk1.8.0_131\jre\lib\jce.jar;C:\Java\jdk1.8.0_131\jre\lib\charsets.jar;C:\Java\jdk1.8.0_131\jre\lib\jfr.jar;C:\Java\jdk1.8.0_131\jre\classes
    sun.boot.library.path=C:\Java\jdk1.8.0_131\jre\bin
    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=
    suppressSwingDropSupport=true
    user.country=AR
    user.dir=C:\ServidorOXP
    user.home=C:\Users\feded
    user.language=es
    user.name=feded
    user.script=
    user.timezone=America/Buenos_Aires
    user.variant=

    #65370
    Federico Cristina
    Superadministrador

    Buenas,

    Gracias por la info. Estaremos analizando el inconveniente.

    Simplemente para confirmar: estás utilizando LY 22.0, verdad? En la ventana Configuración de Descuentos existe alguna entrada o no hay registros allí configurados?

    Saludos!
    Federico

    #65371
    DNG
    Participante

    Hola, gracias por responder!!!

    te confirmo que si, estoy usando LY 22.0 y no hay descuentos cargados.

    desde que actualice ya no me salieron las facturas para cargar el recibo

    aguardo sus comentarios.

    gracias!!!

    • Esta respuesta fue modificada hace 2 años, 4 meses por DNG.
    #65377
    DNG
    Participante

    Hola, cargue los descuentos ya hora si me aparecen los comprobantes, muchas gracias!!!

    #65381
    Federico Cristina
    Superadministrador

    Buenas, perfecto entonces! Gracias por el feedback!

    #65453
    dbravo
    Participante

    Hola, estoy teniendo el mismo inconveniente después de migrar de V21 a V22, no me aparecen las facturas pendientes de cobro
    Veo que DNG resolvió el problema cargando los descuentos. Dónde se cargan esos descuentos?.

    Gracias por la ayuda
    Daniel

    #65454
    Jorge Matulich
    Participante

    Buen día Daniel

    Deberías conectarte con perfil de Administración e ir a Tarifas – Configuración de Descuentos.

    Saludos

    Jorge Matulich

    #65459
    dbravo
    Participante

    Hola Jorge, muchas gracias por la respuesta.
    Ingresé con perfil Administrador a Tarifas–Configuración de Descuentos, pero en un campo me pide “Cargo para Dtos”. Despliega una ventana vacía y no me permite ingresar cargos manualmente, y ésto me impide confirmar el Descuento.
    Te agradeceré si me podés ayudar a ver qué estoy haciendo mal.
    Gracias!!!
    Daniel

    #65460
    dbravo
    Participante

    Encontré un bug fix por este tema https://sourceforge.net/projects/libertya/files/libertya/dev/support/22.0/rc/
    Me podrán indicar como instalarlo? Desde instalador de componentes?

    Gracias!
    Daniel

    org.libertya.core.support.r3020_ReciboDeClientes.jar

    #65461
    Ignacio Aita
    Participante

    Daniel, buenas tardes.

    El parche publicado al que haces referencia es solo de código, es decir, no requiere la instalación con el Instalador de Componentes. Es suficiente con copiar el archivo .jar descargado en la carpeta /lib/plugins del directorio raiz de Libertya (ServidorOPX) y reconfigurar el proyecto.

    Es importante tener en cuenta que si utilizás el Cliente de Escritorio de Libertya en otros equipos que no sean el servidor, se deben actualizar los clientes. Si utilizás el cliente Liviano o LBYStart, esto se realiza automáticamente, pero si es un cliente pesado hay que actualizarlo manualmente.

    Cualquier consulta quedo a disposición, saludos.-

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