Hello experts I am trying to generate a customized group summary. In the field TotQty, i need to fetch the total qty of a particular item purchased from the same party in the selected period. I have tried several ways but couldnt find a solution. can you help? thanks in advance. NB. there is only one stock item in the company [#Menu: Display Menu] add : Key Item : @@locMemberSummary : M : Display : Member Summary ;: @GroupSmmary [System : Formula] locMemberSummary : $$LocaleString:"Members Summary" [Report: Member Summary] Use: Group Summary Local: Line : DSP AccLine : Add : Fields : After : DSP AccName : NoOfShifts, TotQty ;After : DSP AccName : Set : groupname : "Members" Set : DSPShowOpening : Yes Set : DSPShowTrans : Yes Set : DSPShowNett : No Fetch Collection: InPartyList Use : TBAL Template Family : $$Translate:"Member Summary" List Name : $$LocaleString:"Member Summary" Set : IsTrialBalance : No Set : IsBankSummary : No PrintSet : PrintFileName : "MbrSum" Title : $$LocaleString:"Member Summary" Variable : IsGrpBillReport Set : IsGrpReport : Yes Set : IsGrpBillReport : No [Field: NoOfShifts] Use : Number Field Set as : @@TotBill Align : Right Format : "No Zero" Full Width : Yes [System : Formula] IsSameParty : $PartyLedgerName = #LedgerName TotBill : $$NumItemsartylast IsSamembr : $Name=#LedgerName mStk : ##StockitemName="Milk" [#Collection: InPartyList] Filter: IsSamembr [Collection : partylast] Type : Vouchers : VoucherType Child Of : "Purchase" Fetch : PartyLedgerName,VoucherNumber,amount,date,Reference,BilledQty Filter : IsSameParty Sort : @@Increasing : $date [Field: TotQty] Use : DSP QtyTemplate Set as : $$FilterValue:$TrPurcQty:InPartyList:1:mStk Set Always : Yes Inactive : No Width : 7
