1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Fee Dues report

Discussion in 'Tally Developer' started by Sakthi 2018, Dec 24, 2018.

    
Tags:
  1. Sakthi 2018

    Sakthi 2018 New Member


    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 $$SetAutoColumns:pName

    [!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:$StudentOpeningAmt:mad:MyFormula: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
     
    Sakthi 2018, Dec 24, 2018
    #1


  2. Sakthi 2018

    Sakthi 2018 New Member


    Dear Expert,
    Please help to correct this code

    [Field: FeesDuesReportAllotedAmt]

    Use : Amount Field
    setas : $$CollectionField:$StudentOpeningAmt:mad:MyFormula:StufeeCollLedger
    MyFormula : ##PName + #FeesDuesReportName
    Style : Normal
     
    Sakthi 2018, Dec 25, 2018
    #2


  3. kosi

    kosi Member


    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:$StudentOpeningAmt:mad:MyFormula:StufeeCollLedger
    Set as :$$CollectionField:$StudentOpeningAmt:Ledger:Courselist
    MyFormula : ##PName + #FeesDuesReportName
    Style : Normal
     
    kosi, Dec 27, 2018
    #3


  4. kosi

    kosi Member


    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:$StudentOpeningAmt:mad:MyFormula:StufeeCollLedger
    Set as:$$CollectionField:$StudentOpeningAmt:Ledger:Courselist
    MyFormula : ##PName +#FeesDuesReportName
    Style : Normal
     
    kosi, Dec 27, 2018
    #4


  5. Sakthi 2018

    Sakthi 2018 New Member


    Dear sir,
    Above field is working, but the values not getting related feeswise
     
    Sakthi 2018, Dec 28, 2018
    #5


  6. kosi

    kosi Member


    Show screen shorts for better clarification for feeswise
     
    kosi, Dec 28, 2018
    #6


  7. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    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.
     
    Devendra_Rawat, Jan 10, 2019
    #7


  8. Sakthi 2018

    Sakthi 2018 New Member


    [Field: FeesDuesReportAllotedAmt]

    Use : Amount Field
    setas : $$CollectionField:$StudentOpeningAmt:mad:1: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...
     
    Sakthi 2018, Jan 15, 2019
    #8


  9. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Before that

    give definition of StufeeColLedger
     
    Devendra_Rawat, Jan 15, 2019
    #9


  10. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Has your query been solved ?
     
    Devendra_Rawat, Feb 13, 2019
    #10


  11. Sakthi 2018

    Sakthi 2018 New Member


    Yes sir...
     
    Sakthi 2018, Feb 14, 2019
    #11


Share This Page