No muestra las facturas pendientes de cobro

[DNG]

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=

[Federico Cristina]

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

[DNG]

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 1 año, 2 meses por DNG.

[DNG]

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

[Federico Cristina]

Buenas, perfecto entonces! Gracias por el feedback!

[dbravo]

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

[Jorge Matulich]

Buen día Daniel

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

Saludos

Jorge Matulich

[dbravo]

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

[dbravo]

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

[Ignacio Aita]

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.-

[Autor]

Entradas