Dear All, I need to filter a specific Cash Ledgers for a particular User at the Reciept Entry. I tried but its not working. Kindly Help. [#Collection: Cash Ledgers Extract] Add : Option : TVCASH : $$IsReceipt:##SVVoucherType AND $$CmpUserName = "TRS" [!Collection: TVCASH] Use: Extract Alias Collection Title : $$LocaleString:"ONLY TRS ALLOWED" Source Collection: Ledgers Src Parm Var: GroupCash: String: $$GroupCash Fetch: Name, ReserveName Keep Source: (). Client Only: Yes Filter: ISTVCASH [System:Formula] ISTVCASH: $ReserveName = "Sanat M. Jani - Stores"
Dear Taufeeq, I am not sure but you can try this, [*Collection: Cash Ledgers Extract] Option : NOTTVCASH : NOT ($$IsReceipt:##SVVoucherType AND $$CmpUserName = "TRS") Option : TVCASH : $$IsReceipt:##SVVoucherType AND $$CmpUserName = "TRS" [!Collection : NOTTVCASH] Use : Extract Alias Collection Title : $$LocaleString:"List of Ledger Accounts" Source Collection : Ledgers Src Parm Var : GroupCash : String : $$GroupCash Parm Var : GroupBank : String : $$GroupBank Parm Var : GroupBankOD : String : $$GroupBankOD Fetch : Name, ReserveName Keep Source : (). Client Only : Yes Filter : IsCashBankAccountVchRE [!Collection: TVCASH] Use: Extract Alias Collection Title : $$LocaleString:"ONLY TRS ALLOWED" Source Collection: Ledgers Src Parm Var: GroupCash: String: $$GroupCash Fetch: Name, ReserveName Keep Source: (). Client Only: Yes Filter: ISTVCASH [System:Formula] ISTVCASH: $ReserveName = "Sanat M. Jani - Stores"
Maulik Bhai it didn't work but thanks a lot for helping. I just changed the concept and get success. Just see the below code. [#Form: Receipt Color] Add : Control : NotAllowed : $$FilterCount:AllLedgerEntries:Username < 1 [System: Formula] UserName : ($$CmpUserName = "TRS" AND $$IsReceipt:$VoucherTypeName And @@TRSDebited) OR + ($$CmpUserName = "RMD" AND $$IsReceipt:$VoucherTypeName And @@RMDDebited) TRSDebited: $$IsDr:$Amount AND $LedgerName = "Sanat M. Jani - Stores" RMDDebited: $$IsDr:$Amount AND $LedgerName = "CASH" NoTAllowed : $$LocaleString:" You are Not Authorized for this Ledger "
The same can be given at Field Level also to set direct control at field level. For Eg : [#Field: ACLSFixedLed] Add : Control : NotAllowed : $$FilterCount:AllLedgerEntries:Username < 1
Dear sir i have Cashier 1 under cash in hand and Cashier 1 under godown etc. and i want display cash with godwon in the same report can u help me i want field to can add cash ledger when i open any godown and collect cash with item stock in godown pls help me