on 07-13-2010 10:32 AM
Dear All,
I want to make selection of project code mandatory in every document ,can it be possible?
HI ,
Yes, it can me made mandatory through SP transaction notification.
Thanks,
Joseph
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.