Skip to Content
0
Nov 26, 2009 at 05:57 AM

Object Type for production orders and Reciepts from Production

1347 Views

Dear all,

We are on SAP B1 2007 PL42.

I've written an SBO_Stored Procedure (transaction notification) to execute on the 'Production order' using the object_type as 202, but while adding a transaction of 'Reciepts from production screen' the query gets executed also. Are the object types of production orders and reciepts from production same, ie 202? The query sample is as below:

IF @object_type='202' AND @transaction_type = 'U'

Begin

IF EXISTS(SELECT T1.DocEntry as 'DocEntry' FROM dbo.[Owor] T1 WHERE T1.DocEntry in(Select BaseEntry from ign1) and T1.DocEntry = @list_of_cols_val_tab_del and status ='R')

BEGIN

SELECT @Error = 1, @error_message = Reciepts from Production completed'

END

END

Thanks

Asif