How can I search for Transaction ID's within a range?

How can I search for Transaction ID's within a range?

You can create a range of Transaction ID's in Excel and then paste them into the "Transaction ID" to search for a range.

Go to Excel
Create the list of transactions


Go to a new (empty) cell and go to the Formulas tab, click "Insert Function (fx) type "textjoin"
click "ok"
"delimiter" is "," (comma)
skip "ignore_empty"
click in "text1" box
then select the range... (so select A1 thru A21)
click "ok"

This will put the range in the cell you were in.  
Click on that cell and copy (ctrl+c)
Go to the "Transaction Catalog" and paste this into the "Transaction ID" box (this box can handle quite a bit of information)
Make sure you have filled in the "Transaction Code" (in this case "CR") and the "Transaction Dept"
click "Search"

Your results should populate.


    • Related Articles

    • QRG - Item Transaction History

      Description and Purpose Have you ever wanted to know the specific history of a stock item and figuring it out was not easy? You would have to jump around to the various transactions and tables to assess what happened. FINET now has a new query page ...

    • How do I delete multiple transaction templates? (May be mistaken as accounting templates)

      In the transaction catalog, you can search for the transaction code, your department, and the transaction phase "template". You can further narrow your search however you want. From there you can select the ones you want to delete, then click the ...

    • QRG - Upload transaction spreadsheet (UPDOCS)

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1X3e5Ork1DlpfcXRqeAD3yMiVdaoTuhG8/view ) Introduction Similar to the current process of using Spreadsheet Upload (SSLD) to upload documents from a spreadsheet into ...

    • GMA entered and paid but did not enter the reference transaction code and the referenced transaction ID - can this be fixed?

      A GMA has been submitted and paid but did not reference the contract. Can the missing information be added? Yes. Create a GMA that references the contract (A GMA must have at least one line connected to a contract.) Then create another line that is ...

    • QRG - Creating Transactions

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1aa4QyUy2V4gvdL3BXxz-KXcmnH9OzT52/view ) Introduction This quick reference guide describes how to search for and create transactions in FINET. Creating a ...