Code: [Part:WEXPDetailsClosingcashinhand] Line : WEXPHead4,WEXPDetails4 BottomLines : WEXPTotals4 Repeat : WEXPDetails4:WEXPPartyWise4 Scroll : Vertical Total : WEXPAprQty4,WEXPMayQty4,WEXPQtyJunWEXP4, WEXPJulQty4, WEXPAugQty4, WEXPSepQty4,WEXPOctQty4,WEXPnovQty4,WEXPdecQty4,WEXPjanQty4,WEXPfebQty4,WEXPmarQty4,WEXPTotal4 Common Border : Yes [Line:WEXPHead4] Use : WEXPDetails4 Border : Column Titles Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Border : Thin Left Local : Field : Default : Style : NORMAL BOLD ;Local : Field : Default : Color : Geranium ;Local : Field : WEXPSno4 : Set as : "SNO" Local : Field : WEXPSno4 : Border : Thin Left Right Local : Field : WEXPPartyNameHarryExpWEXP4 : Set as : "CASH CLOSING BAL." Local : Field : Default : Background:Brilliant Lavender Local : Field : WEXPPartyNameHarryExpWEXP4 : Align : Left Local : Field : WEXPPartyNameHarryExpWEXP4 : Background:Yellow Local : Field : WEXPPartyNameHarryExpWEXP4 : Full Width:Yes Local : Field : WEXPAprQty4 : Set as : "APR" Local : Field : WEXPMayQty4 : Set as : "MAY" Local : Field : WEXPQtyJunWEXP4 : Set as: "JUN" Local : Field : WEXPJulQty4 : Set as : "JUL" Local : Field : WEXPAugQty4 : Set as : "AUG" Local : Field : WEXPSepQty4 : Set as : "SEP" Local : Field : WEXPOctQty4 : Set as : "OCT" Local : Field : WEXPnovQty4 : Set as : "NOV" Local : Field : WEXPdecQty4 : Set as : "DEC" Local : Field : WEXPjanQty4 : Set as : "JAN" Local : Field : WEXPfebQty4 : Set as : "FEB" Local : Field : WEXPmarQty4 : Set as : "MAR" Local : Field : WEXPTotal4 : Set as : "TOTAL" Local : Field : WEXPTotal4 : Border : Thin Left Right Space Top : 1.5 mms Space Bottom: 1.5 mms [Line:WEXPDetails4] Field : WEXPSno4,WEXPPartyNameHarryExpWEXP4 Right Field : WEXPAprQty4,WEXPMayQty4,WEXPQtyJunWEXP4, WEXPJulQty4, WEXPAugQty4, WEXPSepQty4,WEXPOctQty4,WEXPnovQty4,WEXPdecQty4,WEXPjanQty4,WEXPfebQty4,WEXPmarQty4,WEXPTotal4 Option : AlterOnEnter : $$IsVoucher Space Bottom: 0.5 mms Space Top : 0.5 mms Border : Thin Top Explode : WEXPExplode4 : ($$KeyExplode OR ##ExplodeFlag) [Field:WEXPDefault4] Use : Name Field Style : Normal Bold [Field:WEXPSno4] Use : WEXPDefault4 Set as : $$Line Width : if $$inprintmode then 4 else 4 Align : Center Border : Thin Left Right Style :small Color :red [Field:WEXPPartyNameHarryExpWEXP4] Use : WEXPDefault4 Set as : "Cash Closing Bal.";$PartyNameHarryExpWEXP4 Width : if $$inprintmode then 15 else 40 Quick Search: Yes Style:SMALL Color:ROYAL BLUE [Field:WEXPAprQty4] Use:amount field ;Use : Qty Field Format:"dr/cr" ;Type : Number Set as : $QtyAprWEXP4 Width : if $$inprintmode then 7 else 8 Border : Thin Left Right Style:small Color:blue [Field:WEXPMayQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set as : $QtyMayWEXP4 Width : if $$inprintmode then 7 else 8 Border : Thin Right Style:small Color:Red [Field: WEXPQtyJunWEXP4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $QtyJunWEXP4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:blue [Field: WEXPJulQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $QtyJulWEXP4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:Red [Field: WEXPAugQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $QtyAugWEXP4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:blue [Field: WEXPSepQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $QtySepWEXP4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:Red [Field: WEXPOctQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $WEXPOctQty4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:blue [Field: WEXPnovQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $WEXPnovQty4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:Red [Field: WEXPdecQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $WEXPdecQty4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:blue [Field: WEXPjanQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $WEXPjanQty4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:Red [Field: WEXPfebQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $WEXPfebQty4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:blue [Field: WEXPmarQty4] Use:amount field Format:"dr/cr" ;Use : Qty Field ;Type : Number Set As : $WEXPmarQty4 Border : Thin Right Width : if $$inprintmode then 7 else 8 Style:small Color:Red [Field:WEXPTotal4] Use:amount field Format:"dr/cr" ;Use : Qty Field Set as : $TotAmount4 ;Type : Number Width : if $$inprintmode then 7 else 8 Border : Thin Right Style:small bold Color:dark red [Line:WEXPTotals4] Border : Totals Use : WEXPDetails4 ;Local : Field : Default : Type : String Local : Field : Default : Align : Right Local : Field : Default : Style : Large Bold Local : Field : Default : Border : Thin Left Local:Field:DEFAULT:Use:AMOUNT FIELD Local : Field : Default:Format:"Dr/Cr" Local : Field : WEXPSno4 : Set as : "" Local : Field : WEXPPartyNameHarryExpWEXP4 : Set as : "TOTAL" Local : Field : WEXPPartyNameHarryExpWEXP4 : Align : Left ;Local : Field : WEXPPartyNameHarryExpWEXP4 : Background:YELLOW Local : Field : WEXPAprQty4 : Set as : $$Total:WEXPAprQty4 Local : Field : WEXPMayQty4 : Set as : $$Total:WEXPMayQty4 Local : Field : WEXPQtyJunWEXP4: Set as : $$Total:WEXPQtyJunWEXP4 Local : Field : WEXPJulQty4 : Set as : $$Total:WEXPJulQty4 Local : Field : WEXPAugQty4 : Set as : $$Total:WEXPAugQty4 Local : Field : WEXPSepQty4 : Set as : $$Total:WEXPSepQty4 Local : Field : WEXPOctQty4 : Set as : $$Total:WEXPOctQty4 Local : Field : WEXPnovQty4 : Set as : $$Total:WEXPnovQty4 Local : Field : WEXPdecQty4 : Set as : $$Total:WEXPdecQty4 Local : Field : WEXPjanQty4 : Set as : $$Total:WEXPjanQty4 Local : Field : WEXPfebQty4 : Set as : $$Total:WEXPfebQty4 Local : Field : WEXPmarQty4 : Set as : $$Total:WEXPmarQty4 Local : Field : WEXPTotal4 : Set as : $$Total:WEXPTotal4 Local : Field : WEXPTotal4 : Border : Thin Left Right Local : Field : WEXPTotal4 : Align : Right [Part:WEXPExplode4] Line : WEXPExplode4 Repeat : WEXPExplode4:WEXPPartyExplode4 Border : Thin Bottom [Line:WEXPExplode4] Use : WEXPDetails4 Delete : Border Local : Field : WEXPSno1 : Set as : $$Line Local : Field : Default : Style : Normal Local : Field : Default : Color : red Local : Field : Default :Border:THIN BOTTOM Local : Field : WEXPPartyNameHarryExpWEXP4 : Set as: $ItemNameHarry4 Local : Field : WEXPPartyNameHarryExpWEXP4 : Align : Justified Local : Field : WEXPAprQty4 : Set as : $itemQtyAprWEXP4 Local : Field : WEXPMayQty4 : Set as : $itemQtyMayWEXP4 Local : Field : WEXPQtyJunWEXP4: Set as : $ItemQtyJunWEXP4 Local : Field : WEXPJulQty4 : Set as : $ItemQtyJulWEXP4 Local : Field : WEXPAugQty4 : Set as : $ItemQtyAugWEXP4 Local : Field : WEXPSepQty4 : Set as : $ItemQtySepWEXP4 Local : Field : WEXPOctQty4 : Set as : $ItemWEXPOctQty4 Local : Field : WEXPnovQty4 : Set as : $ItemWEXPnovQty4 Local : Field : WEXPdecQty4 : Set as : $ItemWEXPdecQty4 Local : Field : WEXPjanQty4 : Set as : $ItemWEXPjanQty4 Local : Field : WEXPfebQty4 : Set as : $ItemWEXPfebQty4 Local : Field : WEXPmarQty4 : Set as : $ItemWEXPmarQty4 Local : Field : WEXPTotal4 : Set as : $itemWEXPTotalQty4 [System:Formula] WEXPFilter4 : $LedgerName=@@PartyLedgerWiseWEXP4 PartyLedgerWiseWEXP4: If $$IsEndOfList:##FilterPartyNameHarryExpWEXPWEXP4 or ##FilterPartyNameHarryExpWEXPWEXP4="" Then $LedgerName Else ##FilterPartyNameHarryExpWEXPWEXP4 WEXPExplodeFilter4 : $PartyNameHarryExpWEXP4=#WEXPPartyNameHarryExpWEXP4 WEXPExplodeFilterB4 : $PartyNameHarryExpWEXP4=#WEXPPartyNameHarryExpWEXP4 [Collection: WEXP Voucher4] Type : Vouchers;Type : Vouchers ;: VoucherType Fetch : date,VoucherTypeName,PartyLedgerName,Amount,PAYHEADNAME,Allledger Entries,Voucher Number,VoucherNumber,Reference,ledgername,amount,allledger Entries Childof : $$GroupCash [Collection:WEXPPartyWise4] Source Collection : WEXP Voucher4 Walk : ledger Entries By : PartyNameHarryExpWEXP4 : $LedgerName Aggr Compute : QtyAprWEXP4 : Sum :If @@WEXPmonthFilterapr4 Then $Amount Else 0 Aggr Compute : QtyMayWEXP4 : Sum :If @@WEXPmonthFiltermay4 Then $Amount Else 0 Aggr Compute : QtyJunWEXP4 : Sum :If @@WEXPmonthFilterjun4 Then $Amount Else 0 Aggr Compute : QtyJulWEXP4 : Sum :If @@WEXPmonthFilterjul4 Then $Amount Else 0 Aggr Compute : QtyAugWEXP4 : Sum :If @@WEXPmonthFilteraug4 Then $Amount Else 0 Aggr Compute : QtySepWEXP4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFiltersep4 Then $Amount Else 0 Aggr Compute : WEXPOctQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilteroct4 Then $Amount Else 0 Aggr Compute : WEXPnovQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilternov4 Then $Amount Else 0 Aggr Compute : WEXPdecQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilterdec4 Then $Amount Else 0 Aggr Compute : WEXPjanQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilterjan4 Then $Amount Else 0 Aggr Compute : WEXPfebQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilterfeb4 Then $Amount Else 0 Aggr Compute : WEXPmarQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFiltermar4 Then $Amount Else 0 Aggr Compute : TotAmount4 : Sum :If @@VoucherFilterExpWEXP4 Then $Amount Else 0 Sort : Default : $PartyNameHarryExpWEXP4 Filter: iexpWEXP4 [Collection:WEXPPartyExplode4] Source Collection: WEXP Voucher4 Walk : ledger Entries By : PartyNameHarryExpWEXP4 : $LedgerName By : ItemNameHarry4 : $PartyLedgerName Aggr Compute : itemQtyAprWEXP4 : Sum :If @@WEXPmonthFilterapr4 Then $Amount Else 0 Aggr Compute : itemQtyMayWEXP4 : Sum :If @@WEXPmonthFiltermay4 Then $Amount Else 0 Aggr Compute : itemQtyJunWEXP4 : Sum :If @@WEXPmonthFilterjun4 Then $Amount Else 0 Aggr Compute : itemQtyJulWEXP4 : Sum :If @@WEXPmonthFilterjul4 Then $Amount Else 0 Aggr Compute : itemQtyAugWEXP4 : Sum :If @@WEXPmonthFilteraug4 Then $Amount Else 0 Aggr Compute : itemQtySepWEXP4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFiltersep4 Then $Amount Else 0 Aggr Compute : itemWEXPOctQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilteroct4 Then $Amount Else 0 Aggr Compute : itemWEXPnovQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilternov4 Then $Amount Else 0 Aggr Compute : itemWEXPdecQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilterdec4 Then $Amount Else 0 Aggr Compute : itemWEXPjanQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilterjan4 Then $Amount Else 0 Aggr Compute : itemWEXPfebQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFilterfeb4 Then $Amount Else 0 Aggr Compute : itemWEXPmarQty4 : Sum :If @@VoucherFilterExpWEXP4 and @@WEXPmonthFiltermar4 Then $Amount Else 0 Aggr Compute : itemWEXPTotalQty4 :Sum :If @@VoucherFilterExpWEXP4 Then $Amount Else 0 Filter : WEXPExplodeFilter4 Sort : Default : $ItemNameHarry4 [System : Formula] iexpWEXP4 : $$IsLedOfGrp:$PartyNameHarryExpWEXP4:$$GroupCash or $$IsLedOfGrp:$PartyNameHarryExpWEXP4:$$GroupCASH iexpWEXPL4 : $$IsLedOfGrp:$name:$$GroupCash or $$IsLedOfGrp:$name:$$GroupCash VoucherFilterExpWEXP4 : $$IsJournal:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName or $$IsPayment:$VoucherTypeName or $$IsJournal:$VoucherTypeName or $$IsPurchase:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName or $$IsReceipt:$VoucherTypeName or $$IsContra:$VoucherTypeName WEXPmonthFilterapr4 : $$MonthOfDate:$Date>=4 and $$MonthOfDate:$Date<=4 WEXPmonthFiltermay4 : $$MonthOfDate:$Date>=5 and $$MonthOfDate:$Date<=5 WEXPmonthFilterjun4 : $$MonthOfDate:$Date>=6 and $$MonthOfDate:$Date<=6 WEXPmonthFilterjul4 : $$MonthOfDate:$Date>=7 and $$MonthOfDate:$Date<=7 WEXPmonthFilteraug4 : $$MonthOfDate:$Date>=8 and $$MonthOfDate:$Date<=8 WEXPmonthFiltersep4 : $$MonthOfDate:$Date>=9 and $$MonthOfDate:$Date<=9 WEXPmonthFilteroct4 : $$MonthOfDate:$Date>=10 and $$MonthOfDate:$Date<=10 WEXPmonthFilternov4 : $$MonthOfDate:$Date>=11 and $$MonthOfDate:$Date<=11 WEXPmonthFilterdec4 : $$MonthOfDate:$Date>=14 and $$MonthOfDate:$Date<=14 WEXPmonthFilterjan4 : $$MonthOfDate:$Date>=1 and $$MonthOfDate:$Date<=1 WEXPmonthFilterfeb4 : $$MonthOfDate:$Date>=4 and $$MonthOfDate:$Date<=4 WEXPmonthFiltermar4 : $$MonthOfDate:$Date>=4 and $$MonthOfDate:$Date<=4 [Variable: PartyNameHarryExpWEXP4] Type : String Repeat : ##DSPRepeatCollection [Variable:FilterPartyNameHarryExpWEXPWEXP4] Type : String [System:Variables] FilterPartyNameHarryExpWEXPWEXP4: "" [Color: Brilliant Lavender] RGB: 244,187,255
