cancel
Showing results for 
Search instead for 
Did you mean: 

project code compulsion

Former Member
0 Kudos

Dear All,

I want to make selection of project code mandatory in every document ,can it be possible?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI ,

Yes, it can me made mandatory through SP transaction notification.

Thanks,

Joseph

Former Member
0 Kudos

Hi joseph,

can you please explain the complete procedure?

Former Member
0 Kudos

HI Agranshu,

Try this :

IF @transaction_type = 'A' AND @Object_type = '13'
BEGIN 
IF EXISTS (SELECT T0.DocEntry FROM [dbo].[INV1] T0
WHERE (T0.Project IS NULL OR T0.Project = '')
AND T0.DocEntry = @list_of_cols_val_tab_del)
   SELECT @Error = 1, @error_message = 'Please select the Project Code'
END

This sp would block the addition of AR invoice if project code is not selected. For different marketing documents, you have to change the object type and the table names. Hope this helps.

Thanks,

Joseph

Answers (0)