Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TransactionNotification

Hi,

I appreciate if someone can help me.


I have in the dbo.SBO_SP_TransactionNotification the following sentence so we can not create an invoice if any price is 0.

 

if @object_type in ('13') begin --Objeto Factura de Cliente

if @transaction_type in ('U','A')begin --Actualización o Creación

  if (select count(*)

  from OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry

  where (T1.[Price] ='0' or T1.[Price] is null) and T0.DocEntry = @list_of_cols_val_tab_del)>0 begin

   set @error= 10

   set @error_message = 'SP-DMVM SAS** Falta precio de articulo'

  end

end

end

We need the same sentence with this restriction for the "AR Credit Note", what parts should we change to make it happen.

Thank you.

Sandra

Not what you were looking for? View more on this topic or Ask a question