SP for Open GRPO not closed PO should not add in the system

[amol_bairagi]

Dear Experts,

If Open GRNs are not closed by A/P Invoices before 5th of the next month then No POs will be generated or (blocked by the sap )for that supplier.

It will be valid for all vendors.

Kindly provide me SP for these condition.

Regards

Amol

[former_member185296]

If you got the solution means then close the thread by marking it as helpful or correct answer

[amol_bairagi]

Hi Vinoth,

As per your code its give me error.

if @Object_type = '20' and @transaction_type ='A'

BEGIN

IF EXISTS ( SELECT B.DOCENTRY FROM OPDN B WHERE B.CardCode IN( select A.CardCode   from OPDN a

where a.DocStatus = 'O' AND DATEDIFF (D,A.DocDate,GETDATE()) > 5)

and T0.docentry = @list_of_cols_val_tab_del)

BEGIN

SET @error = 20

SET @error_message = 'open grpo exist!'

END

END

Regards

Amol

[amol_bairagi]

Any Updates for these.

[former_member185296]

Hi Amol,

if @Object_type = '20' and @transaction_type ='A'

BEGIN

IF EXISTS ( SELECT B.DOCENTRY FROM OPDN B WHERE B.CardCode IN( select A.CardCode   from OPDN a

where a.DocStatus = 'O' AND DATEDIFF (D,A.DocDate,GETDATE()) > 5)

and T0.docentry = @list_of_cols_val_tab_del)

BEGIN

SET @error = 20

SET @error_message = 'open grpo exist!'

END

END

Regards,

vinoth

[Former Member]

Hello Amol,

                  You can develop Z report for monitoring.if vendor exceeds time interval defined by you, Then that vendor should get blocked from source list for that particular month only.