Libertya + SugarCRM

Inicio Foros Foro principal Ayuda Libertya + SugarCRM

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

    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 mensaje

    Code:
    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=

    #37502
    AMEBIS
    Participante

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

    https://www.libertya.org/download.php?file=componentes/campo_autoincremental_sugar_interface_V_0_92.zip

    Cualquier cosa me avisas y lo vemos.

    Saludos

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