Hi all, please help me in following code I want collection as shown in fig. last column is balance ( pending sale order) $b represents booked, $s represents supplied $c represents canceld [#Menu:gateway of tally] Add : Key Item : Before : @@locQuit : CLXN AS TABLE :U : Alter :clxnastable [Report:clxnastable] Form:clxnastable [Form:clxnastable] Part:clxnastable on:Form Accept:Yes:Call:fxn clxnastable [Part:clxnastable] Line:clxnastable [Line:clxnastable] Field:clxnastable [Field:clxnastable] Use:name field Show Table:Always Table:collxn po1 [Collection:collxn vch] Type:voucher Filter:isboth Belongs To:Yes [Collection:collxn po1] Source Collection:myvch Title:"Order Book" Sub Title:"NAME","Order Number","Booked","Bricks Type","Rate","Supplied","Canceled","balance" walk:ledger entries ;;By: mpovchtype :$vouchertypename By: mponame :$partyLedgerName Walk:ALLINVENTORYENTRIES By: mpotype :$stockitemname By: mporate :$rate walk:batch allocations By: mpoorderno :$orderno Compute: mpoorderduedate :$orderduedate aggr Compute:b :Sum:if $$IsSalesOrder:$vouchertypename then $$QtySubtract:$Actualqty:$ORDERPRECLOSUREQTY else 0 Aggr Compute:s:Sum:if $$IsSales:$vouchertypename and not $isoptional then $ACTUALqty else 0 Aggr Compute:c :sum:if $$IsSalesOrder:$vouchertypename then $ORDERPRECLOSUREQTY else 0 Filter:removedelivered Sort:default:$mponame ;Fetch:mponame,mpoorderno,booked,mpotype,mporate,supplied,canceled;,bal Format:$mponame,25 Format:$mpoorderno,7 Format:$b,10;ooked,10 Format:$mpotype,10 Format:$mporate:10 Format:$s,10;upplied,10 Format:$c,10;anceled,10 Format:$bal,10 [System:Formulae] isstockgroupbrick:$name contains "brick" issalesorderVT :$$IsSalesOrder:$vouchertypename issalesVT :$$IsSales:$vouchertypename removedelivered brickbalance>0 or $closingbalance:ledger:$mponame brickbalance :$$abs:$b-$$Abs:$c-$$Abs:$s isboth :$$IsSalesOrder:$vouchertypename or $$IsSales:$vouchertypename
