Collections -reg

Collections has nothing to do with the lines.........

From screenshot I assume you have Left fields and Right fields...........

Left field last column is Party Name....

So in partyname field......... add below 2 lines.
Width : 25
FullWidth : Yes

 

Am much confused with your code, and am afraid I cannot spare much time on this am busy with other projects. You have field name called TruckNo and it collects "cheque no".

Am giving a sample for you to follow. Follow the same pattern for the balance fields.

Code:

[Collection    : PRScrColl] ;PRCollection];
        Type    : Ledger: Bills
        Cleared    : Yes
        By      : mrname : $name
        Belongs To: Yes
   
[Collection    : PRScrCollRpt] ;PRCollection];
        Type    : Ledger: Vouchers
        Filter    : MriRecVchFilt
        By      : mrname : $name
        Compute :Mribkname   : $LedgerEntries[2].BankAllocations.Bankname
        Compute :Mricheqno   : $LedgerEntries[2].BankAllocations.INSTRUMENTNUMBER
        Compute :MricheqDt   : $LedgerEntries[2].BankAllocations.INSTRUMENTDate
        Compute: RcptAmt     : $$CollectionField:$Amount:1:PRScrColl

[System: Formula]
    MriRecVchFilt    :$$IsReceipt:$VoucherTypeName
   
[Collection    : PRCollection]
        Source Collection    : PRScrCollRpt
        Fetch    : *, PartyLed, Parent, LedgerName,BillDate,mritrFrmDt,mritrtooDt,mritrtrkno,BankName,InstrumentNumber,InstrumentDate

In above, check how "RcptAmt" has been computed......so compute the rest of the fields.

 

In future, if you want aid/help/solutions, ensure the TDL is full and proper. We do not have time to create Menu items or try to understand that the Field Name "TRUCKNo" is really for ChequeNo.

It is time wasted for us to try and comprehend the field names, the structure etc...........