Sir, as previously I have already mentioned in my above post. I have added a new Field See Image (Untitled) from my Voucher i.e Rental Charges of that party but I am getting Total Rental Charges for all the parties See the attachment (Untitled) Can you help me with the below Code (The amount should be Partywise as shown in Sales Service Voucher) but its talking monthly total of all the parties where it should come party wise Where I am going wrong? I have tried my level best but could not find the result Also my Header is not coming why ? Code: [Line: CFBK Rep Title] Use : CFBK Rep Details Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Style : Normal Bold Local : Field : Default : Background: Petal Pink Local : Field : Default : Color : Red Local : Field : CFBK Rep Name : Widespaced: Yes Local : Field : CFBK Rep Name : Set as : "Particulars" Local : Field : CFBK Rep Name : Width : 30 Local : Field : CFBK Led Amt : Set as : "Rent Charges" Local : Field : CFBK Led Amt : Width : 10 Local : Field : CFBK Rep Party : Delete : Fields Local : Field : CFBK Rep Party : Set as : ##IName Local : Field : CFBK Rep Party : Lines : 0 Local : Field : CFBK Rep Party : Border : Thin Left Local : Field : CFBK Rep Party : Color : Red Local : Field : CFBK Rep Col ATotal : Delete : Fields Local : Field : CFBK Rep Col ATotal : Widespaced: Yes Local : Field : CFBK Rep Col ATotal : Set as : "Total" Border : Flush Totals [Field: CFBK Led Amt] Fields : Vchsal Local : Field: Vchsal: Set as: $$CollAmtTotal:VchsaleAmt:$SalAmount [Collection: VchSaleAmt] Source Collection : CFBK Voucher Amt By : PName : $Partyledgername Aggr Compute : SalAmount : Sum : $IncomeAmt ;this is for net Monthly sale value [System: Formula] IsSalesSerVt: $$IsSales:$VoucherTypeName and $$IsEmpty:$InventoryEntries[1].StockItemName
Put a condition.......... in your compute inside the collection............ If $partyledgername = #CBKRepName then $Amount else 0
Thank you Amit Sir Once Again It's Done. Now I do not have to workout Manually everyone Month it just got easier with just click