Value not fetching

Discussion in 'Tally Developer' started by Sakthi 2018, Jan 6, 2019.

    
  1. Sakthi 2018

    Sakthi 2018 New Member


    Dear Experts,
    I set fees allocation field in student master as sub form collection , and I try to fetch allotment fees value in fees due report allotment column .
    In this Report, Values not fetching in allotment column. Please correct my code.
    I attached my code and unable to post screenshots.


    ;;Code starts from here

    ;;Fees Allocation Report

    ;;;;;;;;;;;;;;;;;;;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


    [#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
    Set as : $$CollectionFieldByKey:$Studentopeningamt:AutoCollkey:Courselist

    AutoCollkey : ##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





    ;;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
    Search Key : $PName + $Name


    [System:UDF]


    Feeshead : Logical : 36002
    StuFeesHead : String : 9599
    Studentopeningamt : Amount : 9594
    Courselist : Aggregate : 902


    ;;;;;;;;;;;;VARIBLES;;;;;;;;;;;;


    [Variable: PName]
    Type : String
    Repeat : ##DSPRepeatCollection

    [Variable: Year Filter]
    Type : String

    [Variable: FeesFilter]
    Type : String

    [System: Variables]
    YearFilter : ""

    [System: Variables]
    Fees Filter : ""




    ;;END OF FILE
     


  2. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Not getting your point ?

    Which part of the code you have problem in ?

    paste that particular part of code and also the part from which you want to get the value
     


  3. Sakthi 2018

    Sakthi 2018 New Member


    i want fetch value in this field.........



    [Field: FeesDuesReportAllotedAmt]

    Use : Amount Field
    Set as : $$CollectionFieldByKey:$Studentopeningamt:AutoCollkey:Courselist

    AutoCollkey : ##PName + #FeesDuesReportName
    Style : Normal

    [Collection: Courselist]

    Title : "List of Course Fees Heads"
    Type : Ledger ;: Company
    ;Child Of : ##SVCurrentCompany
    Format : $Name,25
    Filter : Courselist
    Search Key : $PName + $Name
     


  4. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Search Key : $PName + $Name

    $Name is Ledger and what is $PName? where have you defined it ?

    also try adding

    Format : $PName, 25 before Format : $Name, 25

    also this line:

    Set as : $$CollectionFieldByKey:$Studentopeningamt:AutoCollkey:Courselist
    should be Set as : $$CollectionFieldByKey:$Studentopeningamt: @ AutoCollkey:Courselist
     


  5. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    I don't understand why people don't reply... and at least we have curiosity to know the outcome.
     


  6. Sakthi 2018

    Sakthi 2018 New Member




    Sir, this is not working
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You making a collection of CourseList and within that collection once again you are filtering it..... try removing the filter.
     


  8. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Ok .. I went through your code, and tested it.

    It needs some modification.. I will update you tmrw
     


  9. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Amit Kamdar Sir,

    Guide him to use [#Object : Ledger]

    so that his required methods will be available for ledger object
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Object : Ledger]
    Feeshead : $Feeshead
    StuFeesHead : $StuFeesHead
    Studentopeningamt : $Studentopeningamt
     


  11. Sakthi 2018

    Sakthi 2018 New Member


    Dear sir,
    i filtering a collection for particular fees heads....
     


  12. Sakthi 2018

    Sakthi 2018 New Member


    Ok....Sir.....
     


  13. Sakthi 2018

    Sakthi 2018 New Member


    Sir,
    Already i tried that, but don't come....
     


  14. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Please check your posted code, it has some duplicate part.. please remove it(post a fresh message with corrected code)
     


  15. Sakthi 2018

    Sakthi 2018 New Member



    Dear Experts,
    I set fees allocation field in student master as sub form collection , and I try to fetch allotment fees value in fees due report allotment column .
    In this Report, Values not fetching in allotment column. Please correct my code.
    I attached my code and unable to post screenshots.


    ;;Code starts from here

    ;;Fees Allocation Report

    ;;;;;;;;;;;;;;;;;;;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


    [#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
    Set as : $$CollectionFieldByKey:$Studentopeningamt:AutoCollkey:Courselist

    AutoCollkey : ##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: Courselist]

    Title : "List of Course Fees Heads"
    Type : Ledger ;: Company
    ;Child Of : ##SVCurrentCompany
    Format : $Name,25
    Filter : Courselist
    Search Key : $PName + $Name


    [System:UDF]


    Feeshead : Logical : 36002
    StuFeesHead : String : 9599
    Studentopeningamt : Amount : 9594
    Courselist : Aggregate : 902


    ;;;;;;;;;;;;VARIBLES;;;;;;;;;;;;


    [Variable: PName]
    Type : String
    Repeat : ##DSPRepeatCollection

    [Variable: Year Filter]
    Type : String

    [Variable: FeesFilter]
    Type : String

    [System: Variables]
    YearFilter : ""

    [System: Variables]
    Fees Filter : ""



    ;;END OF FILE
     


Share This Page