Filter CostCenter in DayBook

Discussion in 'Free Source Codes' started by ITDept, Jun 25, 2016.

    
  1. ITDept

    ITDept New Member


    Dear All,
    I am new in Tally TDL. I can add a Button in Tally Day Book[​IMG] Report using the following code.But i don't know how to filter the daybook using its costcenter. Any body can help me , please correct my code.

    [#Form: Day Book[​IMG]]
    Add : Button : MyCCenterFltBtn

    [Button : MyCCenterFltBtn]
    Action : Execute : MyCCenterFltRep
    Title : $$LocaleString:"Chg CostCenter"
    Key : Alt + F3
    ;InActive : $$CmpUserLevel Not = "Owner"

    [Report : MyCCenterFltRep]
    Form : MyCCenterFltFrm
    Title : $$LocaleString:"Select Cost Center"

    [Form : MyCCenterFltFrm]
    No Confirm : Yes
    Part : MyCCenterFltPrt

    [Part : MyCCenterFltPrt]
    Line : MyCCenterFltLn1

    [Line : MyCCenterFltLn1]
    Field : Medium Prompt, NameEntered1
    Local : Field : Medium PRompt : Info : "Choose CostCenter"

    [Field : NameEntered1]
    Use : Name Field
    Table: CostCentreColl
    ShowTable: Always
    Variable : MyNameFld
    Modifies : MyNameFld


    [Variable : MyNameFld]
    Type : string
    Persistent : No

    [System : Variable]
    MyNameFld : ""

    [Collection: CostCentreColl]
    Type : Cost Centre
    Fetch : Name

    [Collection : MyVouchers]
    Type : Voucher
    Fetch : *, LedgerEntries.CATEGORYALLOCATIONS.COSTCENTREALLOCATIONS.*
    [#Collection : Vouchers of Company]
    Add : Filter : FeedDateFilter

    [System : Formula]

    FeedDateFilter :
     


  2. papaforu

    papaforu New Member


    #MyNameFld=$CostecentreName
    Add costcentreName in Daybook Collection.
     


Share This Page