How can I show in the report designer and generic inquiry the RELEASED DATE and RELEASED By?
In the > Purchase Receipts
> Bills And Adjustment
> Checks and Payments
> Receipts
> Transfers
> Adjustment
> and others, all with release function/action
Thank you. I really need your help guys.
Best answer by Laura02
Hello,
Consider using Access History screen in User Security, to see users who logged in on a particular Date/Time. Access History will also show you what screens a user opened.
Filter the Title if you want to choose one screen; filter Date to choose the Date when the suspicious transaction was recorded. Leave Username blank at the top to see All Users.
Screens Laura Opened Recently
Regarding system recorded Created & Last Updated: Last Updated date might be Released/Posted date, as in the case of GL or IN Transactions when Post at time of Release setting is ON.
Other times, more processing happens after a transaction is released and posted: actions such as Payment, or Void will change the Last Updated date in these cases.
Have you considered turning on Audits? Here is a description of Audits; answered by Naveen:
I am not sure that you will get RELEASED DATE and RELEASED By fields in the database to display it in report designer or in GI.
I believe you need to do customization for the same which includes adding custom fields (i.e. RELEASED DATE and RELEASED By) and save the data on Release action then it will be available to display on both report designer as well as in GI.
Thank you for your response. I was thinking if there are possible ways to retrieve prior transactions. We are right now tracking a suspicious transaction.
Only suggestion i could make is the Finance>Journal Transaction will be generated of the back of the Release (same user/time should be very close). So if you use the GLBatch entry as the basis of the GI then join the tables to it you might be able to work out when it was released. Not perfect but an idea.
Consider using Access History screen in User Security, to see users who logged in on a particular Date/Time. Access History will also show you what screens a user opened.
Filter the Title if you want to choose one screen; filter Date to choose the Date when the suspicious transaction was recorded. Leave Username blank at the top to see All Users.
Screens Laura Opened Recently
Regarding system recorded Created & Last Updated: Last Updated date might be Released/Posted date, as in the case of GL or IN Transactions when Post at time of Release setting is ON.
Other times, more processing happens after a transaction is released and posted: actions such as Payment, or Void will change the Last Updated date in these cases.
Have you considered turning on Audits? Here is a description of Audits; answered by Naveen:
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.