On approval form last upd on property was set as Date..

I changed it to Datetime now..

Issue resolved..

I would prefer to do this by database triggers. Last modification timestamp should be updated by trigger only when there is a STATUS change.

    Form no            Name                     Voucher Type
1) PURF2413            Misc AP                       AP
2) PURF2051            Service Order                 3A
3) PURF2071            Service Receipt               4C
4) PURF2120            GRN                           44
5) PURF2150            Overhead Expense Voucher      4B
6) PURF2190            Cash Purchase                 45
7) PURF2220            Store Purchase Voucher        55