Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Transaction - Date & Time Posted

Sage 50 general help forum - Free help and support for all general issues
Post Reply
samij
User
User
Posts: 12
Joined: 09 Jan 2013, 14:51
Sage Version: v2017 23 UK/Europe/Africa

Transaction - Date & Time Posted

Post by samij » 04 Jul 2017, 09:58

Hi,

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

Thanks,
Sam

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Transaction - Date & Time Posted

Post by brucedenney » 04 Jul 2017, 10:45

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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

samij
User
User
Posts: 12
Joined: 09 Jan 2013, 14:51
Sage Version: v2017 23 UK/Europe/Africa

Re: Transaction - Date & Time Posted

Post by samij » 04 Jul 2017, 10:49

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Transaction - Date & Time Posted

Post by brucedenney » 04 Jul 2017, 13:11

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?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

samij
User
User
Posts: 12
Joined: 09 Jan 2013, 14:51
Sage Version: v2017 23 UK/Europe/Africa

Re: Transaction - Date & Time Posted

Post by samij » 04 Jul 2017, 13:51

Audit Trail report - AUDIT_HEADER

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Transaction - Date & Time Posted

Post by brucedenney » 04 Jul 2017, 14:13

Appears to be date without a time there.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

samij
User
User
Posts: 12
Joined: 09 Jan 2013, 14:51
Sage Version: v2017 23 UK/Europe/Africa

Re: Transaction - Date & Time Posted

Post by samij » 04 Jul 2017, 14:22

Ok Bruce.

Thanks,
Sam

Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 17 guests