Dear Experts, I wrote a code for the Broker Module in this Module I created 1. Brokers Masters 2. After saving the Sales/Purchase entry I created One auto JV for the respective Broker (Which is a Commission Payable Amount) 3. Then I wrote a report Broker Payable report as below But In this report, I need to show only the Broker Payable Bills of that particular Broker For Example In the above Screen Shoot Bill No: 1 - The brokerage Payable amount is 200 which is already paid to that Broker, so That bill I don't want to see here further transactions, Simple says my requirement is to the report which shows only Pending Brokerage Amount Bills only, Here I wrote the collection as follows: [Collection:BrokerpayblecollectionMain] Type:Vouchers Filter:isPurchse Fetchartyledgername, Date, Voucehrtypename,VoucherNumber,ReferenceDate,Reference,SalesRep Fetch:*.* [Collection:Brokerpayblecollection] Source Collection:BrokerpayblecollectionMain Walk:Inventoryentries Fetchartyledgername, Date, Voucehrtypename,VoucherNumber,ReferenceDate,Reference, SalesRep,StockItemName Fetch:*.* Filter:isSalesRep,FilterParty Filter:OnlyBrokeragepayable Compute:Chsled:$..SalesRep [System:Formula] isPurchse:$$IsPurchase:$VoucherTypeName isSalesRep : If ##ShowSalesRep = $$SysName:AllItems Then Yes Else $Chsled = ##ShowSalesRep OnlyBrokeragepayable: If ##ShowBrokeragereceivable Then $$IsDr:$ClosingBalance else Not $$IsDr:$ClosingBalance But the Filter : OnlyBrokeragepayable is not working Please help me regarding Thank you But
