Page 1 of 1

Transaction - Date & Time Posted

Posted: 04 Jul 2017, 09:58
by samij
Hi,

Is there any way to check what time a particular transaction was posted?

Thanks,
Sam

Re: Transaction - Date & Time Posted

Posted: 04 Jul 2017, 10:45
by brucedenney
The latest version has creation and last modification date fields for many records including audit trail records, I think version 2012 did not have this.

Re: Transaction - Date & Time Posted

Posted: 04 Jul 2017, 10:49
by samij
Thanks for the reply Bruce.

I have to latest version as well, can I only see posted the date? or can I see the actual time it was posted too (H:M)?

Thanks,
Sam

Re: Transaction - Date & Time Posted

Posted: 04 Jul 2017, 13:11
by brucedenney
Well, it is a date, but as far as I can see it has decimal places, so there is an option for time, it may be Sage forces it to .00000 you need to have a look and see.

Which table are you looking at?

Re: Transaction - Date & Time Posted

Posted: 04 Jul 2017, 13:51
by samij
Audit Trail report - AUDIT_HEADER

Re: Transaction - Date & Time Posted

Posted: 04 Jul 2017, 14:13
by brucedenney
Appears to be date without a time there.

Re: Transaction - Date & Time Posted

Posted: 04 Jul 2017, 14:22
by samij
Ok Bruce.

Thanks,
Sam