SBO_SP_TransactionNotification with approvals

[Former Member]

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

[Former Member · Accepted solution]

Hi Raphael,

Remember that when you add a Sales Quotation through the approval procedure, it doesn't really is in the OQUT table, but it is added as a draft. So you should look in the OQUT and QUT1 tables.

Hope this helps,

Ian