Help on Budget Report.

Discussion in 'Requests' started by zakirhossain_diu, Feb 29, 2020.

    

  1. Dear Experts,
    I am trying to get Report based on Budget Allocations.
    Reports are getting through Attached codes, Only one issue Just not getting Budget Name in Report.

    Anyone can help?

    Thank you
    [​IMG]
    Code:
    [#Menu : GateWay Of Tally]
       
        Add    : Item    : Before    : @@locDisplay    : test:Display: Custom Budget Reports
    
    [Report:Custom Budget Reports]
        Form: ShowBudget
       
    [Form: ShowBudget]
        Part: ShowBudgetBody
       
    [Part: ShowBudgetBody]
        Lines: ShowBudgetTitle, ShowBudgetBody
        Repeat:ShowBudgetBody: BudgetPeriodcoll ;BudgetLedgercoll ;BudgetPeriodcoll ;BudgetLedgercoll ;BudgetPeriodcoll ;detailBudgetcoll
        Scroll: Vertical
       
    [Line: ShowBudgetTitle]
        Field: short Name Field, STARTINGFROMs, ENDINGATs, Name Field, Amount Field
        Local: Field: Name Field: Set as:"LedgerName"
        Local: Field: Amount Field: Set as:"Amount"
        Local: Field: Default: Type: String
        Local: Field: short Name Field: Set as:"BudgetName"   
        Local: Field: ENDINGATs: Set as:"ENDINGAT"
        Local: Field: STARTINGFROMs: Set as:"STARTINGFROM"
       
    [Line: ShowBudgetBody]
        Field: short Name Field, STARTINGFROMs, ENDINGATs, Name Field, Amount Field
        Local: Field: Name Field: Set as:$LedgerName
        Local: Field: Amount Field: Set as:$Amount
        Local: Field: short Name Field: Set as:$xName
        Local: Field: ENDINGATs: Set as:$ENDINGAT
        Local:Field:STARTINGFROMs:set as:$STARTINGFROMs
    
    [Field: ENDINGATs]
        Use: Uni date Field
       
    [Field:STARTINGFROMs]
        Use: uni date field
    
       
    [Collection: CombineBudgetColl]
        Source Collection:BudgetPeriodcoll, BudgetLedgercoll   
        By                : Name:  $Name
        By                : LedgerName:$Name
        By                : ENDINGAT:$ENDINGAT
        By                : STARTINGFROMs:$STARTINGFROM
       
    ;    Compute                : ENDINGAT:$ENDINGAT
    ;    Compute                : STARTINGFROMs:$STARTINGFROM
       
         Aggr Compute    : Amount        : Sum    : $$AsAmount:$Amount
    
       
    [Collection: Budgetcoll]
        Type        : Budget
        Fetch        : Name
         Format        : $Name,30
    
       
    [Collection    : BudgetPeriodcoll]   
        Source Collection:  Budgetcoll
        Walk            :  Budget Periods, ACCOUNTINGALLOCATIONS
        By                : xName:  $Name
        By                : LedgerName:$Name
        By                : ENDINGAT:$ENDINGAT
        By                : STARTINGFROMs:$STARTINGFROM
    ;    Compute                : ENDINGAT:$ENDINGAT
    ;    Compute                : STARTINGFROMs:$STARTINGFROM
         Aggr Compute    : Amount        : Sum    : $$AsAmount:$Amount
        Fetch        : Name,StartingFrom, ENDINGAT
       
    ;   
    [Collection    : BudgetLedgercoll]   
        Source Collection:  BudgetPeriodcoll
        Walk            : Budget Periods, ACCOUNTINGALLOCATIONS
        By                : Name:  $xName
        By                : LedgerName:$Name
    ;    By                : ENDINGAT:$ENDINGAT
    ;    By                : STARTINGFROMs:$STARTINGFROM
    ;    Compute                : ENDINGAT:$ENDINGAT
    ;    Compute                : STARTINGFROMs:$STARTINGFROM
         Aggr Compute    : Amount        : Sum    : $$AsAmount:$Amount
        Fetch        : Name,StartingFrom, ENDINGAT
       
    
     


  2. Aniket Khatu

    Aniket Khatu New Member


    ;;Try this code

    [#Menu : GateWay Of Tally]

    Add : Item : Before : @@locDisplay : test:Display: Custom Budget Reports

    [Report:Custom Budget Reports]
    Form: ShowBudget

    [Form: ShowBudget]
    Part: ShowBudgetBody

    [Part: ShowBudgetBody]
    Lines: ShowBudgetTitle, ShowBudgetBody
    Repeat:ShowBudgetBody: BudgetPeriodcoll ;BudgetLedgercoll ;BudgetPeriodcoll ;BudgetLedgercoll ;BudgetPeriodcoll ;detailBudgetcoll
    Scroll: Vertical

    [Line: ShowBudgetTitle]
    Field: short Name Field, STARTINGFROMs, ENDINGATs, Name Field, Amount Field
    Local: Field: Name Field: Set as:"LedgerName"
    Local: Field: Amount Field: Set as:"Amount"
    Local: Field: Default: Type: String
    Local: Field: short Name Field: Set as:"BudgetName"
    Local: Field: ENDINGATs: Set as:"ENDINGAT"
    Local: Field: STARTINGFROMs: Set as:"STARTINGFROM"

    [Line: ShowBudgetBody]
    Field: short Name Field, STARTINGFROMs, ENDINGATs, Name Field, Amount Field
    Local: Field: Name Field: Set as:$LedgerName
    Local: Field: Amount Field: Set as:$Amount
    Local: Field: short Name Field: Set as:$xName
    Local: Field: ENDINGATs: Set as:$ENDINGAT
    Local:Field:STARTINGFROMs:set as:$STARTINGFROMs

    [Field: ENDINGATs]
    Use: Uni date Field

    [Field:STARTINGFROMs]
    Use: uni date field


    [Collection: CombineBudgetColl]
    Source Collection:BudgetPeriodcoll, BudgetLedgercoll
    By : Name: $Name
    By : LedgerName:$Name
    By : ENDINGAT:$ENDINGAT
    By : STARTINGFROMs:$STARTINGFROM

    ; Compute : ENDINGAT:$ENDINGAT
    ; Compute : STARTINGFROMs:$STARTINGFROM

    Aggr Compute : Amount : Sum : $$AsAmount:$Amount


    [Collection: Budgetcoll]
    Type : Budget
    Fetch : Name
    Format : $Name,30


    [Collection : BudgetPeriodcoll]
    Source Collection: Budgetcoll
    Walk : Budget Periods, ACCOUNTINGALLOCATIONS
    By : xName: $..Name
    By : LedgerName:$Name
    By : ENDINGAT:$ENDINGAT
    By : STARTINGFROMs:$STARTINGFROM
    ; Compute : ENDINGAT:$ENDINGAT
    ; Compute : STARTINGFROMs:$STARTINGFROM
    Aggr Compute : Amount : Sum : $$AsAmount:$Amount
    Fetch : Name,StartingFrom, ENDINGAT

    ;
    [Collection : BudgetLedgercoll]
    Source Collection: BudgetPeriodcoll
    Walk : Budget Periods, ACCOUNTINGALLOCATIONS
    By : Name: $xName
    By : LedgerName:$Name
    ; By : ENDINGAT:$ENDINGAT
    ; By : STARTINGFROMs:$STARTINGFROM
    ; Compute : ENDINGAT:$ENDINGAT
    ; Compute : STARTINGFROMs:$STARTINGFROM
    Aggr Compute : Amount : Sum : $$AsAmount:$Amount
    Fetch : Name,StartingFrom, ENDINGAT
     


Share This Page