I have made a new Sales Register which gives me Pending Amount if amount is pending and Zero if it is cleared. I need to add the cleared date to this. Unfortunately it is not getting fetched. I have identified the field but I think there is a fetching problem as the collections are overlapping. These are the collections that are being used. Can someone help me rectify the clearedon fetch ? I understood that it should in the bills collection to be fetched. [Collection:CollForBills] Type: Bills Fetch: Clearedon Compute : VoucherNumber : $$CollectionField:$VoucherNumber:1:LedgerEntries [Collection: MycollforCollection] Source Collection : CollForBills Isodbctable: Yes Fetch : ClosingBalance, VoucherNumber, Amount, Clearedon Compute : LedgerName : $$CollectionField:$LedgerName:1:LedgerEntries Search Key : $VoucherNumber [Collection : Salescoll] Type : voucher Filter : IsSale IsODBCTable: Yes Fetch : Vouchernumber,PartyLedgername,Amount,Date,Clearedon Compute : PendingAmount:$$ReportObject:$$CollectionFieldbykey:$ClosingBalance:$VoucherNumber:MycollforCollection Compute : Amount:$$ReportObject:$$CollectionField:$Amount:1:LedgerEntries Compute: Clron:$$ReportObject:$$CollectionFieldbykey:$Clearedon:$VoucherNumber:MycollforCollection
