Bug 8079

Summary: Last modified timestamp
Product: [01.IMIS] IMIS FORMS AND REPORTS Reporter: kk <kapurk>
Component: IMIS FORMS AND REPORTSAssignee: anushree.pandey
Status: RESOLVED USER TO VERIFY    
Severity: normal CC: amit.madaan, rishab.kapoor, sharad.sharma
Priority: Normal    
Version: unspecified   
Hardware: PC   
OS: Mac OS   
Database: ALL Module ID:
Deadline: 2022-02-28   

Comment 3 anushree.pandey 2022-02-26 11:46:57 IST 
On approval form last upd on property was set as Date..

I changed it to Datetime now..

Issue resolved..
Comment 2 kk 2022-02-21 13:00:10 IST 
I would prefer to do this by database triggers. Last modification timestamp should be updated by trigger only when there is a STATUS change.
Comment 1 anushree.pandey 2022-02-21 11:48:35 IST 
    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
Description kk 2022-02-14 13:55:46 IST 
ALL voucher tables need to be checked to ensure that Last Modified On timestamp includes date and time of modification.