Manual Document Number

[kedalenechong]

Hi all

Is there any way to prevent user to select Manual Document Number?

Kedalene Chong

[Former Member · Accepted solution]

Hi,

try below SPTN

if (@object_type = '22') and (@transaction_type IN (  'A'))

BEGIN

  IF exists (select T1.DocEntry FROM  OPOR T1

  where T1.DocEntry =@list_of_cols_val_tab_del and t1.Series=-1 and t1.UserSign=1)

  Begin

     SET @error = 30

     SET @error_message =N'You are not authorized to Use Manual Series'   

   end

END

if (@object_type = '20') and (@transaction_type IN (  'A'))

BEGIN

  IF exists (select T1.DocEntry FROM  OPDN T1

  where T1.DocEntry =@list_of_cols_val_tab_del and t1.Series=-1 and t1.UserSign=1)

  Begin

     SET @error = 30

     SET @error_message =N'You are not authorized to Use Manual Series'   

   end

END

Above SP is for blocking PO & GRPO for manual series when user is manager

you can make changes according to your requirement

regards,

raviraj

[kedalenechong · Accepted solution]

Hi All

Thanks a lot, it works!

[former_member209066]

Hi,

Check this SP

IF @object_type='2' AND (@transaction_type='A' or @transaction_type='U')

BEGIN

                if(Select Count(*) from OCRD T0

                where  (T0.Series='1' or T0.Series='2') and T0.CardCode=@list_of_cols_val_tab_del)>0

                begin

                    SET @error = 0201

                    SET @error_message= 'Please Select Correct Series'

                    GOTO EXITLINE

                end

end

Thanks,

Nithi

[Former Member]

Hi,

yes, you can prevent user to select Manual Document Number using Transaction Notification case of manual series.

Other series can be blocked for some user by applying Authorization using groups in series set up.

regards,

Raviraj

[kothandaraman_nagarajan]

Hi,

Yes possible by means Transaction Notification. Please advice required document/s, SAP version and PL.

Thanks & Regards,

Nagarajan

[kedalenechong]

Hi Nagarajan

Our client is still in SAP version 2007B and patch 14.  Please let me know if you have such ready stored procedure, thanks!

[kothandaraman_nagarajan]

Hi,

Use RaviRaj's transaction notification. Same way you can create for all other documents. Just change object code and user name as per requirement.

Object code

Sales order - ORDR-- 17

Delivery --ODLN -- 15

AR invoice -- OINV---13

Thanks & Regards,

Nagarajan