Skip to Content
avatar image
Former Member

how to restrict the invoice while exceeding the credit limit

Could any one tell me please that I am facing the problem with my code that is I want to restrict my A/R Invoice if that particular is exceeding the credit limit however I have created a notification for the same. Its working but not working properly.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 26 at 08:18 PM

    yo lo manejo por el transacpost en las validaciones de usuario coloco este codigo

    Select @registros = COUNT(*) from OINV t0 Inner join OCRD t1 on t0.CardCode=t1.CardCode where t0.DocEntry=@Id and ((isnull(t1.Balance,0) )>isnull(t1.CreditLine,0))-- se quito la suma porque el balance ya venia cargado con la factura

    if @registros > 0 begin RETURN 'Comuniquese con el area de creditos y cobranzas '

    end

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 04:47 PM

    Buenos días

    Autorizaciones generales - Ventas clientes - Confirmar desviación de linea de crédito. (Falta autorización)

    Esto lo actualizas en cada cuenta de usuario que genera facturas de venta, de esta forma el usuario no tendrá autorización para generar documentos de venta cuando excede el limite de crédito de los terceros.

    Add comment
    10|10000 characters needed characters exceeded