- Este debate está vacío.
-
AutorEntradas
-
31 mayo, 2013 a las 11:56 pm #32379Sebastián GurpeguiMiembro
Estimados,
Estoy teniendo un inconveniente al darle al tilde verde en la ventana “Cuentas de Sugar” dentro de un presupuesto de un cliente que estoy creando.
Logra levantarme las cuentas que tengo en SugarCRM, con lo cual desde ese lado descarto un problema en la comunicación entre ambos programas.
Una vez que completo los datos de CUIT y demás en la ventana a la cual hago referencia, hago click en el tilde verde y me salta el mensajeCode:Entidad Comercial no guardada
Al ingresar un el campo Nro. Identificación se requiere completar el campo Tipo de Identificación.Y luego en el presupuesto está como nuevo, sin datos del cliente cargado.
Les comento que tengo algunas EC ya creadas y me pregunto si eso es lo que me está generando conflicto.
Por otro lado, la inclusión del campo auto-incremental en la DB opportunities de SugarCRM la hice con un query desde MSSQL y luego modificando el archivo vardefs.php. Este método lo encontré googleando ya que no daba con una respuesta.Les adjunto el traceinfo de Libertya donde figura el error, haciendo referencia a que no encuentra el ID de la empresa en la tabla de organizaciones.
Code:——————————-
17:43:08.740 OpenXpertya.startup: Libertya (r) Versión 13.01_21-01-2013 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 13.01 20130531-1635 – ${env.CONSULTORA_OXP}
17:43:08.740 OpenXpertya.startup: ServidorOXP – Java HotSpot(TM) Client VM 20.4-b02 – Windows Server 2008 6.0 Service Pack 2
===========> MBPartner.getBPartnerCashTrx: Not found for AD_Client_ID=1010016 [11]
——————————-
===========> MBPartner.saveError: SaveError – Al ingresar un el campo Nro. Identificación se requiere completar el campo Tipo de Identificación. [11]Servidor = localhost : 1099 (21-01-2013)
Tunnel=false, Objects=false, Process=false
Base de datos = main : 5432 / libertya
Esquema = libertya
Usuario = sgurpegui
Perfil = Ventas
Compañía = Transaction Line SRL
Organización = Default
Fecha = 2013-05-31 00:00:00
Impresora = CutePDF Writer
Implementation-Vendor = SERVICIOS_DIGITALES
Implementation-Title = CCTools Libertya
Implementation-Version = Libertya 20130124-0921
Specification-Vendor = (C) 2005-2006 FUNDESLE.
Specification-Title = Herramientas de Cliente oxp
Implementation-URL = http://www.openxpertya.org
Specification-Version = Libertya
OXPHome = ServidorOXP
Language=[Español (Argentina),Locale=es_AR,AD_Language=es_AR,DatePattern=DD.MM.YYYY,DecimalPoint=false]
MClient[1010016-TLine]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 20.4-b02
Windows Server 2008 6.0 Service Pack 2
=== Environment === 403368704
Libertya (r) Versión 13.01_21-01-2013 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 13.01 20130531-1635 – ${env.CONSULTORA_OXP}
main/192.168.1.16
CConnection[name=localhost{main-libertya-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=main,DBport=5432,DBname=libertya,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=Transaction01!]
Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 9.0 JDBC4 (build 801) – via DataSource
DB_PostgreSQL[jdbc:postgresql://main:5432/libertya?encoding=UTF-8]
AppsServerOK=true, DatabaseOK=true=== Context ===
#AD_Client_ID == 1010016
#AD_Client_Name == Transaction Line SRL
#AD_Language == es_AR
#AD_Org_ID == 1010053
#AD_Org_Name == Default
#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 == 1027934
#AD_User_ID == 1010735
#AD_User_Name == sgurpegui
#C_BP_Group_ID == 1010045
#C_BankAccount_ID == 1010051
#C_ConversionType_ID == 114
#C_Country_ID == 119
#C_Letra_Comprobante_ID == 1010020
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010047
#C_Tax_ID == 1010084
#C_UOM_ID == 1000000
#CheckCuitControl == N
#Date == 2013-05-31 00:00:00
#GL_Category_ID == 1010098
#IsPOSJournalActive == N
#M_Locator_ID == 1010278
#M_PriceList_ID == 1010595
#M_Product_Category_ID == 1010146
#M_Product_Family_ID == 1010026
#M_Product_Lines_ID == 1010024
#M_Warehouse_ID == 1010048
#POSJournalSupervisor == Y
#PasswordExpirationActive == N
#PrintPreview == N
#Printer == CutePDF Writer
#SalesRep_ID == 1010735
#ShowAcct == N
#ShowAdvanced == Y
#ShowTrl == N
#StdPrecision == 2
#UniqueKeyActive == N
#User_Level == CO
#User_Org == 0,1010053
#YYYY == Y
$C_AcctSchema_ID == 1010016
$C_Currency_ID == 118
$Element_AC == Y
$Element_BP == Y
$Element_MC == Y
$Element_OO == Y
$Element_PJ == Y
$Element_PR == Y
$Element_SR == Y
$HasAlias == Y
0|WindowName == Menú
2|0|AD_Tab_ID == 186
2|0|AD_Table_ID == 259
2|0|AccessLevel == 1
2|0|IsActive == Y
2|0|Name == Pedido
2|0|Processed == N
2|0|SQL == SELECT C_Order_ID,IsActive,IsApproved,CreateVendorProductLines,IsCreditApproved,C_Repair_Order_ID,Bill_Location_ID,IsSelfService,Bill_BPartner_ID,Pay_BPartner_ID,IsDelivered,SendEMail,M_Shipper_ID,IsDropShip,repair_state,IsInvoiced,DateAcct,DatePrinted,dateprod,daterealprod,FreightAmt,IsPrinted,IsDiscountPrinted,IsTaxIncluded,C_CashLine_ID,POReference,Ref_Order_ID,PriorityRule,repair_priority,Processed,Processing,FreightCostRule,IsSelected,IsSOTrx,IsTransferred,Pay_Location_ID,DeliveryViaRule,M_Warehouse_Transfer_ID,IsTpvUsed,(SELECT COALESCE(C_DocType.AllowChangePriceList,’N’) FROM C_DocType WHERE C_Order.C_DocTypeTarget_ID = C_DocType.C_DocType_ID) AS AllowChangePriceList,Posted,IsExchange,AD_Org_Transfer_ID,(SELECT c.Codigo FROM C_BPartner bp, C_Categoria_IVA c WHERE C_Order.C_BPartner_ID = bp.C_BPartner_ID AND bp.C_Categoria_IVA_ID = c.C_Categoria_IVA_ID) AS CodigoCategoriaIVA,C_Payment_ID,OpportunityId,AD_Client_ID,AD_Org_ID,DocumentNo,Description,C_DocTypeTarget_ID,Acceptance,DateOrdered,ValidTo,DatePromised,C_BPartner_ID,C_BPartner_Location_ID,NombreCli,NroIdentificCliente,Invoice_Adress,CUIT,AD_User_ID,Bill_User_ID,DeliveryRule,M_Warehouse_ID,InvoiceRule,M_PriceList_ID,C_Currency_ID,C_ConversionType_ID,SalesRep_ID,C_Charge_ID,ChargeAmt,PaymentRule,C_PaymentTerm_ID,C_Project_ID,C_Activity_ID,C_Campaign_ID,AD_OrgTrx_ID,User1_ID,User2_ID,TotalLines,GrandTotal,OpportunityNo,DocStatus,C_DocType_ID,OpportunityName,CopyFrom,DocAction,Created,CreatedBy,Updated,UpdatedBy FROM C_Order WHERE IsSOTrx=’Y’ AND C_DocTypeTarget_ID NOT IN (SELECT C_DocType_id FROM C_DocType WHERE DocTypeKey IN (‘SOSOT’,’SOSOTD’)) AND (Processed=’N’ OR Updated>(current_timestamp-cast(cast(7 as text)|| ‘days’ as interval))) AND C_Order.AD_Client_ID IN(0,1010016) AND C_Order.AD_Org_ID IN(0,1010053) ORDER BY DocumentNo DESC
2|1|AD_Tab_ID == 187
2|1|AD_Table_ID == 260
2|1|AccessLevel == 1
2|1|LinkColumnName == C_Order_ID
2|1|Name == Línea del Pedido
2|2|AD_Tab_ID == 236
2|2|AD_Table_ID == 314
2|2|AccessLevel == 1
2|2|LinkColumnName == C_Order_ID
2|2|Name == Impuesto del Pedido
2|3|AD_Tab_ID == 1010234
2|3|Name == Descuentos / Recargos
2|AD_Client_ID == 1010016
2|AD_Org_ID == 1010053
2|Acceptance == 0
2|AllowChangePriceList == N
2|AutoCommit == Y
2|BaseTable_ID == 259
2|C_ConversionType_ID == 114
2|C_Currency_ID == 118
2|C_DocTypeTarget_ID == 1010531
2|C_DocType_ID == 0
2|C_PaymentTerm_ID == 1010083
2|ChargeAmt == 0
2|CodigoCategoriaIVA == 0
2|CopyFrom == N
2|CreateVendorProductLines == N
2|DateAcct == 2013-05-31 00:00:00
2|DateOrdered == 2013-05-31 00:00:00
2|DatePromised == 2013-05-31 00:00:00
2|DeliveryRule == A
2|DeliveryViaRule == P
2|DocAction == CO
2|DocStatus == DR
2|DocumentNo == <20000>
2|EnforcePriceLimit == N
2|FreightAmt == 0
2|FreightCostRule == I
2|GrandTotal == 0
2|HasCharges == N
2|InvoiceRule == D
2|IsActive == Y
2|IsApproved == N
2|IsCreditApproved == N
2|IsDelivered == N
2|IsDiscountPrinted == N
2|IsDropShip == N
2|IsExchange == N
2|IsInvoiced == N
2|IsPrinted == N
2|IsSOTrx == Y
2|IsSelected == N
2|IsSelfService == N
2|IsTaxIncluded == N
2|IsTpvUsed == N
2|IsTransferred == N
2|M_PriceList_ID == 1010595
2|M_PriceList_Version_ID == 1010527
2|M_Warehouse_ID == 1010048
2|OpportunityNo == 0
2|OrderType == ON
2|PaymentRule == P
2|Posted == N
2|PriorityRule == 5
2|Processed == N
2|Processing == N
2|SalesRep_ID == 1010735
2|SendEMail == N
2|TotalLines == 0
2|WindowName == Pedido de Clientes
AutoCommit == Y
P1010098|InventoryKind == IO
P103|Type == S
P189|DataType == S
P|AD_FTDoc == 1002145
P|AllowExchangeDifference == 0.01
P|AuditReferenceCurrencyISOCode == USD
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|DIF_CAMBIO_ARTICULO == 10000001
P|DIF_CAMBIO_PTO_VENTA == 1
P|InfoMaxRowsAllowed == 1000
P|InfoRowCountMethod == C
P|LOCAL_AR == Y
P|L_AR_CFMontoMaximo == 1000
P|L_AR_MaxOrderLineQty == 999
P|LookupMaxRowsAllowed == 1000
P|MantenimientoPadron == 3
P|OpenTrxLowerLimit == 6
P|OpenTrxTimeOutMS == 3600000
P|OpenTrxUpperLimit == 10
P|POSCashJounal_ValidDiff == 0.5
P|ReplicationEventsActive == Y
P|TransferDueDateDays == 1
P|WSFE == C:\pyafipws\
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:UsersSGURPE~1AppDataLocalTemp5temp5.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:Javajdk1.6.0_29jrelibendorsed
java.ext.dirs=C:Javajdk1.6.0_29jrelibext;C:WindowsSunJavalibext
java.home=C:Javajdk1.6.0_29jre
java.io.tmpdir=C:UsersSGURPE~1AppDataLocalTemp5
java.library.path=C:Javajdk1.6.0_29bin;C:WindowsSunJavabin;C:Windowssystem32;C:Windows;C:Program Files (x86)Windows Resource KitsTools;C:Program FilesCommon FilesMicrosoft SharedWindows Live;C:Program Files (x86)Common FilesMicrosoft SharedWindows Live;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:Javajdk1.6.0_29;C:Javajdk1.6.0_29bin;C:Javajre6binclient;C:Javajdk1.6.0_14bin;C:Javajdk1.6.0_14jrebin;C:Javajdk1.6.0_14jrebinclient;C:WindowsSystem32WindowsPowerShellv1.0;C:PostgreSQL8.3bin;C:Javajdk1.6.0_29bin;C:Javajdk1.6.0_29jrebin;C:Javajdk1.6.0_29jrebinclient;bin;C:Program Files (x86)Windows LiveShared;C:PROGRA~2SUGARC~1.13php;C:sugarcrmphp;C:Program Files (x86)Microsoft SQL Server90Toolsbinn;.
java.protocol.handler.pkgs=org.apache.axis.transport|
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 Server 2008
os.version=6.0
path.separator=;
sun.arch.data.model=32
sun.boot.class.path=C:Javajdk1.6.0_29jrelibresources.jar;C:Javajdk1.6.0_29jrelibrt.jar;C:Javajdk1.6.0_29jrelibsunrsasign.jar;C:Javajdk1.6.0_29jrelibjsse.jar;C:Javajdk1.6.0_29jrelibjce.jar;C:Javajdk1.6.0_29jrelibcharsets.jar;C:Javajdk1.6.0_29jrelibmodulesjdk.boot.jar;C:Javajdk1.6.0_29jreclasses
sun.boot.library.path=C:Javajdk1.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 2
suppressSwingDropSupport=true
user.country=AR
user.dir=C:UsersAdministradorAppDataRoamingMicrosoftWindowsStart MenuProgramsLibertya
user.home=\MainUsuariossgurpegui
user.language=es
user.name=sgurpegui
user.timezone=America/Buenos_Aires
user.variant=6 julio, 2013 a las 9:34 pm #37502AMEBISParticipanteHola, como andas?
Tambien estoy probando Sugar integrado con Libertya. Para el campo autoincremental te paso el siguiente link. Lo tenes que cargar como un modulo en Sugar.
Cualquier cosa me avisas y lo vemos.
Saludos
-
AutorEntradas
- Debes estar registrado para responder a este debate.