No muestra las facturas pendientes de cobro

Inicio Foros Foro principal Ayuda No muestra las facturas pendientes de cobro

Viendo 5 entradas - de la 1 a la 5 (de un total de 5)
  • 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 meses, 1 semana 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!

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