on 02-26-2018 8:18 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.