Skip to Content
author's profile photo Former Member
Former Member

Monitoreo Evento

HOLA BUEN DIA,

solicito su apoyo para conocer cómo puedo activar un evento que envié un mail cuando se modifique un campo definido del usuario de un documento


GRACIAS

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 24, 2014 at 05:21 PM

    Buenas tardes Jorge,

    En el caso en que dispongas de la versión 9.0, la forma más sencilla de realizar esto sería a traves de la utilidad de Workflow.

    https://www.youtube.com/watch?v=0OJd-YUaWRw

    Espero que te sirva de ayuda

    Un saludo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Buenos días Jorge, en ese caso la solución sería:

      1. generar una query en la que compares la tabla del documento (OINV, ODLN, etc..) con la tabla ADOC que es la tabla donde el sistema guarda el historico de los documentos. siendo el campo de la tabla "documento" diferente al max(logintantc) de la tabla ADOC del mismo tipo de documento y mismo docentry.

      2. este resultado lo introduces en la gestión de alertas, y alli marcas la columna e-mail.

      Un saludo

      Antonio J. Infantes

  • author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2014 at 12:18 AM

    ESTIMADO TOCAYO

    UN FAVOR NECESITO OBTENER EL QUERY DEL INFORME DE ANALYSIS DE VENTAS PARA AGREGARLE MAS COLUMNAS PERO:

    TENGO EL SIGUIENTE QUERY PERO ME ARROJA DIFERENCIAS EN ALGUNOS ARTICULOS CUANDO ESTOS TIENEN DESCUENTOS, FACTURAS DE ANTICIPOS, O ESTAN ABIERTOS.

    EN FIN CUADRA EN UN 80 %, NECESITO EL 100% ME PODRIAN AYUDAR POR FAVOR

    SELECT ItemCode,

    Sum(TotFac) - SUM(TotNC) as 'FacturadoNeto',

    Sum(GBrutaFac)-SUM(GbrutaNC) as 'GBruta',

    Round((Sum(GBrutaFac)-SUM(GbrutaNC))/case when (Sum(TotFac) - SUM(TotNC))= 0 then 1 else (Sum(TotFac) - SUM(TotNC)) end *100,2) as '% Margen'

    FROM (

    SELECT

    ItemCode = T1.ItemCode,

    Marca = (Select T2.FirmName from OMRC T2 JOIN OITM T3 on T2.FirmCode = T3.FirmCode where T3.ItemCode=T1.Itemcode),

    TotFac = Sum(T1.Linetotal),

    GBrutaFac = SUM(T1.GrssProfit),

    TotNc= 0,

    GbrutaNC = 0

    FROM OINV T0 (NOLOCK) INNER JOIN INV1 T1 (NOLOCK) ON T0.DocEntry = T1.DocEntry

    WHERE (T0.[DocDate] >='20140101' AND T0.[DocDate] <='20141231')

    and T0.DocType = 'I' -- solo facturas por articulos

    Group by T1.ItemCode

    Union

    SELECT

    ItemCode = T1.ItemCode,

    Marca = (Select T2.FirmName from OMRC T2 JOIN OITM T3 on T2.FirmCode = T3.FirmCode where T3.ItemCode=T1.Itemcode),

    TotFac = 0,

    GBrutaFac = 0,

    TotNc= Sum(T1.LineTotal),

    GbrutaNC = SUM(T1.GrssProfit)

    FROM ORIN T0 (NOLOCK) INNER JOIN RIN1 T1 (NOLOCK) ON T0.DocEntry = T1.DocEntry

    WHERE (T0.[DocDate] >='20140101' AND T0.[DocDate] <='20141231')

    and T0.DocType = 'I' -- solo NC por articulos

    Group by T1.ItemCode

    Union

    SELECT

    ItemCode = T1.ItemCode,

    Marca = (Select T2.FirmName from OMRC T2 JOIN OITM T3 on T2.FirmCode = T3.FirmCode where T3.ItemCode=T1.Itemcode),

    TotFac = 0,

    GBrutaFac = 0,

    TotNc= Sum(T1.LineTotal),

    GbrutaNC = SUM(T1.GrssProfit)

    FROM ODPI T0 (NOLOCK) INNER JOIN DPI1 T1 (NOLOCK) ON T0.DocEntry = T1.DocEntry

    WHERE (T0.[DocDate] >='20140101' AND T0.[DocDate] <='20141231')

    and T0.DocType = 'I' -- solo Fact Anticipos por articulos

    Group by T1.ItemCode

    ) T

    Group by ItemCode, Marca

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Buenos días Jorge, podrias crear una nueva discusión con este problema.

      La forma de tratar de tratar los descuentos seria:

      CASE WHEN t1.discprcnt <> 0 THEN ((100 - t1.discprcnt) / 100) * t2.linetotal ELSE t2.linetotal END

      teniendo en cuenta que T1 haria referencia a oinv o orin y t2 hace referencia a las lineas inv1 o rin1

      Un saludo

      Antonio J. Infantes

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.