Issue for production restriction !

[Former Member]

Hi.

We have all items as manage by batch numbers and basic setting for batch status is "Not Accessible". I want to restrict users that this item doesn't show or either throw an error that unless and until batch status change to release they unable to perform issue material for production.

Request to please advise the appropriate solution to control this.

Thanks and Regards,

Harshal Makwana

[Former Member · Accepted solution]

Dear Sir,

Please advise the transaction notification to restrict user.

Regards,

Harshal Makwana

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try:

IF @transaction_type in ('A') AND (@OBJECT_TYPE='60')

BEGIN

IF exists (SELECT T0.[DocNum] FROM OIGE T0  INNER JOIN IGE1 T1 ON T0.DocEntry = T1.DocEntry left join  OBTN T2 on t2.itemcode = t1.itemcode WHERE T2.[Status]  = '1' and

t0.Docentry = @list_of_cols_val_tab_del )

Begin

SET @error = 123

SET @error_message = 'Please check batch status'

End

End

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Dear Sir,

Thank you very much for your support and valuable answer.

Regards,

Harshal Makwana

[Former Member · Accepted solution]

Dear Sir,

I have tried this below SP as posted by you and it was working correctly on my test database and also on Live database till date but now on-wards we are receiving messages as Check batch status at the time of issue for production even after all batches are released which needs to be issued.

IF @transaction_type in ('A') AND (@OBJECT_TYPE='60')

BEGIN

IF exists (SELECT T0.[DocNum] FROM OIGE T0  INNER JOIN IGE1 T1 ON T0.DocEntry = T1.DocEntry left join  OBTN T2 on t2.itemcode = t1.itemcode WHERE T2.[Status]  = '1' and

t0.Docentry = @list_of_cols_val_tab_del )

Begin

SET @error = 123

SET @error_message = 'Please check batch status'

End

End

Please assist to rectify this issue.

Thanks and Regards,

Harshal Makwana

[kothandaraman_nagarajan · Accepted solution]

Can we check it through TV now? If OK, send ID and password.

[Former Member · Accepted solution]

Dear Sir,

Do you want to check through Ammy Admin ? My Ammy Admin id is : 34 717 767

I have restore my live database to test and window is open.

Regards,

Harshal Makwana

[kothandaraman_nagarajan]

Hi,

Already there is system message to alert the user for batch status

.

Thanks & Regards,

Nagarajan

[Former Member]

Dear Sir,

Warning is displayed at the time of issue but when they click yes they allow user to continue the process. What we want is to restrict user to proceed further unless and until batch is not release.

Hoping for the best to get answer.

Regards,

Harshal Makwana

[kothandaraman_nagarajan]

Hi,

Create transaction notification to restrict user if batch status in "Not accessible".

Thanks & Regards,

Nagarajan

[Former Member]

Hello Everybody !!!

Any status. Request to please help.

Regards,

Harshal Makwana

[Former Member]

Hi Harshal ,

Ask your Basis team who is handling user authorization matrix ,

that you want to restrict that user in this

<t-code >.....                                                          

<grants like 01 =for create >

                  02 =change

                  03=display .......and many more options

So Basis person will give the details how it is possible .

Thanks & Regards

Harshal Patel