Dear expert . I have created a report in which last column is total . before total column three more columns. i want these three field value added and shown in total column and total column value vertical added . how is possible? i did but not succeeded. pls see attachment. what i want to say and what i want ,would be clear. coding : [Field:Awb Amount] Use: Amount Field Storage:AwbAmount ;; Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo Set as:$$Table:AwbAwbNo:$CAmount [Field:Awb Covid] Use: Amount Field Storage:AwbCovid ;;Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo [Field:Awb FSC] Use: Amount Field Storage:AwbFSC ;;Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo [Field: AwbTotal ] Use: Amount Field Set as:#AwbAmount+#AwbCovid+#AwbFSC Storage:AwbTotal ;; Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo last total line; this is for vertical addition. [Line: Awb Total Line] Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local:Fieldefaultelete:Storage Local:Fieldefaultelete:Set as Local:Fieldefaultelete:Inactive Local:Field:default:Skip:Yes Local:Field:Awb Sl:Set as:"" Local:Field:Awb Sl:Format:"nozero" Local:Field: AwbAwbNo:Set as:$$LocaleString:"Totals" Local:Field: AwbAwbNoelete:Table Local:Field:AwbTotal:setas:$$total:AwbTotal pls advice thanks & Regards Rishi
Recheck your code....it requires collection in Total Have you make any collection in it? Also in this given code you have not given any UDF ....in storage If not share your code
This Is full code. I want to add value of these three field Value Awb Amount, Awb Covid, Awb FSC in Total field horizontal.... [Form:Awb Details] Part: Form Subtitle, Awb Part Local:Field:FormSubtitle:Info:$$LocaleString:"AWB Details of " + ":" + $PartyLedgerName Full Height:Yes Full Width:Yes [Part:Awb Part] Lines: Awb Title Line, Awb Details Line Bottom Line:Awb Total Line Repeat:Awb Details Line: Awb Details Coll Common Border:Yes Scroll:Vertical Float: No Border : Thin Box Total: Awb Total Break On: $$IsSysName:$AwbAwbNo [Line:Awb Title Line] Use:Awb Details Line Local:Fieldefaultelete:Storage Local:Fieldefaultelete:Set as Local:Fieldefaultelete:Inactive ;;Local:Fieldefaultelete:Use ;;Left Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination ;;Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local : Field : Default : Type: String ;;Local : Field : Default : Style: Small Bold Local : Field : Default : Align: Centre Local : Field : Default : Skip : Yes Local: Field: Awb Sl:Set as:$$LocaleString:"SL.No" Local:Field:Awb Awb No :Set as:$$LocaleString:"AWB No." Local:Field:Awb Date: Set as:$$LocaleString:"Date" Local:Field:Awb Destination:Set as:$$LocaleString:"Destination" Local:Field:Awb Network:Set as:$$LocaleString:"Network" Local:Field:Awb Ds:Set as:$$LocaleString:"D/s" Local:Field:Awb Weight:Set as:$$LocaleString:"Weight" Local:Field:Awb Amount:Set as:$$LocaleString:"Amount" Local:Field:Awb Covid:Set as:$$LocaleString:"Covid-19" Local:Field:Awb FSC:Set as:$$LocaleString:"FSC" Local:Field:Awb Total:Set as:$$LocaleString:"Total" Border: Thin bottom [Line:Awb Details Line] ;; Fields: Awb Sl, Awb Awb No, Awb Date, Awb Destination, Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local: Field: Default: Align: Centre [Field:Awb Sl] Use: Number Field Set as:$$Line Width: 3 ;;Style: Small Border : Thin Right Skip:Yes [Field:Awb Awb No] Use: Name Field Storage:AwbAwbNo Width:15 Border: Thin Right Table: AWB List Coll, End of List Show Table:Always Set Always:Yes Unique:Yes [Field:Awb Date] Use: Name Field Storage:AwbDate ;;Style:Small Width:10 Border:Thin Right Inactive:$$IsEnd:$AwbAwbNo Set as:$$Table:AwbAwbNo:$AWBILLDate [Field:Awb Destination] Use: Name Field Storage:AwbDestination ;;Style:Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo Set as:$$Table:AwbAwbNo:$Dest [Field: Awb Network] Use: Name Field Storage:AwbNetwork ;;Style:Small Border: Thin Right ;;Width:10 Inactive:$$IsEnd:$AwbAwbNo [Field:Awb Ds] Use: Name Field Storage:AwbDs ;; Style:Small Border: Thin Right Width:10 Inactive:$$IsEnd:$AwbAwbNo [Field:Awb Weight] Use: Name Field Storage:AwbWeight ;;Style:Small Border: Thin Right Width:10 Inactive:$$IsEnd:$AwbAwbNo Set as:$$Table:AwbAwbNo:$Weight [Field:Awb Amount] Use: Amount Field Storage:AwbAmount ;; Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo Set as:$$Table:AwbAwbNo:$CAmount [Field:Awb Covid] Use: Amount Field Storage:AwbCovid ;;Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo [Field:Awb FSC] Use: Amount Field Storage:AwbFSC ;;Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo [Field: AwbTotal ] Use: Amount Field Set as:#AwbAmount +#AwbCovid+#AwbFSC Storage:AwbTotal ;; Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo [Line: Awb Total Line] Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local:Fieldefaultelete:Storage Local:Fieldefaultelete:Set as Local:Fieldefaultelete:Inactive Local:Field:default:Skip:Yes Local:Field:Awb Sl:Set as:"" Local:Field:Awb Sl:Format:"nozero" Local:Field: AwbAwbNo:Set as:$$LocaleString:"Totals" Local:Field: AwbAwbNoelete:Table Local:Field:AwbTotal:setas:$$total:AwbTotal Local:Field: AwbFSC:Set as:"" Local:Field: Awbcovid:Set as:"" Local:Field: AwbAmount:Set as:"" Local:Field: Awbweight:Set as:"" Local:Field: Awb Ds:Set as:"" Local:Field: AwbNetwork:Set as:"" Local:Field: AwbDestination:Set as:"" Local:Field: AwbDate:Set as:"" Border:Thick Top [System: UDF] AwbAwbNo : String: 41002 AwbTotal: Amount:31002 AwbFSC: Amount:31003 AwbCovid:Amount:31004 AwbAmount:Amount:31006 AwbWeight:String:31005 AwbDs:String:31007 AwbNetwork:String:31008 AwbDestination:String:31009 AwbDate:String:31011 AwbDetailsColl:Aggregate:31012
Rishi Ji You have not sent me the whole code as it seems an error...pls send the tally data demo file and the actual code yo have made to recheck the issue...
full code: [#Menu:Gateway of tally] add: Item: before@locquit: Cust Awb Details: Alter:Awb Details [Report:Awb Details] Form:Awb Details Title: "Awb Details" Object: Company [Form:Awb Details] Part: Form Subtitle, Awb Part Local:Field:FormSubtitle:Info:$$LocaleString:"AWB Details of " Full Height:Yes Full Width:Yes [Part:Awb Part] Lines: Awb Title Line, Awb Details Line Bottom Line:Awb Total Line Repeat:Awb Details Line: Awb Details Coll Common Border:Yes Scroll:Vertical Float: No Border : Thin Box Total: Awb Total Break On: $$empty:$AwbAwbNo [Line:Awb Title Line] Use:Awb Details Line Local:Fieldefaultelete:Storage Local:Fieldefaultelete:Set as Local:Fieldefaultelete:Inactive ;;Local:Fieldefaultelete:Use ;;Left Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination ;;Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local : Field : Default : Type: String ;;Local : Field : Default : Style: Small Bold Local : Field : Default : Align: Centre Local : Field : Default : Skip : Yes Local: Field: Awb Sl:Set as:$$LocaleString:"SL.No" Local:Field:Awb Awb No :Set as:$$LocaleString:"AWB No." Local:Field:Awb Date: Set as:$$LocaleString:"Date" Local:Field:Awb Destination:Set as:$$LocaleString:"Destination" Local:Field:Awb Network:Set as:$$LocaleString:"Network" Local:Field:Awb Ds:Set as:$$LocaleString:"D/s" Local:Field:Awb Weight:Set as:$$LocaleString:"Weight" Local:Field:Awb Amount:Set as:$$LocaleString:"Amount" Local:Field:Awb Covid:Set as:$$LocaleString:"Covid-19" Local:Field:Awb FSC:Set as:$$LocaleString:"FSC" Local:Field:Awb Total:Set as:$$LocaleString:"Total" Border: Thin bottom [Line:Awb Details Line] ;; Fields: Awb Sl, Awb Awb No, Awb Date, Awb Destination, Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local: Field: Default: Align: Centre [Field:Awb Sl] Use: Number Field Set as:$$Line Width: 3 ;;Style: Small Border : Thin Right Skip:Yes [Field:Awb Awb No] Use: Name Field Storage:AwbAwbNo Width:15 Border: Thin Right ;;Table: AWB List Coll, End of List ;; Show Table:Always Set Always:Yes Unique:Yes [Field:Awb Date] Use: Name Field Storage:AwbDate ;;Style:Small Width:10 Border:Thin Right Inactive:$$IsEnd:$AwbAwbNo ;; Set as:$$Table:AwbAwbNo:$AWBILLDate [Field:Awb Destination] Use: Name Field Storage:AwbDestination ;;Style:Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo ;;Set as:$$Table:AwbAwbNo:$Dest [Field: Awb Network] Use: Name Field Storage:AwbNetwork ;;Style:Small Border: Thin Right ;;Width:10 Inactive:$$IsEnd:$AwbAwbNo [Field:Awb Ds] Use: Name Field Storage:AwbDs ;; Style:Small Border: Thin Right Width:10 Inactive:$$IsEnd:$AwbAwbNo [Field:Awb Weight] Use: Name Field Storage:AwbWeight ;;Style:Small Border: Thin Right Width:10 Inactive:$$IsEnd:$AwbAwbNo ;; Set as:$$Table:AwbAwbNo:$Weight [Field:Awb Amount] Use: Amount Field Storage:AwbAmount ;; Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo ;;Set as:$$Table:AwbAwbNo:$CAmount [Field:Awb Covid] Use: Amount Field Storage:AwbCovid ;;Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo [Field:Awb FSC] Use: Amount Field Storage:AwbFSC ;;Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo [Field: AwbTotal ] Use: Amount Field Set as:#AwbAmount +#AwbCovid+#AwbFSC ;;#AwbAmount+#AwbCovid+#AwbFSC Storage:AwbTotal ;; Style: Small Border: Thin Right Inactive:$$IsEnd:$AwbAwbNo [Line: Awb Total Line] Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local:Fieldefaultelete:Storage Local:Fieldefaultelete:Set as Local:Fieldefaultelete:Inactive Local:Field:default:Skip:Yes Local:Field:Awb Sl:Set as:"" Local:Field:Awb Sl:Format:"nozero" Local:Field: AwbAwbNo:Set as:$$LocaleString:"Totals" Local:Field: AwbAwbNoelete:Table Local:Field:AwbTotal:setas:$$total:AwbTotal Local:Field: AwbFSC:Set as:"" Local:Field: Awbcovid:Set as:"" Local:Field: AwbAmount:Set as:"" Local:Field: Awbweight:Set as:"" Local:Field: Awb Ds:Set as:"" Local:Field: AwbNetwork:Set as:"" Local:Field: AwbDestination:Set as:"" Local:Field: AwbDate:Set as:"" Border:Thick Top [System: UDF] AwbAwbNo : String: 41002 AwbTotal: Amount:31002 AwbFSC: Amount:31003 AwbCovid:Amount:31004 AwbAmount:Amount:31006 AwbWeight:String:31005 AwbDs:String:31007 AwbNetwork:String:31008 AwbDestination:String:31009 AwbDate:String:31011 AwbDetailsColl:Aggregate:31012 now check , enter data manually....
Rishi Ji After saving the entries the total will automatically get correct. So not to worry just make a trial if any problem then let me know ((( I have Created a Button for party ledger name for your kind reference if you require to use it in your code so just make the coding accordingly to include party ledger by using Variables, Collections, or Explode Collections ))) Below the code is correctly working....as per your requirement.. [#Menu:Gateway of Tally] Add: Item: AWB Details: Alter:Awb Details [Report:Awb Details] UseSP Template Form:Awb Details Set:FilterPartyNameRishi Variable : SV Print Orientation : String Repeat: AWB Summary details Title: "Awb Details" Object: Company [Form:Awb Details] Button : PrintButton, ExportButton Button : ExplodeFlag,ChangePeriod,PartyFilterBtn Bottom Toolbar Buttons : EnterKeyPMWEXP,BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10 Set Always : SV Print Orientation : "Landscape" Part: Form Subtitle, AWBPeriod, Awb Part Local:Field:FormSubtitle:Info:$$LocaleString:"AWB Details of " Local:Fieldefault : Color:Leaf Green Full Width:Yes Background:Misty Rose [Part:AWBPeriod] Line : AwbPeriod [Line:AwbPeriod] Right Field : Name Field Left Field : Simple Field Local : Field : Name Field : Info : @@DSPDateStr Local : Field : Name Field : Width : 20 Local : Field : Name Field : Align : Right Border : Thin Box Local : Field : Simple Field : Info: "AWB SUMMARY REPORT" Local : Field : Simple Field : Space Left:72 Local : Field : Simple Field : Style : Normal Bold [Key: EnterKeyPMWEXP] Key : Enter Title : $$LocaleString:"Explode" Type : BottomToolBarBtn2 Action : Explode [ButtonartyFilterBtn] Key : F6 Action : Execute : PartySUMMARYWise Title : Party Name Background:Goodwill3 Color:Yellow [ReportartySUMMARYWise] Form : PartySUMMARYWise [FormartySUMMARYWise] Part : PartySUMMARYWise Space Left : 2 mms Space Right : 2 mms [PartartySUMMARYWise] Line : PartySUMMARYWise [LineartySUMMARYWise] Field : Medium Prompt,PartyItemMonthSUMMARYWise Local : Field : Medium Prompt : Set as : "Select Party Name:" Space Bottom : 2 mms [FieldartyItemMonthSUMMARYWise] Table : Myfilterledger,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterPartyNameRishi Modifies : FilterPartyNameRishi [Collection: Myfilterledger] Type: Ledger BelongsTo: Yes [Part:Awb Part] Lines: Awb Title Line, Awb Details Line Bottom Line:Awb Total Line Repeat:Awb Details Line: Awb Details Coll Common Border:Yes Scroll:Vertical Float: No Border : Thin Box Total: Awb Total Break On: $$IsSysName:$AwbAwbNo [Line:Awb Title Line] Use:Awb Details Line Local:Fieldefaultelete:Storage Local:Fieldefaultelete:Set as Local:Fieldefaultelete:Inactive ;;Local:Fieldefaultelete:Use ;;Left Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination ;;Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local : Field : Default : Type: String ;;Local : Field : Default : Style: Small Bold Local : Field : Default : Align: Centre Local : Field : Default : Skip : Yes Local : Field : Default : Color:Goodwill3 Local: Field: Awb Sl:Set as:$$LocaleString:"S.No" Local:Field:Awb Awb No :Set as:$$LocaleString:"AWB No." Local:Field:Awb Date: Set as:$$LocaleString:"Date" Local:Field:Awb Destination:Set as:$$LocaleString:"Destination" Local:Field:Awb Network:Set as:$$LocaleString:"Network" Local:Field:Awb Ds:Set as:$$LocaleString:"D/s" Local:Field:Awb Weight:Set as:$$LocaleString:"Weight" Local:Field:Awb Amount:Set as:$$LocaleString:"Amount" Local:Field:Awb Covid:Set as:$$LocaleString:"Covid-19" Local:Field:Awb FSC:Set as:$$LocaleString:"FSC" Local:Field:Awb Total:Set as:$$LocaleString:"Total" Border: Thin bottom [Line:Awb Details Line] ;; Fields: Awb Sl, Awb Awb No, Awb Date, Awb Destination, Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local: Field: Default: Align: Centre Local : Field : Default : Color:Goodwill3 [Field:Awb Sl] Use: Name Field Set as:$$Line Width: if $$inprintmode then 3 else 4 ;;Style: Small Border : Thin Right Skip:Yes [Field:Awb Awb No] Use: Name Field Storage:AwbAwbNo Width:if $$inprintmode then 3 else 15 Border: Thin Right ;;Table: AWB List Coll, End of List ;; Show Table:Always Set Always:Yes Unique:Yes [Field:Awb Date] Use: Uni Date Field Storage:AwbDate Set as : $Date Format : "full Date" ;;Style:Small Width:if $$inprintmode then 3 else 15 Border:Thin Right ;Inactive:$$IsSysName:$AwbAwbNo ;; Set as:$$Table:AwbAwbNo:$AWBILLDate [Field:Awb Destination] Use: Name Field Storage:AwbDestination ;;Style:Small Width:if $$inprintmode then 3 else 15 Border: Thin Right ;Inactive:$$IsSysName:$AwbAwbNo ;;Set as:$$Table:AwbAwbNo:$Dest [Field: Awb Network] Use: Name Field Storage:AwbNetwork ;;Style:Small Border: Thin Right Width:if $$inprintmode then 3 else 15 ;Inactive:$$IsSysName:$AwbAwbNo [Field:Awb Ds] Use: Name Field Storage:AwbDs ;; Style:Small Border: Thin Right Width:if $$inprintmode then 3 else 15 ;Inactive:$$IsSysName:$AwbAwbNo [Field:Awb Weight] Use: Number Field Storage:AwbWeight Formatecimal:2 ;;Style:Small Border: Thin Right Width:if $$inprintmode then 3 else 15 ;Inactive:$$IsSysName:$AwbAwbNo ;; Set as:$$Table:AwbAwbNo:$Weight [Field:Awb Amount] Use: Number Field Storage:AwbAmount ;; Style: Small Set as:$Amount Formatecimal:2 Width:if $$inprintmode then 3 else 15 Border: Thin Right ;Inactive:$$IsSysName:$AwbAwbNo ;;Set as:$$Table:AwbAwbNo:$CAmount [Field:Awb Covid] Use: Number Field Storage:AwbCovid Formatecimal:2 Width:if $$inprintmode then 3 else 15 ;;Style: Small Border: Thin Right ;Inactive:$$IsSysName:$AwbAwbNo [Field:Awb FSC] Use: Number Field Storage:AwbFSC Width:if $$inprintmode then 3 else 15 Formatecimal:2 ;;Style: Small Border: Thin Right ;Inactive:$$IsSysName:$AwbAwbNo [Field: AwbTotal] Use: Number Field Set as:#AwbAmount + #AwbCovid + #AwbFSC ;;#AwbAmount+#AwbCovid+#AwbFSC Storage:AVbTotal Formatecimal:2 Width:if $$inprintmode then 3 else 15 Set Always:Yes ;; Style: Small Border: Thin Right ;Inactive:$$IsSysName:$AwbAwbNo Skip:Yes [Line: Awb Total Line] Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total Local:Fieldefaultelete:Storage Local:Fieldefaultelete:Set as Local:Fieldefaultelete:Inactive Local:Fieldefault:Skip:Yes Local:Fieldefault:Align:Center Local: Field:Awb Sl:Set as:"" Local:Field:Awb Awb No :Set as:"Net Total" Local:Field:Awb Date: Set as:"" Local:Field:Awb Destination:Set as:"" Local:Field:Awb Network:Set as:"" Local:Field:Awb Ds:Set as:"" Local:Field:Awb Weight:Set as:"" Local:Field:Awb Amount:Set as:"" Local:Field:Awb Covid:Set as:"" Local:Field:Awb FSC:Set as:"" Local:Field:Awb Total:Set as:$$Total:Awbtotal Border:Totals [System: UDF] AwbAwbNo : String: 2697 AwbDestination:String:3187 AwbNetwork:String:3177 AwbDs:String:3136 AwbWeight:Number:3144 AwbAmount:Number:3587 AwbCovid:Number:5569 AwbFSC: Number:7897 AwbTotal: Number:7789 AwbDateate:3109 AwbDetailsColl:Aggregate:3191 [Color:Goodwill3] RGB:175,0,0 [Color:Misty Rose] RGB:255,228,225 [Variable: AWB Summary Details] Type : String Repeat : ##DSPRepeatCollection [Variable:FilterPartyNameRishi] Type : String ;;;;;; if you want to use the party ledger list use coding on your own or by using these below coding... /* [PartMWEXPExplode] Line : PMWEXPExplode Repeat : PMWEXPExplodeMWEXPPartyExplode Border : Thin Bottom [LineMWEXPExplode] Use : PMWEXPDetails Delete : Border Local : Field : PMWEXPSno : Set as : "" ;$$Line Local : Field : Default : Style : Normal Local : Field : Default : Color : red Local : Field : PMWEXPPartyNameHarryExpPMWEXP : Set as : $ItemNameHarry Local : Field : PMWEXPPartyNameHarryExpPMWEXP : Align : Justified Local : Field : PMWEXPAprQty : Set as : $itemQtyAprPMWEXP Local : Field : PMWEXPMayQty : Set as : $itemQtyMayPMWEXP Local : Field : PMWEXPQtyJunPMWEXP : Set as : $ItemQtyJunPMWEXP Local : Field : PMWEXPJulQty : Set as :$ItemQtyJulPMWEXP Local : Field : PMWEXPAugQty : Set as : $ItemQtyAugPMWEXP Local : Field : PMWEXPSepQty : Set as :$ItemQtySepPMWEXP Local : Field : PMWEXPOctQty : Set as : $ItemPMWEXPOctQty Local : Field : PMWEXPnovQty : Set as : $ItemPMWEXPnovQty Local : Field : PMWEXPdecQty : Set as : $ItemPMWEXPdecQty Local : Field : PMWEXPjanQty : Set as : $ItemPMWEXPjanQty Local : Field : PMWEXPfebQty : Set as :$ItemPMWEXPfebQty Local : Field : PMWEXPmarQty : Set as : $ItemPMWEXPmarQty Local : Field : PMWEXPTotal : Set as : $itemPMWEXPTotalQty [CollectionMWEXPPartyWise] Source Collection : PMWEXP Voucher Walk : ledger Entries By : PartyNameHarryExpPMWEXP : $LedgerName Aggr Compute: QtyAprPMWEXP : Sum :If @@PMWEXPmonthFilterapr Then $Amount Else 0 Aggr Compute: QtyMayPMWEXP : Sum :If @@PMWEXPmonthFiltermay Then $Amount Else 0 Aggr Compute : QtyJunPMWEXP : Sum :If @@PMWEXPmonthFilterjun Then $Amount Else 0 Aggr Compute : QtyJulPMWEXP : Sum :If @@PMWEXPmonthFilterjul Then $Amount Else 0 Aggr Compute : QtyAugPMWEXP : Sum :If @@PMWEXPmonthFilteraug Then $Amount Else 0 Aggr Compute : QtySepPMWEXP : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFiltersep Then $Amount Else 0 Aggr Compute : PMWEXPOctQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilteroct Then $Amount Else 0 Aggr Compute : PMWEXPnovQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilternov Then $Amount Else 0 Aggr Compute : PMWEXPdecQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterdec Then $Amount Else 0 Aggr Compute : PMWEXPjanQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterjan Then $Amount Else 0 Aggr Compute : PMWEXPfebQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterfeb Then $Amount Else 0 Aggr Compute : PMWEXPmarQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFiltermar Then $Amount Else 0 Aggr Compute : TotAmount : Sum : If @@VoucherFilterExpPMWEXP Then $Amount Else 0 Sort : Default : $PartyNameHarryExpPMWEXP Filter : iexpPMWEXP [CollectionMWEXPPartyExplode] Source Collection : PMWEXP Voucher Walk : ledger Entries By : PartyNameHarryExpPMWEXP : $LedgerName By : ItemNameHarry : $vouchernumber Aggr Compute : itemQtyAprPMWEXP : Sum :If @@PMWEXPmonthFilterapr Then $Amount Else 0 Aggr Compute : itemQtyMayPMWEXP : Sum :If @@PMWEXPmonthFiltermay Then $Amount Else 0 Aggr Compute : itemQtyJunPMWEXP : Sum :If @@PMWEXPmonthFilterjun Then $Amount Else 0 Aggr Compute : itemQtyJulPMWEXP : Sum :If @@PMWEXPmonthFilterjul Then $Amount Else 0 Aggr Compute : itemQtyAugPMWEXP : Sum :If @@PMWEXPmonthFilteraug Then $Amount Else 0 Aggr Compute : itemQtySepPMWEXP : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFiltersep Then $Amount Else 0 Aggr Compute : itemPMWEXPOctQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilteroct Then $Amount Else 0 Aggr Compute : itemPMWEXPnovQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilternov Then $Amount Else 0 Aggr Compute : itemPMWEXPdecQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterdec Then $Amount Else 0 Aggr Compute : itemPMWEXPjanQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterjan Then $Amount Else 0 Aggr Compute : itemPMWEXPfebQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterfeb Then $Amount Else 0 Aggr Compute : itemPMWEXPmarQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFiltermar Then $Amount Else 0 Aggr Compute : itemPMWEXPTotalQty : Sum : If @@VoucherFilterExpPMWEXP Then $Amount Else 0 Filter : PMWEXPExplodeFilter Sort : Default : $ItemNameHarry [System : Formula] iexpPMWEXP : $$IsLedOfGrp:$PartyNameHarryExpPMWEXP:$$GroupDirectExpenses or $$IsLedOfGrp:$PartyNameHarryExpPMWEXP:$$GroupIndirectExpenses iexpPMWEXPl : $$IsLedOfGrp:$name:$$GroupIndirectExpenses or $$IsLedOfGrp:$name:$$GroupIndirectExpenses VoucherFilterExpPMWEXP : $$IsPayment:$VoucherTypeName or $$IsJournal:$VoucherTypeName or $$IsPurchase:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName PMWEXPmonthFilterapr : $$MonthOfDate:$Date>=4 and $$MonthOfDate:$Date<=4 PMWEXPmonthFiltermay : $$MonthOfDate:$Date>=5 and $$MonthOfDate:$Date<=5 PMWEXPmonthFilterjun : $$MonthOfDate:$Date>=6 and $$MonthOfDate:$Date<=6 PMWEXPmonthFilterjul : $$MonthOfDate:$Date>=7 and $$MonthOfDate:$Date<=7 PMWEXPmonthFilteraug : $$MonthOfDate:$Date>=8 and $$MonthOfDate:$Date<=8 PMWEXPmonthFiltersep : $$MonthOfDate:$Date>=9 and $$MonthOfDate:$Date<=9 PMWEXPmonthFilteroct : $$MonthOfDate:$Date>=10 and $$MonthOfDate:$Date<=10 PMWEXPmonthFilternov : $$MonthOfDate:$Date>=11 and $$MonthOfDate:$Date<=11 PMWEXPmonthFilterdec : $$MonthOfDate:$Date>=12 and $$MonthOfDate:$Date<=12 PMWEXPmonthFilterjan : $$MonthOfDate:$Date>=1 and $$MonthOfDate:$Date<=1 PMWEXPmonthFilterfeb : $$MonthOfDate:$Date>=2 and $$MonthOfDate:$Date<=2 PMWEXPmonthFiltermar : $$MonthOfDate:$Date>=3 and $$MonthOfDate:$Date<=3