Notification required for SAP B1 HANA's Production module

[former_member576093]

Hello World..!!

I require a Transaction Notification for SAP B1 HANA for following scenario -

System should not allow posting of Receipt from Production without the posting of Issue for Production first if the production order has an item set to Manual issue method.

Thanks much!

[former_member576093]

SQL Notification for Reference -

----------------- Complete Issue For Production First---SQL--TN-------------------------

IF @object_type in('59') AND @transaction_type IN ('A','U') BEGIN IF EXISTS (SELECT T0.DOCENTRY FROM dbo.IGN1(Nolock) T0 WHERE T0.DOCENTRY =@list_of_cols_val_tab_del) BEGIN DECLARE @entry1 INT SELECT @entry1 = T0.BASEENTRY FROM dbo.IGN1(Nolock) T0 WHERE T0.DOCENTRY =@list_of_cols_val_tab_del IF EXISTS (SELECT T0.DocEntry FROM dbo.OWOR(nolock) T0 INNER JOIN dbo.WOR1(Nolock) T1 ON T0.DOCENTRY = T1.DOCENTRY LEFT JOIN dbo.IGE1(Nolock) T2 ON T2.BASEENTRY = T0.DOCENTRY AND T1.ITEMCODE = T2.ITEMCODE WHERE T0.DOCENTRY =@entry1 and t2.BaseEntry is null and t1.PlannedQty>0) SELECT @Error = 1003, @error_message = 'Issue for Production Not Done for this Productuion Order !' END ELSE SELECT @Error = 1003, @error_message = 'Issue for Production Not Done for this Productuion Order !' END

[former_member576093]

@Abdul Mannanabdul.mannan6 Hi Sir,

Any help on this will be really appreciable.

[former_member576093]

@travkin Hi sir !

Any help will be highly appreciable.

[Abdul · Accepted solution]

Try the below code after addding your customize conditions

IF @transaction_type IN ('A', 'U') AND (@OBJECT_TYPE = '59') BEGIN IF EXISTS ( SELECT t0.docentry FROM OIGN T0 INNER JOIN IGN1 T1 ON T0.DocEntry = T1.DocEntry LEFT JOIN OWOR T2 ON t2.docentry = T1.[BaseEntry] INNER JOIN WOR1 T3 ON T2.DocEntry = T3.DocEntry WHERE T3.[IssuedQty] = 0 AND T0.DocEntry = @list_of_cols_val_tab_del ) BEGIN SET @error = 10 SET @error_message = 'Please Issue Components First' END END

[former_member576093 · Accepted solution]

Thanks Sir!