How to filter the log viewer to look for certain activity performed in an application
Description
Filter for Payroll related entries:
  1. Click on the Filter icon.
  2. Click Add
  3. Enter the name to assign to the new filter for example "Payroll"
  4. Under the "show only items that meet the following conditions select ClientApplication Is then enter PR in the third box.
  5. Click Save Changes.
  6. Click the X in the upper right hand corner to close the Manage Filters window.
  7. Click the FILTER drop down list in the Log View window to select the Payroll filter in order to display on the errors and messages that originated in the Payroll application.

Filter for Vendor setup changes:

  1. Click on the Filter icon (gray funnel button).
  2. Click Add.
  3. Enter the name to assign to the new filter, for example AP Vendor Setup.
  4. Under Show only items that meet the following conditions, select Task, select Is, then enter Vendor Setup in the box.
  5. Click Add Condition.
  6. Leave the connector as And, select LogType, select Is, then enter Setup in the box.
  7. Click Save Changes.
  8. Click the red X in the upper right hand corner to close the Manage Filters window.
  9. Click the Filter drop-down list and select the name you created in step 4, for example AP Vendor Setup.
  10. If needed, change the Display option from 30 days (default), to 60 days, 180 days, One Year, or enter a Custom date range.
  11. Once the filter is finished being applied, scroll to the right to view the Message and Detail columns. The Message column will indicate if a vendor was created or changed. The Detail column will show a paper icon if there are details to display. Double-click on the line item to view the details.
Cause
Resolution
[BCB:5:Third-party support:ECB]
  1. Open the log viewer.
    • Version 15.1 and older: From Sage Desktop Tasks pane, Common Tasks, Tools, Log Viewer.
    • Version 16.1 and newer: From Sage Desktop Applications, Common Tasks, Tools, Log Viewer.
    • Or from within an application, Tools menu, Log Viewer.
  2. In the Log Viewer pane, select a Filter from the list. For example, you can select Errors from the list to display those activities that produced an error message.

See Additional information below for some example filters.

You can also:

  • Double-click a column heading to change the sort order.
  • With the row selected, click View or double-click the row to see the details about the message.
  • Export all or part of the list of messages to Excel or to Xml.
  • Click the Filter icon (gray funnel button) to manage your filters. When you select this option you can create your own filters. For example, you can create a filter for a specific application or data folder.

To create a custom filter:

  1. Click on the Filter icon (gray funnel button).
  2. Click Add.
  3. Enter the Name to assign to the new filter.
  4. Under Show only items that meet the following conditions, select the options appropriate for your filter.
    • Column field 1 Options:
      • ClientApplication: Select this option if you want your filter to include/exclude log entries for specific applications, such as AP, AR, BL, CM, CN, GL, JC, PJ, PR, PM, etc.
      • ClientMachine: Select this option if you want your filter to include/exclude log entries from a specific computer name.
      • CompanyName: Select this option if your want your filter to include/exclude log entries from a specific company data folder.
      • CreatedOn: Select this option if you want your filter to include/exclude log entries for a specific date or date range.
      • LogSeverity: Select this option if you want your filter to include/exclude log entries for a specific LogSeverity. The LogSeverity types are Error, Information, and Warning.
      • LogType: Select this option if you want your filter to include/exclude log entries for a specific LogType. The LogTypes are Application, AuditSetup, FieldReport, PostingRecap, Security, Setup, System, and TaskSummary.
      • Task: Select this option if you want your filter to include/exclude log entries for a specific task.
      • WindowsUser: Select this option if you want your filter to include/exclude log entries for a specific Windows user.
    • Column field 2 Options:
      • Is: The values found for column 1 must match or be equal to the value entered in column 3. For example, ClientApplication Is AP.
      • Is not: The values found for column 1 must not match or is not equal to the value entered in column 3. For example, LogSeverity Is not Information.
      • Starts with: The values found for column 1 must start with the value entered in column 3. For example, Task Starts with Upgrade.
      • Contains: The values found for column 1 must contain the value entered in column 3. For example, Task Contains Settings.
      • Is between: The values found for column 1 must be between the two values entered in column 3 and column 4. For example, CreatedOn Is between 06/01/2018 and 06/30/2018.
      • Note: The column field 2 options for the CreatedOn selection are different. They are: Is, Is between, Is today, and Is within.
    • Column field 3: Enter the value to be used for this condition.
  5. If you need to add additional conditions to your filter, click Add Condition. Then select the appropriate connector for this condition: And or Or. Then continue with the appropriate option selections for this condition.
    • Note: You can have up to 20 condition lines.
  6. When you are finished with your filter, click Save Changes.
  7. Click the red X in the upper right hand corner to close the Manage Filters window.
  8. Click the Filter drop-down list and select the filter name you created in step 3.
  9. If needed, change the Display option from 30 days (default), to 60 days, 180 days, One Year, or enter a Custom date range.
  10. Once the filter is finished being applied, review your results.
    • Tip: Scroll to the right to view the Message and Detail columns. The Detail column will show a paper icon if there are details to display. Double-click on the line item to view the details.

[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles