Skip to Content
avatar image
Former Member

invoice by sales order (transaction notification)

I do need to develop a transaction notification to block invoice if it not have sale orden
mi code is

-------------------------No es posible Facturar sin Orden de Compra


IF @transaction_type IN ('A','U') AND @Object_type = '13'
BEGIN
IF (SELECT COUNT(BaseType) FROM INV1 Where DocEntry = @list_of_cols_val_tab_del AND BaseType <> 17) >= 1
    set @error = -1
        set @error_message = N'No es posible crear una Factura sin Orden de Venta'
    END
END


and the block is correct but I can't copy partially the sale order

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 20, 2017 at 09:13 AM

    Hi

    if you want to allow copy partially I think you have to block when all invoice lines do not have previous document.

    I will try this:

    if (@transaction_type in ('A', 'U') and @object_type = '13')
    begin
    	if (select count(*) from inv1 where baseentry = -1 and docentry = @list_of_col_val_tab_del) > 0
    	begin
    		set @error = 1
    		set @error_message = 'No se permiten líneas sin pedido de venta asociado'
    	end
    end

    Kind regards

    Agustín Marcos Cividanes

    Add comment
    10|10000 characters needed characters exceeded