Need Help Create Budget Report & Expenses Report

गुरु पूर्णिमा की आप सभी को हार्दिक शुभकामनाए। सभी वरिष्ठों को एंव एडमीन सर का आभार समय समय पर मार्गदर्शन कर सहि ज्ञान देने के लिए।

 

to
All Tdl Export
i need Help for create report for Expenses against Budget for All Expenses Ledger i was problem to fetch expenses amount against particular ledger and cost center wise my code is below pl help the solve the problem thanks in advance


[#Menu : GateWay Of Tally]

Add : Item : Before : @@locDisplay : Budget Reportisplay: Budget Report

[Report: Budget Report]
Use : DSP Template
Title : "Budget Report"
Form : Budget Report
Set : SVFromDate : $$MonthStart:##SVFromDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate
Variable : SVFromDate, SVToDate
[Form: Budget Report]

Parts : Budget Report,Budget Details
Button : PrintButton, ExportButton,ChangePeriod

[Part: Budget Report]

Line : Budgethead

[Line : Budgethead]

Field: Ledname,Cstname,Budamt,Expamt,Per

Local: Field: Default : Style : Normal Bold
Local: Field: Default : Type : String
Local: Field: Default : Align : Center
Local: Field: Default : Line : 0
Local: Field: Ledname : Width : 45
Local: Field: Ledname : Border : Thin Right
Local: Field: Ledname : Type : String
Local: Field: Ledname : Set as : "Ledger Name"
Local: Field: CstName : Set as : "Cost Center"
Local: Field: CstName : Width : 20
Local: Field: CstName : Border : Thin Right
Local: Field: CstName : Type : String
Local: Field: Budamt : Set as : "Budget"
Local: Field: Budamt : Width : 15
Local: Field: Budamt : Border : Thin Right
Local: Field: Budamt : Type : String
Local: Field: Expamt : Set as : "Expenses"
Local: Field: Expamt : Width : 15
Local: Field: Expamt : Border : Thin Right
Local: Field: Expamt : Type : String
Local: Field: Per : Set as : "Per%"
Local: Field: Per : Width : 15
Local: Field: Per : Border : Thin Right
Local: Field: Per : Type : String

Border : Thick Top Bottom



[Part : Budgetdetails]
Line : SubBudgetdetails
Repeat : SubBudgetdetails : Brijesh
Scroll : Vertical
Common Borders : Yes
Total : Expamt

[Line : SubBudgetdetails]
Field: Ledname,Cstname,Budamt,Expamt,Per

[Field: Ledname]
Width : 45
Border : Thin Right
Type : String
Set as : $Name
[Field: Cstname]
Type : String
Width : 20
Border : Thin Right
Set as : $BudgetCostCentre
[Field: Budamt]
Width : 15
Border : Thin Right
Align : Right
Set as : $Amount
Format : "DrCr"
[Collection: My Ledgers]
Use : Voucher Collection
Walk: LedgerEntries, Category Allocations, Cost Centre Allocations
By : PartyLedgerName : $Ledname
By : Cost Centre Name: $BudgetCostCentre
Aggr Compute : Expamt : Sum: $Amount
Search Key : $Ledname + $BudgetCostCentre
[Field: Expamt]
Use : Amount Field
Width : 15
Border : Thin Right
Style : Small Bold
Set as : $$CollectionFieldByKey:$ExpamtMySearchKey:MyLedgers
MySearchKey : $Ledname + $BudgetCostCentre
Align : Right
Scroll : Yes
Format : "DrCr"
[Field: Per]
Use : Amount Field
Width : 15
Border : Thin Right
Style : Small Bold
Set as : ($Expamt*100)/$Budamt
Align : Right
Scroll : Yes

[Collection: Brijesh]
collection : bpt,
[Collection: brij]
Type : Budget
[Collection: bpt]
Source Collection : brij
Walk : Budget Periods,AccountingAllocations
Fetch : *.*