4.13 Process Global Order Reconciliation Detail

This topic provides the instructions to process Global Order Reconciliation Screen Details.

The system will compare the confirmation message received from the fund house with the original message generated. If there is a mismatch in the fund price received from the fund house for this order compared to fund price received for an earlier order having same fund ID/ transaction type/ transaction date, then same will get reflect in the Global Order Reconciliation Detail screen. You can manually correct the status message as Confirmed or Rejected which will be confirmed from the fund house.

If the latest Global Order price is different from the existing fund price, then you need to confirm the Global Order price. Update the correct price in the Global Order, once the price issue is sorted out. On updating the correct price, all the Global Order will have the same price for the transaction date/fund/transaction type combination.

IF Global Order price is correct, you can update other Global Order (for same transaction date/transaction type/ fund) and even fund price. On update, all the Global Order will have same price for the transaction date/ fund/transaction type combination. Once the price is amended with the correct price, you can authorize the transaction from Global Order Reconciliation screen.

The mismatch transaction will no longer reflect in the Global Order Reconciliation Detail screen once authorized.

Specify User ID and Password, and login to Home screen.
  1. On Home screen, type UTDGORCN in the text box, and click Next.
    The Global Order Reconciliation Detail screen is displayed.

    Figure 4-9 Global Order Reconciliation Detail


    Description of Figure 4-9 follows
    Description of "Figure 4-9 Global Order Reconciliation Detail"

  2. On GO Confirmation Detail screen, specify the fields.

    For more information on fields, refer to the field description below table.

    Table 4-13 Global Order Reconciliation Detail

    Field Description
    Global Order Number Alphanumeric; 16 Characters; Mandatory

    Specify the Global Order number.

    If you click on Populate button, the fields will be displayed.

    AMC ID Display

    The system displays the AMC ID.
    Global Order Transaction Type Display

    The system displays the Global Order transaction type.
    Nominee Account Number Display

    The system displays the nominee account number.
    Global Order Mode Display

    The system displays the Global Order mode.
    Fund ID Display

    The system displays the fund ID.
    Unit Holder ID Display

    The system displays the unit holder ID.
    UH Account Type Display

    The system displays the UH account type.
    Remarks Alphanumeric; 255 Characters; Optional

    Specify remarks, if any.
    Global Order Date Display

    The system displays the Global Order date.
    Global Order Status Optional

    Select the Global Order status from the drop-down list. The below lists are displayed:

    • Confirmed
    • Rejected
    • Pending Confirmation
    • Amount Mismatch
    • Unit Mismatch
    • Price Mismatch

    For Amount based order, if confirmation amount is mismatch then system will save record with Status as Amount Mismatch.

    For Unit based order, if confirmation unit is mismatch then system will save record with Status as Unit Mismatch.

    For Amount/ unit based order, if confirmation price is different than the fund price (for transaction date and transaction type combination) then system will save Global Order with status as Price Mismatch.

    If unit/ amount and confirmation price matches then system will save the Global Order with confirmed status as Global Order Confirmed.

    You can change the Global Order status manually to either Global Order confirmed or Global Order rejected in the Global Order Confirmation screen. All other statuses are defaulted by the system without manual intervention. Once Global Order is rejected, post confirmation of rejected order and all underlying transactions in the Global Order will be rejected. These will not be taken up for allocation.
    Global Order Status Optional

    Select the Global Order status from the drop-down list. The below lists are displayed:

    • Price Mismatch
    • Unit Mismatch
    • Amount Mismatch
    • Confirmed
    • Rejected

    The system will compare the confirmation message received from the fund house with the original message generated.

    In case, if there is a mismatch in the fund price received from the fund house for this order compared to fund price received for an earlier order having same fund id/transaction type/ transaction date, then same will get reflect in the Global Order Reconciliation screen for manual correction with status message as Confirmed Price Mismatched.

    The correct price will be confirmed from the fund house outside the system.

    If the latest Global Order price is different from the existing fund price, you need to confirm Global Order price.

    Once the price issue is sorted out, you should update the correct price in the Global Order.

    IF Global Order price is correct, then update the fund price. On update, all the Global Order will have same price for the transaction date/fund/transaction type combination.

    Once the price is amended with the correct price, you should authorize the transaction from Global Order Reconciliation screen.

    The mismatch transaction will no longer reflect in the Global Order Reconciliation screen once authorized.

    Global Order Units Display

    The system displays the Global Order units.

    The confirmation message received from the fund house will be compared with the original message generated.

    For a units based order, in case, if there is a mismatch in the Global Order Units Value received from the fund house, then same will get reflect in the Global Order Reconciliation screen for manual correction with status message as Confirmed Units Mismatched

    The correct value will be confirmed from the fund house outside the system.

    Once the units issue is sorted out, you need to update the units with correct units in Global Order Reconciliation screen

    Once the units are amended with the correct Units, you should authorize the transaction from Global Order Reconciliation screen

    The mismatch transaction will no longer reflect in the Global Order Reconciliation screen once authorized.
    Global Order Confirmed Units Numeric; 27 Characters; Optional

    Specify the Global Order confirmed units.

    Once the Global Order is confirmed all the underlying transactions will be picked up for allocation by allocation batch. Once the underlying GO trades are allocated during EOD, the system will do a reconciliation of allotted units against confirmed units.

    If there is a difference in the allotted units, the same will be reflected in the Global Order Reconciliation screen with a status message Global Order Allotted Units Mismatched. This will be before rounding difference process.

    To sort the difference, the system will calculate the threshold units in Fund Rules screen. If the difference units are more than the threshold units maintained, you need to manually round off the units.

    If the difference units falls under the threshold units maintained, the system will automatically rounded off using a distribution logic with values as To Highest Transaction Amount and Highest Transaction Amount to Lowest

    This distribution logic are applicable to funds, which fall under the AMC for which Distribution logic has been maintained

    If user maintained distribution logic as To Highest Transaction Amount then the system will adjust the differential units to the transaction which has the highest transaction amount.

    If user maintained distribution logic as Highest Transaction Amount to Lowest then system will distribute the difference amount from the highest transaction amount to the lowest in step up units.

    If the AMC confirmed units are more than the system allotted, then system calculates Negative (-ve) differential units. If the AMC confirmed units are less than the system allotted, then system calculates Positive (+ve) differential units

    Once the rounding difference is sorted out, this transaction will no longer reflect in the Global Order Reconciliation screen.

    The difference units distributed based on the logic will be tracked separately during allocation

    Based on the logic- system will update the allocated units with extra or reduced units
    Global Order Amount Display

    The system displays the Global Order amount.
    Global Order Confirmed Amount ANumeric; 30 Characters; Optional

    Specify the Global Order confirmed amount.

    The confirmation message received from the fund house will be compared with the original message generated

    For an amount based order In case, if there is a mismatch in the GO Amount Value received from the fund house, then same will get reflect in the Global Order Reconciliation screen for manual correction with status message as Confirmed Amount Mismatched

    The correct value will be confirmed from the fund house outside the system

    Once the Amount issue is sorted out, you need to update the amount with correct amount in Global Order Reconciliation screen

    Once the amount are amended with the correct amount, you should authorize the transaction from Global Order Reconciliation screen

    The mismatch transaction will no longer reflect in the Global Order Reconciliation screen once authorized.

    Global Order Confirmed Price Numeric; 22 Characters; Mandatory

    Specify the Global Order confirmed price.

    Transaction Category Display

    The system displays the transaction category. One of the following values are displayed in this field:

    • Legacy
    • Advised Business
    • Execution Only
    Global Order Price Date Display

    The system displays the Global Order price date.

    Once the Global Order is confirmed all the underlying transactions will be picked up for allocation by allocation batch. Once the underlying Global Order trades are allocated during EOD, system will do a reconciliation of allotted units against confirmed units.

    If there is a difference in the allotted units, the same will be reflected in the Global Order Reconciliation Detail screen with the status message as Global Order Allotted Units Mismatched

    This will be before rounding difference process.

    If the AMC confirmed units are more than the system allotted, then the system will calculate Negative (-ve) differential units.

    If the AMC confirmed units are less than the system has allotted, then the system will calculate Positive (+ve) differential units

    Once the rounding difference is sorted out, this transaction will no longer reflect in the Global Order Reconciliation Detail screen.

    The GO Reconciliation screen will show any unconfirmed global orders and those with a price mismatch or those where the allotted units does not match the confirmed number of units during de-aggregation.

    In case the confirmation message is not received on any date, the system will show all the transactions with, confirmation related columns as BLANK and the Confirmation Status field will show the message as Confirmation message pending.

Parent topic: Process the Transactions - II