Skip to Content
0

how to restrict the invoice while exceeding the credit limit

Feb 26 at 08:18 AM

31

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
Camilo G Apr 11 at 04:47 PM
0

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.


ejemplo.png (49.0 kB)
Share
10 |10000 characters needed characters left characters exceeded