Going a step beyond the activity search view, the ledger line search view allows you to search for individual line items within transactions. This can be helpful when trying to track down why a particular account balance may be off of what you're expecting.
- To access the ledger line search view, click on the "Plan/Analyze" tab, and then click "Ledger line search" button.
- On this view, you can search through the line items for the different transactions you've entered into the Finance module by using the standard search conventions. You can also filter your results by selecting which book(s) you want to view in the "Book" field and/or the transaction status of the line items you're searching for in the "Status" field, and in the "Filter" field, you can select the particular kind of transactions your line items would appear in, or filtering by a particular account type, or whether a the line item belongs to a transaction that was assigned to a vendor.
- This view is pre-filtered to only show the last 36 months worth of line items from transactions, if you want to go beyond that, uncheck the "Last 36 months" box.
- If you want to make changes to a line item, click on it and then click the "Edit" button. This will open the transaction the line item was a part of, and if it can be edited, you'll be able to do so from the window that appears.
- Clicking the "Refresh" button in the lower-right will update the grid based on your search criteria at the top of the grid.
- If you want to send the information on the grid into a spreadsheet, click the "Export" button. Clicking the "Print" button will let you print the line items you see on the grid.