Custom Reports require a timestamp. A user aims to generate a daily transaction report with a timestamp to aid in reconciling daily sales figures with the cash balance. Additionally, the timestamp in the report will help them identify errors more quickly.
Manager already timestamps transactions and documents. The task at hand is to make the timestamp option accessible in Custom Fields Reports.
Thank you. My mistake, I don’t mean to get it displayed in custom fields. I mean I want to be able to show it as a column in Custom Reports.
Thank you for the information on how to show it on documents though, useful information.
I have used this code but its returning current time and date (and changes as time pass on) not the time on which document is created. Anything i could have missed?
No. It’s live code, so every time you view a transaction or report it gets refreshed. It is important to understand that Manager does not store what you see on screen. It stores definitions of what to be displayed. The view itself is generated from scratch every time. That is how it remains accurate if things included within it are edited.
If you want a fixed copy of something, you need to print it or create and save a PDF.
I thought its getting its information from transaction history where timestamps are included. But its showing current system time (which is only useful if you print document at the exact same time when u create it.) not the actual timestamp of document.
You can look at the history of the transaction
I know. I was just referring to his statement.
I am just interested to have these on documents.
That is really of little use. Manager’s underlying structure only accounts by the day. In other words, all transactions with the same date are considered simultaneous.
I’m not planning to work on custom reports anymore, instead I’m focusing on advanced queries.
There is new Transactions screen which has Timestamp column too so you can run advanced query where you can filter transactions by their date and timestamp to find out if any historical transactions have been updated recently.
