. The
details of the execution entity name along with the balance type are displayed.
You can open the report details using the additional icons.The Reconciliation Summary page provides a visual representation of the list of executions that are completed successfully along with its details.
1. Navigate to Balance Reconciliation Summary Page and select Reconciliation Summary.
When you navigate to the Reconciliation Summary Page, the Reconciliation History Page appears.
§ Execution Date: The date on which the Reconciliation has been executed. Users can select the execution date by clicking on the calendar icon.
§ Search Run Description: This drop-down list shows different runs for a given execution date selected in the execution date field. Users can select a particular run description and see the execution details on the right panel of the screen.
2. This screen provides a list of all the successful executions complete for the previous period, by default. You can zoom in to a particular day of a month and check the list of executions.
3. Click one execution, it gives a high-level summary of that particular execution. Once the execution is selected, Two panels appear on the right side. The first panel provides the details about the number of definitions executed in that execution and the second panel provides the time taken for that execution in seconds along with the Start and End
4. Click . The
details of the execution entity name along with the balance type are displayed.
You can open the report details using the additional icons.
For executions that have been executed with Auto Approval Flag as Yes, the Adjustments are directly posted in the target tables. For other Executions that are executed with Auto Approval Flag as No, the user has the choice to review the adjustments, modify the default values, and then approve the adjustments.
The Export option allows you to export the adjustments to an excel sheet and save it
To export the adjustments, follow these steps:
1. Click Export icon.
The Export Window is displayed.
2. Click Copy.
This action copies the Excel file name.
3. Click Download.
The Save As dialog-box is displayed. Paste the file name. This file name
should be same as copied.
The Import option allows you to upload the excel workbook with modified adjustment values.
Partial Adjustments: The user has the flexibility to tag one or more adjustments while importing the adjustment into the application. Users can enter the keywords Publish or P in the PUBLISH_STATUS column of the excel workbook. Only the adjustments that are marked for publish will be posted to the Product Processor.
Sometimes, the Exported excel sheet has a column called PUBLISH_STATUS with no values initially. You can either enter Publish or P against the records they want to post to the Product Processor table.
To Import the Excel file, follow these steps
1. Navigate to Administration UI and select File Operations option. For more information, see the File Operation Section.
2. Click Upload File. Click Add. Enter the following details:
§ Select the File Name.
§ Select the File Type as XLSX.
§ Enter the size of file.
3. Click Generate.
4. Copy Pre-Authenticated Request URL and execute it using Postman or Swagger as Service Type= PUT.
5. Click Import icon. Select the recent file from the pop up after clicking on the upload. It upload the file back to the server.
6. Click Approve icon.
Only the approved records get published in the target table.
7. Refresh the UI using Refresh icon.
You must Approve the adjustment in case to upload the Excel file back to the server or approve the adjustments.
To Publish the adjustments, follow these steps:
Click Publish
icon to display
the total amount approved by the Authorizer.
The user needs to exercise caution while clicking Publish icon. Adjustments
once published will be posted in the Target Table.