Set the status on Released Trade Promotions to Finished if TP has expired ?

Hello,

I would like to do a development of report that sets the status on Released Trade Promotions to Finished if TP has expired, i.e. passed the End Date of the TPM.

The report should first search for all active trade promotions, i.e. all trade promotions that have the status "Released", i.e I1004 and then compare the end date of Trade Promotion with the date the report is run and if the end date has been passed then the system status should be changed to Finished, i.e. I1008.

Example:

We are running the report on 16.02.2009 and it finds the Trade Promotion below which has System Status I1004. Then it compares the date of running this report which is 16.02.2009 with the end date of Trade Promotion wich is for example 15.02.2009, since the date has been passed, the trade promotion has expired and thus the System Status should be set to I1008 "Finished" so that it can no longer automatically into a Sales Order.

I would like to know how can I do this ? or in which Implementation Name can I do the modification ?

Thanks in advance for your help

Amirovic