I try to getting the report of student fees dues. I set fees allocation field in student master for getting the value of student fees allocation amount in fees due report allotment column.(attached screenshot) I will be set student selection field in receipt voucher for getting the value of student fees paid in fees due report paid column.. First, I need help to getting the value of student fees allocation amount in fees due report allotment auto column. Please correct my code. [#Menu:Gateway of Tally] Add :Item : Fees Dues : Display : FeesduesReport [Report: FeesduesReport] Title : $$LocaleString:"Fees Dues Report" Use : Daybook Delete : Form Add : Form : FeesDuesReport Repeat : PName Variable : DoSetAutoColumn, PName Set : DoSetAutoColumn : Yes Set : DSPRepeatCollection : "Fees Heads" Title : " Fees Dues Report" Delete : Print [Form: FeesDuesReport] Button : F2ChangePeriod, ChangeCompany Keys : ChangePeriod BottomButton: BlankButton Buttons : PrintButton, ExportButton, UploadButton, MailButton Parts : FeesDuesReportTop,FeesDuesReportTitle, FeesDuesReportDetails Height : 100% Page Width : 100% Page Space Top : 0 Space Left : 0 Background : Released Pale Yellow Option : Set Auto Vch Option1 : ##DoSetAutoColumn AND $$SetAutoColumnsName [!Form: Set Auto Vch Option1] [Part:FeesDuesReportTop] Line : FeesDuesReportTop Space Bottom: .5 Space Top : .5 [Line:FeesDuesReportTop] Right Field : DSP MainDateTitle [Part: FeesDuesReportTitle] Lines : FeesDuesReportTitle, FeesDuesReportTitle1 Border : Thin Top Bottom Total : FeesAllotedTotal,FeesPaidTotal,FeesBalanceTotal [Line: FeesDuesReportTitle] Fields : Name Field, FeesDuesReportAllotedAmt,FeesAllotedTotal Local : Field : Default : Type : String Local : Field : Name Field : Set as : $$LocaleString:"Particulars" Local : Field : Name Field : Align : Center Local : Field : FeesDuesReportAllotedAmt : Align : Centre Local : Field : FeesDuesReportAllotedAmt : Border : Left Full Thin Bottom Local : Field : FeesDuesReportAllotedAmt : Set as : ##Pname Local : Field : FeesAllotedTotal : Set as : "Total" Local : Field : FeesAllotedTotal : Align : Centre Local : Field : FeesAllotedTotal : Border : Left Full Thin Bottom Repeat : FeesDuesReportAllotedAmt [Line: FeesDuesReportTitle1] Fields : Name Field, FeesDuesReportDetailsAmt,FeesTotal Local : Field : Default : Style : Normal Local : Field : Default : Align : Centre Local : Field : Default : Type : String Local : Field : Name Field : Set as : "" Local : Field : FeesDuesReportAllotedAmt : Set as : $$LocaleString:"Alloted" Local : Field : FeesDuesReportpaidAmt : Set as : $$LocaleString:"Paid" Local : Field : FeesDuesReportBalanceAmt : Set as : $$LocaleString:"Balance" Local : Field : FeesAllotedTotal : Set as : $$LocaleString:"Alloted" Local : Field : FeesPaidTotal : Set as : $$LocaleString:"Paid" Local : Field : FeesBalanceTotal : Set as : $$LocaleString:"Balance" Local : Field : FeesDuesReportpaidAmt : Border : Left Full Thin Bottom Local : Field : FeesDuesReportBalanceAmt : Border : Thin Left Local : Field : FeesDuesReportBalanceAmt : Border : Thin Left Repeat : FeesDuesReportDetailsAmt Border : Thin Bottom [Part: FeesDuesReportDetails] Lines : FeesDuesReportDetails BottomLines : FeesDuesReportTotal Repeat : FeesDuesReportDetails : AutoAutoCol TB GroupLed Total : FeesDuesReportAllotedAmt,FeesAllotedTotal,FeesPaidTotal,FeesBalanceTotal Option : AlteronEnter Scroll : Vertical CommonBorder: Yes Float : No Total : FeesTotal,FeesDuesReportAllotedAmt,FeesDuesReportPaidAmt,FeesDuesReportbalanceAmt [Line:FeesDuesReportDetails] Fields : FeesDuesReportName, FeesDuesReportDetailsAmt,FeesTotal Total : FeesDuesReportAllotedAmt, FeesDuesReportpaidAmt, FeesDuesReportBalanceAmt Repeat : FeesDuesReportDetailsAmt [Field: FeesDuesReportName] Use : Name Field Set as : $Name Alter : Ledger [Field: FeesDuesReportDetailsAmt] Fields : FeesDuesReportAllotedAmt, FeesDuesReportpaidAmt, FeesDuesReportBalanceAmt Border : Thin Left Local : Field : Default : Width: 10 [Field: FeesDuesReportAllotedAmt] Use : Amount Field setas : $$CollectionField:$StudentOpeningAmtMyFormula:StufeeCollLedger MyFormula : ##PName + #FeesDuesReportName Style : Normal [Field: FeesDuesReportpaidAmt] Use : Amount Field Border : Thin Left Style : Normal [Field: FeesDuesReportBalanceAmt] Use : Amount Field Style : Normal Set as : #FeesDuesReportAllotedAmt-#FeesDuesReportpaidAmt Border : Thin Left [Field:FeesTotal] Fields:FeesAllotedTotal,FeesPaidTotal,FeesBalanceTotal Border:THin Left Local : Field : Default : Width: 10 [Field:FeesAllotedTotal] Use : Amount Field Style : Normal Border : Thin Left Set as : $$Total:FeesDuesReportAllotedAmt [Field:FeesPaidTotal] Use : Amount Field Style : Normal Border : Thin Left Set as : $$Total:FeesDuesReportpaidAmt [Field:FeesBalanceTotal] Use : Amount Field Style : Normal Border : Thin LEft Set as : $$Total:FeesDuesReportBalanceAmt [Collection: AutoAutoCol TB GroupLed] Type : Ledger Child Of : $$GroupSundryDebtors Belongs To : yes [Line: FeesDuesReportTotal] Fields : FeesDuesReportName, FeesDuesReportDetailsAmt,FeesTotal Repeat : FeesDuesReportDetailsAmt Local : Field : Default : Style : Normal Bold Local : Field : FeesDuesReportName : Set as : "GRAND TOTAL" Local : Field : FeesDuesReportName : WideSpaced : Yes Local : Field : FeesDuesReportName : Align : Centre Local : Field : FeesDuesReportAllotedAmt : Set as : $$Total:FeesDuesReportAllotedAmt Local : Field : FeesDuesReportPaidAmt : Set as : $$Total:FeesDuesReportPaidAmt Local : Field : FeesDuesReportBalanceAmt :Set as : $$Total:FeesDuesReportBalanceAmt Local : Field : FeesAllotedTotal : Set as : $$Total:FeesAllotedTotal Local : Field : FeesPaidTotal : Set as : $$Total:FeesPaidTotal Local : Field : FeesBalanceTotal : Set as : $$Total:FeesBalanceTotal Border : Flush Totals Fixed : Yes Space Top : 1 [Collection: Fees Heads] Type : Ledger Compute : PName:$Name Filter : FeesHead [System: Formulae] Feeshead : $Feeshead [Collection: StufeeCollLedger] Type : Ledger compute : PName : $name Compute : IName : $LedgerName ;;END OF FILE ;;;;;;;;;;;;;;;;;;;USE FOR DUES REPORT;;;;;;;;;;;;;;;;; [#Part: LED Other Details] Add:Line:After:LED IT No:LED Fees Head [Line:LED Fees Head] Field:Medium Prompt,LED Fees Head Local:Field:Medium Prompt:Set as:$$LocaleString:"Use for Dues Report?" [Field:LED Fees Head] Use :Logical field Storage :Feeshead Set as :No ;;;;;;;;;;;;;;SET YEAR CURRENT YEAR FEES ALLOCATION;;;;;;;;;;;;;;;; [#Part: MST LED Explode Sundry] Add : Line : Before : LED IsBillWise : LED FS [Line:LED FS] Field : Long Prompt, LED FS Local : Field: Long Prompt : Info : $$LocaleString:"Set Current Year Fees Allocation?" [Field:LED FS] Use : Logical field Storage : FeesAlloc Set as : No Sub form : LEDFeesAlloc : $$Value [System: Formulae] Courselist : $Feeshead ;;;;;;;;;;;;;;;SUBFORM FOR STUDENT FEES DETAILS;;;;;;;;;;;;;;;;;; [Report:LEDFeesAlloc] Title : $$LocaleString:"Student Fees Allocation" [Form:LEDFeesAlloc] Background : @@SV_STOCK Height : 50% Screen FullWidth : No Part : LEDName Title, LEDName Details Horizontal Align: Left Vertical Align : Bottom [Part:LEDName Title] Line:LEDName Title,LEDName Title1 [Line:LEDName Title] Fields:Medium Prompt, SubTitle field Local :Field : Medium Prompt : Set as : $$LocaleString:"Student Name :" Local :Field : Medium prompt : Align : Center Local :Field : SubTitle field : Set as : $Name Local :Field : Medium prompt : Style : Normal Bold Local :field : SubTitle field : Style : Normal [Line:LEDName Title1] Left Field :Name field Right Field :Short Name field Local :Field : Name field : Set as : "Particulars" Local :Field : Name field : Border : Thin Right Local :Field : Name field : Width : 30 Local :Field : Name field : Skip : Yes Local :Field : Name field : Align : Left Local :Field : Short Name field : Set as : "Amount" Local :Field : Short Name field : Skip : Yes Local :Field : Short Name field : Align : Right Border :Thin Top Bottom [Part:LEDName Details] Line : LED Name Det Bottom Line : LED Amt Total Total : Led Amt Repeat : LED Name Det:Courselist Break : $$IsSysName:$StuFeesHead Scroll : Vertical Common Border : Yes [Line:LED Name Det] Fields:LED Part,LED Amt [Field:LED Part] Use : Name field Table : Courselist, End of List Show Table : Always Storage : StuFeesHead Width : 30 Style : Small Italic Border : Thin Right [Field:Led Amt] Use : Amount field Storage : Studentopeningamt Style : Small Italic Inactive : $$IsSysName:$StuFeesHead Width : 15 [Line:LED Amt Total] Field : Simple field Right Field : Amount field Local : Field: Simple field : Set as : "Total" Local : Field: Amount Field : Set as : $$Total:LedAmt Local : Field: Simple field : Skip : Yes Local : Field: Amount field : Skip : Yes Border :Thin Top Bottom [Collection: Courselist] Title : "List of Course Fees Heads" Type : Ledger ;: Company ; Child Of : ##SVCurrentCompany Format : $Name,25 Filter : Courselist [System:UDF] Feeshead : Logical : 36002 StuFeesHead : String : 9599 Studentopeningamt : Amount : 9594 Courselist : Aggregate : 902 ;;;;;;;;;;;;VARIBLES;;;;;;;;;;;; [Variable: PName] Type : String Repeat : ##DSPRepeatCollection ;;END OF FILE
Dear Expert, Please help to correct this code [Field: FeesDuesReportAllotedAmt] Use : Amount Field setas : $$CollectionField:$StudentOpeningAmtMyFormula:StufeeCollLedger MyFormula : ##PName + #FeesDuesReportName Style : Normal
Replace the code below at the alloted field in the report get back to me when you are done with student selection field in the receipt voucher Email - kosikondo321@gmail.com wassup - 0242037182 Ghana [Field: FeesDuesReportAllotedAmt] Use : Amount Field ;;Set as : $$CollectionField:$StudentOpeningAmtMyFormula:StufeeCollLedger Set as :$$CollectionField:$StudentOpeningAmt:Ledger:Courselist MyFormula : ##PName + #FeesDuesReportName Style : Normal
Sorry use this at same field not alloted field. get back to me when you are done with student selection field in the receipt voucher Email - kosikondo321@gmail.com wassup - 0242037182 Ghana [Field: FeesDuesReportAllotedAmt] Use : Amount Field ;;Set as :$$CollectionField:$StudentOpeningAmtMyFormula:StufeeCollLedger Set as:$$CollectionField:$StudentOpeningAmt:Ledger:Courselist MyFormula : ##PName +#FeesDuesReportName Style : Normal
I have tried various alternatives but not able to fix the problem. main reason is .. UDF is aggregate collection in this tdl, and I don't know how to get value from aggregate collection to ledger object using [#Object : Ledger] had it been simple UDF then it would have been as simple as shown by @Amit Kamdar change as suggested by Kosi would work only when Ledger Object is modified to include values stored in aggregate UDF. hope my explanation would help some experts to come up with solution.
[Field: FeesDuesReportAllotedAmt] Use : Amount Field setas : $$CollectionField:$StudentOpeningAmt1:StufeeCollLedger Style : Normal I tried this method, got value from single ledger of aggregate collection and how to get value from all ledger aggregate collection. Please guide to correct method...