Ledger Blocking Module

Discussion in 'Free Source Codes' started by Vikram Hiwale, Sep 27, 2019.

    
  1. Vikram Hiwale

    Vikram Hiwale New Member


    Dear Admin,


    I am try to Make Ledger blocking module.

    in one scenario i want to hide some ledger which i was block to user but i am trouble in formula.

    kindly check the formula

    when i logged in Admin user All Ledger shown properly

    when i logged in user longing All ledger shown "YYYY" but i need "YYYY" those ledger which i was block for user but here my all Ledger shown in "YYYY".



    Kindly check the formula as i set for "Day Book" Report



    [#Field: DSP VchAccount]

    Use : Name Field
    Style : Normal Bold
    QuickSearch : Yes
    FullWidth : Yes
    Width : @@ShortNameWidth

    Option : DSP VchCNCAccount : $$IsVoucher AND ($IsCancelled OR $IsDeleted)
    Option : DSP VchAccAccount : $$IsVoucher AND NOT $IsCancelled AND NOT $IsDeleted AND NOT @@IsVchInvVch
    Option : DSP VchInvAccount : $$IsVoucher AND NOT $IsCancelled AND NOT $IsDeleted AND @@IsVchInvVch
    Option : DSP VchForexGain : NOT $$IsVoucher
    Option : DSP VchAttdAccount: $$IsVoucher AND NOT $IsCancelled AND NOT $IsDeleted AND @@IsVchAttdVch
    Option : DSP VchMInAccount : $$IsVoucher AND NOT $IsCancelled AND NOT $IsDeleted AND @@IsJobMaterialTransferInVch
    Option : MYFORMULA :$$IsVoucher AND NOT $IsCancelled AND NOT $IsDeleted AND NOT @@IsVchInvVch

    [!Field:MYFORMULA]
    Set as : If $$IsCmpOwner Then $FirstLedger else @MYFIlter
    ;Style : Normal Italic
    Indent : 2
    MYFIlter :If $$FilterValue:mad:@ReqGodName:JLGLUserList:First:JLGlobalPassFilter then "YYYY" else $FirstLedger
     


Share This Page