Skip to Content
1
Former Member
Jun 29, 2007 at 02:33 PM

SBO_SP_TransactionNotification with approvals

15 Views

I had some problems about SBO Notification with Approvals...

The field Cost Profit is mandatory on the matrix in the Quotation (Object 23), so the system does not allow the addition if this field is blank...

However when I have a approval in the Sales Quotation, I can´t insert the document, even when field is not null.

Can someone help me?

Thanx

Follow below the code:

If ((Select OcrCode From QUT1 Where DocEntry = @list_of_cols_val_tab_del) = '' Or

(Select OcrCode From QUT1 Where DocEntry = @list_of_cols_val_tab_del) = NULL Or

(Select OcrCode From QUT1 Where DocEntry = @list_of_cols_val_tab_del) is NULL)

Begin

Set @error = 1;

Set @error_message = 'Please fill the field Cost Profit!'

End