Hello everyone,
Hoping you are doing well.
I have a query with regards to a saved search based on system notes. I am trying to generate a report (or dataset) whereby I need to retrieve specific transaction details, namely to determine whether there had been any alterations to a transaction once this transaction had been approved.
I started out this endeavour by generating a saved search having its search type being System Note. The main criteria used were that the [Record Type] selected was "Transaction" and in order not to pull an exhaustive amount of records at a time, I also added [Date] and set it to a relatively small data range. To counteract the limited dataset, I have added the date filter so as to extend the specific time range as necessary to the person running the search. Sorting has been carried out first by [Record] and then by [Date], so as to group record types together.
The result fields utilised included: Record, Date, Set by, Role, Type, Field, Old Value and New Value. In doing so, I was able to obtain the main history of the fields that were altered within a transaction.
The issues I am facing here are:
a) whether I can fine-tune the dataset to narrow it down specifically by a transaction type (e.g. journals, vendor bills, invoices, purchase orders), or a combination of. As things stand, all transactions types are being shown and unless being very mistaken, I'm not seeing a filter option which would let me achieve this.
b) whether a feasible method exists in the saved search UI in order to generate some sort of criteria or filter whereby only the records which changed after the [Field] "Document Status" has an [Old Value] of "Pending Approval" and a [New Value] of "Approved for Posting" in order to further reduce and filter out transactions which were not modified after they have been approved.
Any guidance/feedback on possible ways of how to go about the above couple of issues would certainly be appreciated.
Thanks in advance for taking the time to review this query of mine.
Best Regards,
G