Multi company ledger opening balance

Need help to get total of opening balance of a ledger from all loaded companies.

I tried making a collection, similar to how we make a collection for vouchers from all member companies of a group company.

Code:

[Collection : allopencmpcoll]
  
    Type        : Company
    Fetch        : Name
    Filter        : IsSimpleCompany, AESCurrentCmp

[Collection : multiledopbal]
  
    Collection    : AESLedgeropbal : Allopencmpcoll
    by            : ledgername    : $ledname
    Aggr Compute: finalopbal    : Sum    : $$AsAmount:$ledopbal
  
    search key    : $ledgername
      
[Collection : AESLedgerOPBal]
  
    Type    : ledger
    Fetch    : name, openingbalance
    Compute    : ledname    : $name
    Compute : ledopbal    : $$AsAmount:$openingbalance

 

Then using '$$collectionfieldbykey' in field to get value for opening balance

Code:

[#Field : DSP VCHCrOpamt]
  
    Set as    : $$AsAmount:$$CollectionFieldByKey:$finalopbal:#ledgername:multiledopbal
[#Field : DSP VCHDrOPAmt]

    Set as    : $$AsAmount:$$CollectionFieldByKey:$finalopbal:#Ledgername:multiledopbal