Assign and Review Breaks for Warehouse Reconciliation

Owned by Copy Page Tree (Unlicensed)
Last updated: Sept 07, 2023 by Nancy Cohn (Deactivated)
3 min read

You can assign and review trade breaks using the Trade Recon console. You can also create a totals report of all trade exceptions.

Assign Breaks

Trade Recon match results are displayed on the Trade Recon Exceptions report. As a privileged user you can select breaks from the query results and assign the breaks to team members for research and resolution.

To assign a break for research and manual resolution:

  1. From the Trade Recon console, click the Query Result tab for the Trade Recon Exceptions report.
    You see the recent report results.

  2. Select the break rows you want to assign and then right click Audit action.
    You see the Audit Action dialog box.

  3. Select the Assign to User field and choose from the list of LAN ids, as authorized for the system environment. You can assign to a workflow group or an individual user.

  4. Enter Comment, Category, or Sub-Category information, as required.

  5. Select the Expiration Date check box and enter the effective date you want the comment to automatically close.

  6. Click Submit to update the selected breaks for the assignment details.

Automatically Assign Breaks

You can use the Trade Recon console to automatically assign breaks after you define exception assignment rules. You can also submit automatic assignment processing using a message stream scheduled to run after the Run Match Now message stream.

To automatically classify and assign breaks to team members:

  1. From the Position Recon console, click Tools and then click Run Trade Assignments for the type of assignments you want to run.
    You see the Run Assignment Rule dialog box.
    NOTE: You can click the Matching Profile drop down and select a previously saved set of options for reuse.

  2. Click the Left Source drop down and select the source for the left side of the results to process for assignment.

  3. Click the Right Source drop down and select the source for the right side of the results to process for assignment.

  4. Enter the Date with the effective date of the match results.

  5. Select the Close Comments check box to automatically close the comment upon reconciliation. Or, clear the check box to maintain the history of comments for this break.

  6. Click the Assignment Rule drop down and select the assignment rule you want to use to apply comments and assignments.

  7. Select and complete the entity information as required.
    Options include:
    –  All Entities
    –  Process Center
    –  Entity List
    –  One Entity

  8. Click Submit.
    The comments and assignments are posted.

Review Aged Breaks

As trade match results are reviewed and handled by the reconciliation team, comments entered by the team are aged on the database. The age of the comment is the number of consecutive business days the break remains with the same comment. You can review the ages of breaks on trade activity on the Query Exceptions Comments report, including the number of days aged and the current status of the break.

To review aged breaks on trade activity:

  1. From the Accounting Center window, select Reconciliation in the left navigation and then click Admin and Aged Report.

  2. Double click Query Exceptions Comments.
    You see the Query Exceptions Comments entry panel.

  3. Complete the Query Exceptions Comments panel options as required to filter the report results.

  4. Click Submit.
    You see the Submit Query dialog box.

  5. Click Grid Report.
    You see the multi-tab grid report on your desktop.

  6. Click the Trade tab to view the aged reconciliation report for trade activity.
    Note: You can automatically close/delete comments by selecting the Close Comments option on the Run Assignment Rule dialog box.

Create the Total Trade Summary Report

You can use the Trade Recon Exceptions report to total trade recon exceptions by date range, entity, and data sources.

To create the Total Trade Summary report:

  1. From the Trade Recon console, double click Total Trade Summary in the left pane.

  2. Click the Total Trade Summary tab.
    You see the Total Trade Summary panel.

  3. Complete the fields on the Total Trade Summary panel.

  4. Click Search.
    You see the Total Trade Summary report.

Â