18.3 Extracting the maximum version of ML balances

To extract maximum version of ML balances for a given contract and CoA combination, follow these steps:

1. Navigate to Data Extraction Summary page to edit the Sys ML Balance Extract OOTB connector. Add the filter expression [Management Ledger Period Balance].[Run Identifier] = #DIH.runskey and [Management Ledger Period Balance].[Effective Date] = '#DIH.MIS_DATE' on Effective Date and Run Identifier of Management Ledger Period Balances entity and save the connector definition.
2. Create a custom PMF with a data service linked to the connector.
3. Edit the Data service and select the data service name as Integration Management Ledger Periodic Balances.
4. Edit the connector and select the Sys ML Balance Extract OOTB connector. Enter the MIS_DATE runtime variable expression as MIS_DATE = $MISDATE:dd-MMM-yyyy and save the custom PMF pipeline.
5. Execute the custom PMF pipeline with a MIS_DATE.

   Note:

   Selecting the Hierarchy parent will be available only for this out-of-the-box extract.