• Author / Uploaded
• richardc1515

Citation preview

1) Instalar Outlook Integration Server. (En servidor) 2) Outlook Integration Standalone. (Cliente). Según la versión de Outlook. Puede ser desde el update o directamente desde los instaladores. 3) Abrir Outlook. Mirar la pestaña Complementos. 4) Entrar a SAP Business One. Gestion --> Addon --> Gestion de Addon -- > Instal ar que este instalado: Outlook Integration. Como cualquier otro Addon. 5) Ir a Addons Pendientes e instalarlo. 6) Salen mensajes de crear campos de usuario. 7) Gestion --> Addons --> Integration Outlook. 8) Entrar a Outlook. Entrada al sistema y colocar el nombre del servidor. SAP Bu siness One con exito. Grabar un correo electronico como actividad. Explicar la sincronizacion de contactos. Creacion de actividades con documnetos que se anexan. Sincronizacion de Tareas. Envio de Cotizaciones por outlook -- Ofertas. Explicar integracion con Word y Excel. Donde se pueden integrar como actividades . Prueba con base de datos de sanitas. --> Dashboard 1) Instalar B1 Integration Component 2) Revisar Event Server e Integration 3) SBO DI SERVER. Conection 4) Activar el Cockpit. y My Cockpit. 5) Ingresar a Integration Framework. 6) Entrar a SAP B1 y cambiar la clave nca caduce. Clave: SAPB1Admin 7) Dar clic en la pestaña SLD, elegir n a la base de datos. 8) Test Conection. 9)

Server. Usuario: B1iadmin Clave: GestionOne del usuario B1i e indicar la el chec de nu SBO-COMMON y editar los valores para conexio

3002877117 6GQJTA7JZ19CD9SSDQ74DRGHXE

SELECT T1.U_BPCO_TDC AS C1, T1.LicTradNum AS C2, T0.DocNum AS C3, -- Condicionar cuando con los saldos iniciales. --3 T0.CardName AS C4, --4 0 AS C5, --5 T0.DocDate AS C6, --6 T0.DocDueDate AS C7, --7 0 AS C8, --8 1 AS C9, --9 0 AS C10, --10 00000000 AS C11, --11 1 AS C12, --12 T0.[PaidToDate] AS C13, -- Revisar 0 pagada 1 al dia. --13 1 AS C14, --14 T0.[PaidToDate] AS C15, -- si esta al dia 01, 05 pago total, Si ya vencio es Al dia: Fecha Vto + 90 dias. --15 0 AS C16, --16 T0.DocDate AS C17, --17 T0.[PaidToDate] AS C18, -- 02 en otra columna. --18 '' AS C19, -- Fecha corte, --19

0 AS C20, --20 00000000 AS C21, --21 0 AS C22, --22 00000000 AS C23, --23 0 AS C24, --24 0 AS C25, --25 00000000000000000000000000000 AS C26, --26 1 AS C27, --27 1 AS C28, --28 00 AS C29, --29 000 AS C30, --30 T0.DocDate + 120 AS C31, --- edad de mora: fecha de factura + 120. Hasta la fe cha de corte --31 T0.DocTotal AS C32, --32 T0.PaidToDate AS C33, --33 T1.CreditLine - T0.PaidToDate AS C34, --34 T0.PaidToDate AS C35, --35 T0.DocDate + 120 AS C36,-- Fehca de factura + 120 --36, 1 AS C37, -- 37 T0.PaidToDate AS C38,-- Si el saldo es menor o igual a 0, colocar 1. --38 T0.PaidToDate AS C39, -- Cuentas en mora 1 si pago 0. --39 Opuesto a lo anterio r. 0 AS C40, --40 '' AS C41, -- 41 , T0.DocDate + 120 AS C42,-- Fehca de factura + 120 -- 42, 00000000 AS C43, --43 'LABORATORIO FARMAVIC S.A' AS C44, --44 'SOLEDAD' AS C45, -- 45 '08758' AS C46, -- 46 t1.U_BPCO_City AS C47, --47 T1.U_BPCO_CS AS C48, --48 T1.State1 AS C49, --49 T1.Address AS C50, --50 T1.Phone1 AS C51, --51 t1.U_BPCO_City AS C52, --52 T1.U_BPCO_CS AS C53, --53 T1.State1 AS C54, --54 T1.Address AS C55, --55 T1.Phone1 AS C56, --56 t1.U_BPCO_City AS C57, --57 T1.U_BPCO_CS AS C58, --58 T1.State1 AS C59, --59 T1.Address AS C60, --60 T1.E_Mail AS C61, --61 T1.Cellular AS C62, --62 '390316' AS C63, --63 '' AS C64, --64, '' AS C65, --65, '' AS C66 --66 FROM OINV T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode