po status

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