po status

[Former Member]

Hi All,

My client has a requirement that

E Mail notification shall be send to buyer that PO will be deletd regarding POs that are

1) 30 days old

2) No approvals started

3) NO GR/IR/Payment done

Finally delete such POS.

To start with

We will have to look for data in EKKO table about POS 30 days old, not approved and search those in EKPO to find if any GR/IR was done...later on how to go about it?

Regards,

Satyendra

[Former Member · Accepted solution]

Hi

Check for PO's more than 30 days old in Table EKKO & EKPO for delivery date.

Check in EKBE for the Purchase order history creation.

List down all the PO's with the slected criteria & the buyers.

Trigger notifications to the buyer that the Po's will be flagged for deletion.

For the Notification you need to create a task & assign the workflow agents whihc will be determined using the PO's

All this logic you need to incorporate in the flag for deletion Program whcih you need to develop.

Thanks & Regards

Kishore