गुरु पूर्णिमा की आप सभी को हार्दिक शुभकामनाए। सभी वरिष्ठों को एंव एडमीन सर का आभार समय समय पर मार्गदर्शन कर सहि ज्ञान देने के लिए।
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 : *.*