1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Area Wise Outstanding Report

Discussion in 'Free Source Codes' started by Salman, Feb 2, 2017.

    
  1. Salman

    Salman Member


    Dear all experts,
    i want the area wise outstanding report this is my code please correct and revert me the same



    [#Menu:Gateway of Tally]
    Add :Item :Before : @@locQuit : Area Wise Outstanding Statement : Display Collection: MRIGGRP Vouchers

    [Collection: MRIGGRP Vouchers]
    Use : Group
    Variable : Group Name
    Report : FS SKC Outstanding Statement
    Filter : MRIGSundryDebtors
    Trigger : MRIGGL Vouchers


    [System : Formula]
    MRIGSundryDebtors : $$IsBelongsTo:$$GroupSundryDebtors AND Not $$IsEmpty:$ClosingBalance

    [Report: MRIGGL Vouchers] ;;Auto Report

    Use : Group Name
    Local : Field : Group Name : Delete: Table
    Local : Field : Group Name : Add : Table : MRIGGRP Vouchers
    Local : Collection: Ledger : Filter : BelongsToGroupName



    [Report:FS SKC Outstanding Statement]
    Use : DSP Template
    Form : FS SKC OutStanding
    ; Set : SVFromDate : $$CurrentDate
    Set : SVToDate : $$YearEnd:$$CurrentDate

    [Form:FS SKC OutStanding]
    Use : DSP Template
    Delete : Button : F2ChangePeriod
    Add : Button : Change Date
    Add : Button : Change Period
    Part : FS SKC OutState Head Title, FS SKC OS Column Title
    Height : 100% Page
    Width : 100% Page
    Delete : BottomButtons
    ;Add : Button : BlankButton, GR Alter, VouchAlter

    [Part:FS SKC OutState Head Title]
    Background : Lily White
    Line : FS SKC OutState Head Title
    [Line : FS SKC OutState Head Title]
    Field : FS SKC OutState Head Title
    [Field : FS SKC OutState Head Title]
    Info : "OutStanding Statement for the Month of"
    Use : Name Field
    Align : Center.
    Full Width:Yes



    [Part : FS SKC OS Column Title]
    Repeat:FS SKC OS Column Val :SKC OS CollectionMain
    Line:FS SKC OS Column Title, FS SKC OS Column Val
    Bottom Line: FS SKC OS ColumnTotal
    Common Border:Yes
    Scroll:Vertical
    Total:FS SKOS TotalOut,FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6
    [Line:FS SKC OS Column Title]
    Border:thin top bottom
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6;, FS SKOS Remarks


    Local : Field : FS SKOS SRNo : Info : "S. No."
    Local : Field : FS SKOS Bill No : Info : "Bill No."
    Local : Field : FS SKOS Date : Info : "Date"
    Local : Field : FS SKOS PartyName : Info : "Name Of the Party"
    Local : Field : FS SKOS Station : Info : "Station"
    Local : Field : FS SKOS L.FNo : Info : "L.F No."
    Local : Field : FS SKOS TotalOut : info : "Total" +$$NewLine+" Out-Standing"
    Local : Field : FS SKOS Amt1 : Info : "Amount" +$$NewLine+" 30 Days"
    Local : Field : FS SKOS Amt2 : Info : "Amount" +$$NewLine+" 31-60 Days"
    Local : Field : FS SKOS Amt3 : info : "Amount" +$$NewLine+" 61-90 Days"
    Local : Field : FS SKOS Amt4 : Info : "Amount" +$$NewLine+" 91-120 Days"
    Local : Field : FS Amt5 : Info : "Amount" +$$NewLine+" 121-150 Days"
    Local : Field : FS SKOS Amt6 : Info : "Amount" +$$NewLine+" Above 150 Days"
    Local : Field : Default : Style : Tiny Bold
    Local : Field : Default : Align : Center
    Local : Field : Default : Line : 2

    [Line:FS SKC OS Column Val]
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6;, FS SKOS Remarks



    [Field:FS SKOS SRNo]
    Set as : $$Line
    Border : Thin Right
    Use : Name Field
    Width : 1 cms
    Style : Tiny



    [Field:FS SKOS Bill No]
    Set as : $NAME
    Use : Name Field
    Border : Thin Right
    Width : 1.5 cms
    Style : Tiny

    [Field:FS SKOS Date]
    Set as : $BILLDATE
    Use : Uni Date Field
    Border : Thin Right
    Width : 2.1 cms
    Style : Tiny

    [Field:FS SKOS PartyName]
    Set as : $PartyName
    Border : Thin Right
    Use : Name Field
    Style : Tiny
    Width : 5 cms


    [Field:FS SKOS Station]
    setas : "";$LedStateName:Ledger:$PartyName
    Border : Thin Right
    Use : Name Field
    Width : 1.6 cms
    Style : Tiny

    [Field:FS SKOS L.FNo]
    Border : Thin Right
    Use : Name Field
    Width : 1.4 cms
    Style : Tiny

    [Field:FS SKOS TotalOut]
    Set as : $FINALBALANCE
    Format : DrCr
    Use : AMOUNT FIELD
    Border : Thin Right
    Width : 3 cms
    Style : Tiny


    [Field:FS SKOS Amt1]
    Border : Thin Right
    Use : Amount Field
    Style : Tiny
    Format : DrCr
    Set as : If $$Number:(##SVCurrentDate - $BillDate) <= 30 Then $FinalBalance Else ""



    [Field:FS SKOS Amt2]
    Border : Thin Right
    Use : Amount Field
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 30 AND $$Number:(##SVCurrentDate - $BillDate) <= 60) Then $FinalBalance Else ""



    [Field:FS SKOS Amt3]
    Border : Thin Right
    Use : Name Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 60 AND $$Number:(##SVCurrentDate - $BillDate) <= 90) Then $FinalBalance Else ""



    [Field:FS SKOS Amt4]
    Border : Thin Right
    Use : Name Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 90 AND $$Number:(##SVCurrentDate - $BillDate) <= 120) Then $FinalBalance Else ""




    [Field:FS Amt5]
    Border : Thin Right
    Use : Name Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 120 AND $$Number:(##SVCurrentDate - $BillDate) <= 150) Then $FinalBalance Else ""




    [Field:FS SKOS Amt6]
    Border : Thin Right
    Use : Name Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 150 AND $$Number:(##SVCurrentDate - $BillDate) <= 180) Then $FinalBalance Else ""




    [Field:FS SKOS Remarks]
    Border : Thin Right
    Use : Name Field
    Width : 5 cms
    Style : Tiny




    [Line:FS SKC OS ColumnTotal]
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6

    Local : Field :FS SKOS SRNo : Info:""
    Local : Field :FS SKOS Bill No :Info:""
    Local : Field :FS SKOS Date :Info:""
    Local : Field :FS SKOS PartyName :Info:"Total"
    Local : Field :FS SKOS Station :Info:""
    Local : Field :FS SKOS L.FNo :Info:""
    Local : Field :FS SKOS TotalOut :Set as:$$Total:FSSKOSTotalOut
    Local : Field :FS SKOS Amt1 :Set as:$$Total:FSSKOSAmt1
    Local : Field :FS SKOS Amt2 :Set as:$$Total:FSSKOSAmt2
    Local : Field :FS SKOS Amt3 :Set as:$$Total:FSSKOSAmt3
    Local : Field :FS SKOS Amt4 :Set as:$$Total:FSSKOSAmt4
    Local : Field :FS Amt5 :Set as:$$Total:FSAmt5
    Local : Field :FS SKOS Amt6 :Set as:$$Total:FSSKOSAmt6
    Border: Thin top bottom



    [Collection :SKC OS CollectionMain]
    Type :BILL
    Fetch : Line.*,BILL.*, LEDGERENTRIES.*,INVERTORYENTIES.*,STOCKITEM.*,LedStateName ;VATDistrictName.*,
    Filter : ALLSALES ;,ALLSALES1

    Sort : @@DEFAULT :$LEDGERENTRIES.LEDGERNAME

    Compute : PartyName : $$FuncDSPAccName:$Parent
    ;
    ; ColumnVar: AgeFrom, AgeTo

    [SYSTEM : FORMULAE]

    ALLSALES : $$IsDr:$FINALBALANCE
    ALLSALES1 : $$IfCr:$FINALBALANCE
     
    Salman, Feb 2, 2017
    #1


  2. Ankur Tiwari

    Ankur Tiwari Member


    Use this Rectified Code

    [#Menu:Gateway of Tally]
    Add :Item :Before : @@locQuit : Area Wise Outstanding Statement : Display : FS SKC Outstanding Statement

    [Collection: MRIGGRP Vouchers]
    Use : Group
    Variable : Group Name
    Report : FS SKC Outstanding Statement
    Filter : MRIGSundryDebtors
    Trigger : MRIGGL Vouchers


    [System : Formula]
    MRIGSundryDebtors : $$IsBelongsTo:$$GroupSundryDebtors AND Not $$IsEmpty:$ClosingBalance

    [Report: MRIGGL Vouchers] ;;Auto Report

    Use : Group Name
    Local : Field : Group Name : Delete: Table
    Local : Field : Group Name : Add : Table : MRIGGRP Vouchers
    Local : Collection: Ledger : Filter : BelongsToGroupName



    [Report:FS SKC Outstanding Statement]
    Use : DSP Template
    Form : FS SKC OutStanding
    ; Set : SVFromDate : $$CurrentDate
    Set : SVToDate : $$YearEnd:$$CurrentDate

    [Form:FS SKC OutStanding]
    Use : DSP Template
    Delete : Button : F2ChangePeriod
    Add : Button : Change Date
    Add : Button : Change Period
    Part : FS SKC OutState Head Title, FS SKC OS Column Title
    Height : 100% Page
    Width : 100% Page
    Delete : BottomButtons
    ;Add : Button : BlankButton, GR Alter, VouchAlter

    [Part:FS SKC OutState Head Title]
    Background : Lily White
    Line : FS SKC OutState Head Title
    [Line : FS SKC OutState Head Title]
    Field : FS SKC OutState Head Title
    [Field : FS SKC OutState Head Title]
    Info : "OutStanding Statement for the Month of"
    Use : Name Field
    Align : Center.
    Full Width:Yes



    [Part : FS SKC OS Column Title]
    Repeat:FS SKC OS Column Val :SKC OS CollectionMain
    Line:FS SKC OS Column Title, FS SKC OS Column Val
    Bottom Line: FS SKC OS ColumnTotal
    Common Border:Yes
    Scroll:Vertical
    Total:FS SKOS TotalOut,FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6
    [Line:FS SKC OS Column Title]
    Border:thin top bottom
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6;, FS SKOS Remarks


    Local : Field : FS SKOS SRNo : Info : "S. No."
    Local : Field : FS SKOS Bill No : Info : "Bill No."
    Local : Field : FS SKOS Date : Info : "Date"
    Local : Field : FS SKOS PartyName : Info : "Name Of the Party"
    Local : Field : FS SKOS Station : Info : "Station"
    Local : Field : FS SKOS L.FNo : Info : "L.F No."
    Local : Field : FS SKOS TotalOut : info : "Total" +$$NewLine+" Out-Standing"
    Local : Field : FS SKOS Amt1 : Info : "Amount" +$$NewLine+" 30 Days"
    Local : Field : FS SKOS Amt2 : Info : "Amount" +$$NewLine+" 31-60 Days"
    Local : Field : FS SKOS Amt3 : info : "Amount" +$$NewLine+" 61-90 Days"
    Local : Field : FS SKOS Amt4 : Info : "Amount" +$$NewLine+" 91-120 Days"
    Local : Field : FS Amt5 : Info : "Amount" +$$NewLine+" 121-150 Days"
    Local : Field : FS SKOS Amt6 : Info : "Amount" +$$NewLine+" Above 150 Days"
    Local : Field : Default : Style : Tiny Bold
    Local : Field : Default : Align : Center
    Local : Field : Default : Line : 2

    [Line:FS SKC OS Column Val]
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6;, FS SKOS Remarks



    [Field:FS SKOS SRNo]
    Set as : $$Line
    Border : Thin Right
    Use : Name Field
    Width : 1 cms
    Style : Tiny



    [Field:FS SKOS Bill No]
    Set as : $NAME
    Use : Name Field
    Border : Thin Right
    Width : 1.5 cms
    Style : Tiny

    [Field:FS SKOS Date]
    Set as : $BILLDATE
    Use : Uni Date Field
    Border : Thin Right
    Width : 2.1 cms
    Style : Tiny

    [Field:FS SKOS PartyName]
    Set as : $PartyName
    Border : Thin Right
    Use : Name Field
    Style : Tiny
    Width : 5 cms


    [Field:FS SKOS Station]
    setas : "";$LedStateName:Ledger:$PartyName
    Border : Thin Right
    Use : Name Field
    Width : 1.6 cms
    Style : Tiny

    [Field:FS SKOS L.FNo]
    Border : Thin Right
    Use : Name Field
    Width : 1.4 cms
    Style : Tiny

    [Field:FS SKOS TotalOut]
    Set as : $FINALBALANCE
    Format : DrCr
    Use : AMOUNT FIELD
    Border : Thin Right
    Width : 3 cms
    Style : Tiny


    [Field:FS SKOS Amt1]
    Border : Thin Right
    Use : Amount Field
    Style : Tiny
    Format : DrCr
    Set as : If $$Number:(##SVCurrentDate - $BillDate) <= 30 Then $FinalBalance Else ""



    [Field:FS SKOS Amt2]
    Border : Thin Right
    Use : Amount Field
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 30 AND $$Number:(##SVCurrentDate - $BillDate) <= 60) Then $FinalBalance Else ""



    [Field:FS SKOS Amt3]
    Border : Thin Right
    Use : Name Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 60 AND $$Number:(##SVCurrentDate - $BillDate) <= 90) Then $FinalBalance Else ""



    [Field:FS SKOS Amt4]
    Border : Thin Right
    Use : Name Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 90 AND $$Number:(##SVCurrentDate - $BillDate) <= 120) Then $FinalBalance Else ""




    [Field:FS Amt5]
    Border : Thin Right
    Use : Name Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 120 AND $$Number:(##SVCurrentDate - $BillDate) <= 150) Then $FinalBalance Else ""




    [Field:FS SKOS Amt6]
    Border : Thin Right
    Use : Name Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 150 AND $$Number:(##SVCurrentDate - $BillDate) <= 180) Then $FinalBalance Else ""




    [Field:FS SKOS Remarks]
    Border : Thin Right
    Use : Name Field
    Width : 5 cms
    Style : Tiny




    [Line:FS SKC OS ColumnTotal]
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6

    Local : Field :FS SKOS SRNo : Info:""
    Local : Field :FS SKOS Bill No :Info:""
    Local : Field :FS SKOS Date :Info:""
    Local : Field :FS SKOS PartyName :Info:"Total"
    Local : Field :FS SKOS Station :Info:""
    Local : Field :FS SKOS L.FNo :Info:""
    Local : Field :FS SKOS TotalOut :Set as:$$Total:FSSKOSTotalOut
    Local : Field :FS SKOS Amt1 :Set as:$$Total:FSSKOSAmt1
    Local : Field :FS SKOS Amt2 :Set as:$$Total:FSSKOSAmt2
    Local : Field :FS SKOS Amt3 :Set as:$$Total:FSSKOSAmt3
    Local : Field :FS SKOS Amt4 :Set as:$$Total:FSSKOSAmt4
    Local : Field :FS Amt5 :Set as:$$Total:FSAmt5
    Local : Field :FS SKOS Amt6 :Set as:$$Total:FSSKOSAmt6
    Border: Thin top bottom



    [Collection :SKC OS CollectionMain]
    Type :BILL
    Fetch : Line.*,BILL.*, LEDGERENTRIES.*,INVERTORYENTIES.*,STOCKITEM.*,LedStateName ;VATDistrictName.*,
    Filter : ALLSALES ;,ALLSALES1

    Sort : @@DEFAULT :$LEDGERENTRIES.LEDGERNAME

    Compute : PartyName : $$FuncDSPAccName:$Parent
    ;
    ; ColumnVar: AgeFrom, AgeTo

    [SYSTEM : FORMULAE]

    ALLSALES : $$IsDr:$FINALBALANCE
    ALLSALES1 : $$IfCr:$FINALBALANCE
     
    Ankur Tiwari, Feb 2, 2017
    #2
    mpal2311 likes this.


  3. Ajeet Jain

    Ajeet Jain Member


    Which area wise you want this report?
    and where are the area in your report?
     
    Ajeet Jain, Feb 2, 2017
    #3


  4. cbemani

    cbemani New Member


    Dear Colleagues,

    I created New Value in the Ledger master Screen, and i need that particular value in the Outstanding and Age-wise Report

    What is the Code to get that value.

    [Field: Sales officer]
    Set as : $LedgerSalesofficer:Ledger:$parent
     

    Attached Files:

    cbemani, Mar 7, 2017
    #4


  5. kishoreji

    kishoreji New Member


     
    kishoreji, Mar 9, 2017
    #5


  6. kishoreji

    kishoreji New Member


    Please note
    Total Value of the following is not getting

    61-90 Days Amount
    91-120 Days Amount
    121-150 Days Amount
    Above 150 Days
     
    kishoreji, Mar 9, 2017
    #6


  7. kishoreji

    kishoreji New Member


     
    kishoreji, Mar 25, 2017
    #7


  8. dipu369

    dipu369 Member


    Dear ,
    This report is OK But purchase bills are also coming . We want only for Sundry Debtors not creditors
    Regards

     
    dipu369, May 9, 2017
    #8


  9. kishoreji

    kishoreji New Member


    upload_2017-5-9_12-41-23.png

    Dear Sir
    Please see the screen shot.Sum total of first two only coming.It will be immense help if the total is also coming.

    Thanks
    Kishore
     
    kishoreji, May 9, 2017
    #9


  10. dipu369

    dipu369 Member


    Just Check and change Field name to see FS SKOS Amt1

    I am pasting correct code but It is combined payable also . We want only debtors receivable . Anyone help me ?
    ************************************************************************************************************

    ;*********************
    ; Start Agewise
    ;************************

    [Collection: MRIGGRP Vouchers]
    Use : Group
    Variable : Group Name
    Report : FS SKC Outstanding Statement
    Filter : MRIGSundryDebtors
    Trigger : MRIGGL Vouchers


    [System : Formula]
    MRIGSundryDebtors : $$IsBelongsTo:$$GroupSundryDebtors AND Not $$IsEmpty:$ClosingBalance

    [Report: MRIGGL Vouchers] ;;Auto Report

    Use : Group Name
    Local : Field : Group Name : Delete: Table
    Local : Field : Group Name : Add : Table : MRIGGRP Vouchers
    Local : Collection: Ledger : Filter : BelongsToGroupName,AGFilter



    [Report:FS SKC Outstanding Statement]
    Use : DSP Template
    Form : FS SKC OutStanding
    ; Set : SVFromDate : $$CurrentDate
    Set : SVToDate : $$YearEnd:$$CurrentDate

    [Form:FS SKC OutStanding]
    Use : DSP Template
    Delete : Button : F2ChangePeriod
    Add : Button : Change Date
    Add : Button : Change Period
    Part : FS SKC OutState Head Title, FS SKC OS Column Title
    Height : 100% Page
    Width : 100% Page
    Delete : BottomButtons
    ;Add : Button : BlankButton, GR Alter, VouchAlter
    Add: Button: Saibaba

    [Part:FS SKC OutState Head Title]
    Background : Lily White
    Line : FS SKC OutState Head Title
    [Line : FS SKC OutState Head Title]
    Field : FS SKC OutState Head Title
    [Field : FS SKC OutState Head Title]
    Info : "OutStanding Statement for the Month of"
    Use : Name Field
    Align : Center.
    Full Width:Yes



    [Part : FS SKC OS Column Title]
    Repeat:FS SKC OS Column Val :SKC OS CollectionMain
    Line:FS SKC OS Column Title, FS SKC OS Column Val
    Bottom Line: FS SKC OS ColumnTotal
    Common Border:Yes
    Scroll:Vertical

    Total:FS SKOS TotalOut,FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS SKOS Amt5, FS SKOS Amt6

    [Line:FS SKC OS Column Title]
    Border:thin top bottom

    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS SONAME, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS SKOS Amt5, FS SKOS Amt6;, FS SKOS Remarks


    Local : Field : FS SKOS SRNo : Info : "S. No."
    Local : Field : FS SKOS Bill No : Info : "Bill No."
    Local : Field : FS SKOS Date : Info : "Date"
    Local : Field : FS SKOS PartyName : Info : "Name Of the Party"
    Local : Field : FS SKOS Station : Info : "Station"
    ;Local : Field : FS SKOS L.FNo : Info : "L.F No."

    Local : Field : FS SKOS SONAME : Set as: $$LocaleString:"DSO Name"

    Local : Field : FS SKOS TotalOut : info : "Total" +$$NewLine+" Out-Standing"
    Local : Field : FS SKOS Amt1 : Info : "Amount" +$$NewLine+" 30 Days"
    Local : Field : FS SKOS Amt2 : Info : "Amount" +$$NewLine+" 31-60 Days"
    Local : Field : FS SKOS Amt3 : info : "Amount" +$$NewLine+" 61-90 Days"
    Local : Field : FS SKOS Amt4 : Info : "Amount" +$$NewLine+" 91-120 Days"
    Local : Field : FS SKOS Amt5 : Info : "Amount" +$$NewLine+" 121-150 Days"
    Local : Field : FS SKOS Amt6 : Info : "Amount" +$$NewLine+" Above 150 Days"
    Local : Field : Default : Style : Tiny Bold
    Local : Field : Default : Align : Center
    Local : Field : Default : Line : 2





    [Line:FS SKC OS Column Val]
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS SONAME, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS SKOS Amt5, FS SKOS Amt6;, FS SKOS Remarks



    [Field:FS SKOS SRNo]
    Set as : $$Line
    Border : Thin Right
    Use : Name Field
    Width : 1 cms
    Style : Tiny


    [Field:FS SKOS Bill No]
    Set as : $NAME
    Use : Name Field
    Border : Thin Right
    Width : 1.5 cms
    Style : Tiny


    [Field:FS SKOS Date]
    Set as : $BILLDATE
    Use : Uni Date Field
    Border : Thin Right
    Width : 2.1 cms
    Style : Tiny


    [Field:FS SKOS PartyName]
    Set as : $PartyName
    Border : Thin Right
    Use : Name Field
    Style : Tiny
    Width : 5 cms


    [Field:FS SKOS Station]
    setas : "";$LedStateName:Ledger:$PartyName
    Border : Thin Right
    Use : Name Field
    Width : 1.6 cms
    Style : Tiny


    ;[Field:FS SKOS L.FNo]
    ;Border : Thin Right
    ;Use : Name Field
    ;Width : 1.4 cms
    ;Style : Tiny


    [Field:FS SKOS SONAME]
    Border : Thin Right
    Use : Name Field
    Set as : $$FilterValue:$VCHKAPLdsoName:LedgerEntries:First:polysaiSales
    Width : 3 cms
    Style : Tiny
    Key : Create KAPLdsoName


    [Field:FS SKOS TotalOut]
    Set as : $FINALBALANCE
    Format : DrCr
    Use : AMOUNT FIELD
    Border : Thin Right
    Width : 3 cms
    Style : Tiny


    [Field:FS SKOS Amt1]
    Border : Thin Right
    Use : Amount Field
    Style : Tiny
    Format : DrCr
    Set as : If $$Number:(##SVCurrentDate - $BillDate) <= 30 Then $FinalBalance Else ""



    [Field:FS SKOS Amt2]
    Border : Thin Right
    Use : Amount Field
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 30 AND $$Number:(##SVCurrentDate - $BillDate) <= 60) Then $FinalBalance Else ""



    [Field:FS SKOS Amt3]
    Border : Thin Right
    Use : Amount Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 60 AND $$Number:(##SVCurrentDate - $BillDate) <= 90) Then $FinalBalance Else ""



    [Field:FS SKOS Amt4]
    Border : Thin Right
    Use : Amount Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 90 AND $$Number:(##SVCurrentDate - $BillDate) <= 120) Then $FinalBalance Else ""




    [Field:FS SKOS Amt5]
    Border : Thin Right
    Use : Amount Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 120 AND $$Number:(##SVCurrentDate - $BillDate) <= 150) Then $FinalBalance Else ""




    [Field:FS SKOS Amt6]
    Border : Thin Right
    Use : Amount Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 150 AND $$Number:(##SVCurrentDate - $BillDate) <= 180) Then $FinalBalance Else ""




    [Field:FS SKOS Remarks]
    Border : Thin Right
    Use : Name Field
    Width : 5 cms
    Style : Tiny




    [Line:FS SKC OS ColumnTotal]
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS SONAME, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS SKOS Amt5, FS SKOS Amt6

    Local : Field :FS SKOS SRNo : Info:""
    Local : Field :FS SKOS Bill No :Info:""
    Local : Field :FS SKOS Date :Info:""
    Local : Field :FS SKOS PartyName :Info:"Total"
    Local : Field :FS SKOS Station :Info:""
    ;Local : Field :FS SKOS L.FNo :Info:""

    Local : Field :FS SKOS SONAME :Set as: ""

    Local : Field :FS SKOS TotalOut :Set as:$$Total:FSSKOSTotalOut
    Local : Field :FS SKOS Amt1 :Set as:$$Total:FSSKOSAmt1 ;; =30
    Local : Field :FS SKOS Amt2 :Set as:$$Total:FSSKOSAmt2 ;; 30-60
    Local : Field :FS SKOS Amt3 :Set as:$$Total:FSSKOSAmt3 ;; 60-90
    Local : Field :FS SKOS Amt4 :Set as:$$Total:FSSKOSAmt4 ;; 90-120
    Local : Field :FS SKOS Amt5 :Set as:$$Total:FSSKOSAmt5 ;; 120-150
    Local : Field :FS SKOS Amt6 :Set as:$$Total:FSSKOSAmt6 ;; 150-180
    Border: Thin top bottom


    [Collection :SKC OS CollectionMain]
    Type :BILL
    Fetch : Line.*,BILL.*, LEDGERENTRIES.*,INVERTORYENTIES.*,STOCKITEM.*,LedStateName ;VATDistrictName.*,
    Fetch : VCHKAPLdsoName
    Filter : ALLSALES ;,ALLSALES1
    Filter : NOTIsOptionalVoucher,AGFilter



    Sort : @@DEFAULT :$LEDGERENTRIES.LEDGERNAME

    Compute : PartyName : $$FuncDSPAccName:$Parent


    [SYSTEM : FORMULAE]

    ALLSALES : $$IsDr:$FINALBALANCE
    ;ALLSALES1 : $$IfCr:$FINALBALANCE

    [System: Formula]

    PolysaiSales : $$IsSales:$VoucherTypeName ;;or $$IsPurchase:$VoucherTypeName
     
    dipu369, May 12, 2017
    #10


  11. Amitkumar

    Amitkumar Member


    How to get no due amount in same report? Amount Bills which is not due as on date
     
    Amitkumar, May 24, 2017
    #11


  12. kishoreji

    kishoreji New Member


    Dear Experts
    I have solved total not coming issue in area wise outstanding report. Now I had added a district field using the following code,but not picking the district inputted into the ledger master into the areawise outstanding report.Please help me.

    [#Menu:Gateway of Tally]
    Add :Item :Before : @@locQuit : Area Wise Outstanding Statement : Display : FS SKC Outstanding Statement

    [Collection: MRIGGRP Vouchers]
    Use : Group
    Variable : Group Name
    Report : FS SKC Outstanding Statement
    Filter : MRIGSundryDebtors
    Trigger : MRIGGL Vouchers


    [System : Formula]
    MRIGSundryDebtors : $$IsBelongsTo:$$GroupSundryDebtors AND Not $$IsEmpty:$ClosingBalance

    [Report: MRIGGL Vouchers] ;;Auto Report

    Use : Group Name
    Local : Field : Group Name : Delete: Table
    Local : Field : Group Name : Add : Table : MRIGGRP Vouchers
    Local : Collection: Ledger : Filter : BelongsToGroupName



    [Report:FS SKC Outstanding Statement]
    Use : DSP Template
    Form : FS SKC OutStanding
    ; Set : SVFromDate : $$CurrentDate
    Set : SVToDate : $$YearEnd:$$CurrentDate

    [Form:FS SKC OutStanding]
    Use : DSP Template
    Delete : Button : F2ChangePeriod
    Add : Button : Change Date
    Add : Button : Change Period
    Add : Button : Change Group
    Part : FS SKC OutState Head Title, FS SKC OS Column Title
    Height : 100% Page
    Width : 100% Page
    Delete : BottomButtons
    ;Add : Button : BlankButton, GR Alter, VouchAlter

    [Part:FS SKC OutState Head Title]
    Background : Lily White
    Line : FS SKC OutState Head Title
    [Line : FS SKC OutState Head Title]
    Field : FS SKC OutState Head Title
    [Field : FS SKC OutState Head Title]
    Info : "OutStanding Statement for the Month of"
    Use : Name Field
    Align : Center.
    Full Width:Yes



    [Part : FS SKC OS Column Title]
    Repeat:FS SKC OS Column Val :SKC OS CollectionMain
    Line:FS SKC OS Column Title, FS SKC OS Column Val
    Bottom Line: FS SKC OS ColumnTotal
    Common Border:Yes
    Scroll:Vertical
    Total:FS SKOS TotalOut,FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6
    [Line:FS SKC OS Column Title]
    Border:thin top bottom
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6;, FS SKOS Remarks


    Local : Field : FS SKOS SRNo : Info : "S. No."
    Local : Field : FS SKOS Bill No : Info : "Bill No."
    Local : Field : FS SKOS Date : Info : "Date"
    Local : Field : FS SKOS PartyName : Info : "Name Of the Party"
    Local : Field : FS SKOS Station : Info : "Station"
    Local : Field : FS SKOS L.FNo : Info : "L.F No."
    Local : Field : FS SKOS TotalOut : info : "Total" +$$NewLine+" Out-Standing"
    Local : Field : FS SKOS Amt1 : Info : "Amount" +$$NewLine+" 30 Days"
    Local : Field : FS SKOS Amt2 : Info : "Amount" +$$NewLine+" 31-60 Days"
    Local : Field : FS SKOS Amt3 : info : "Amount" +$$NewLine+" 61-90 Days"
    Local : Field : FS SKOS Amt4 : Info : "Amount" +$$NewLine+" 91-120 Days"
    Local : Field : FS Amt5 : Info : "Amount" +$$NewLine+" 121-150 Days"
    Local : Field : FS SKOS Amt6 : Info : "Amount" +$$NewLine+" Above 150 Days"
    Local : Field : Default : Style : Tiny Bold
    Local : Field : Default : Align : Center
    Local : Field : Default : Line : 2

    [Line:FS SKC OS Column Val]
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6;, FS SKOS Remarks



    [Field:FS SKOS SRNo]
    Set as : $$Line
    Border : Thin Right
    Use : Name Field
    Width : 1 cms
    Style : Tiny



    [Field:FS SKOS Bill No]
    Set as : $NAME
    Use : Name Field
    Border : Thin Right
    Width : 1.5 cms
    Style : Tiny

    [Field:FS SKOS Date]
    Set as : $BILLDATE
    Use : Uni Date Field
    Border : Thin Right
    Width : 2.1 cms
    Style : Tiny

    [Field:FS SKOS PartyName]
    Set as : $PartyName
    Border : Thin Right
    Use : Name Field
    Style : Tiny
    Width : 5 cms


    [Field:FS SKOS Station]
    setas : "";$LedStateName:Ledger:$PartyName
    Border : Thin Right
    Use : Name Field
    Width : 1.6 cms
    Style : Tiny

    [Field:FS SKOS L.FNo]
    Border : Thin Right
    Use : Name Field
    Width : 1.4 cms
    Style : Tiny

    [Field:FS SKOS TotalOut]
    Set as : $FINALBALANCE
    Format : DrCr
    Use : AMOUNT FIELD
    Border : Thin Right
    Width : 3 cms
    Style : Tiny


    [Field:FS SKOS Amt1]
    Border : Thin Right
    Use : Amount Field
    Style : Tiny
    Format : DrCr
    Set as : If $$Number:(##SVCurrentDate - $BillDate) <= 30 Then $FinalBalance Else ""



    [Field:FS SKOS Amt2]
    Border : Thin Right
    Use : Amount Field
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 30 AND $$Number:(##SVCurrentDate - $BillDate) <= 60) Then $FinalBalance Else ""



    [Field:FS SKOS Amt3]
    Border : Thin Right
    Use : Amount Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 60 AND $$Number:(##SVCurrentDate - $BillDate) <= 90) Then $FinalBalance Else ""



    [Field:FS SKOS Amt4]
    Border : Thin Right
    Use : Amount Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 90 AND $$Number:(##SVCurrentDate - $BillDate) <= 120) Then $FinalBalance Else ""




    [Field:FS Amt5]
    Border : Thin Right
    Use : Amount Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 120 AND $$Number:(##SVCurrentDate - $BillDate) <= 150) Then $FinalBalance Else ""




    [Field:FS SKOS Amt6]
    Border : Thin Right
    Use : Amount Field
    Width : 3 cms
    Style : Tiny
    Format : DrCr
    Set as : If ($$Number:(##SVCurrentDate - $BillDate) > 150 AND $$Number:(##SVCurrentDate - $BillDate) <= 180) Then $FinalBalance Else ""




    [Field:FS SKOS Remarks]
    Border : Thin Right
    Use : Name Field
    Width : 5 cms
    Style : Tiny




    [Line:FS SKC OS ColumnTotal]
    Field : FS SKOS SRNo, FS SKOS Bill No, FS SKOS Date, FS SKOS PartyName,
    Field : FS SKOS Station, FS SKOS L.FNo, FS SKOS TotalOut, +
    FS SKOS Amt1, FS SKOS Amt2, FS SKOS Amt3, FS SKOS Amt4, FS Amt5, FS SKOS Amt6

    Local : Field :FS SKOS SRNo : Info:""
    Local : Field :FS SKOS Bill No :Info:""
    Local : Field :FS SKOS Date :Info:""
    Local : Field :FS SKOS PartyName :Info:"Total"
    Local : Field :FS SKOS Station :Info:""
    Local : Field :FS SKOS L.FNo :Info:""
    Local : Field :FS SKOS TotalOut :Set as:$$Total:FSSKOSTotalOut
    Local : Field :FS SKOS Amt1 :Set as:$$Total:FSSKOSAmt1
    Local : Field :FS SKOS Amt2 :Set as:$$Total:FSSKOSAmt2
    Local : Field :FS SKOS Amt3 :Set as:$$Total:FSSKOSAmt3
    Local : Field :FS SKOS Amt4 :Set as:$$Total:FSSKOSAmt4
    Local : Field :FS Amt5 :Set as:$$Total:FSAmt5
    Local : Field :FS SKOS Amt6 :Set as:$$Total:FSSKOSAmt6
    Border: Thin top bottom



    [Collection :SKC OS CollectionMain]
    Type :BILL
    Fetch : Line.*,BILL.*, LEDGERENTRIES.*,INVERTORYENTIES.*,STOCKITEM.*,LedStateName ;VATDistrictName.*,
    Filter : ALLSALES ;,ALLSALES1

    Sort : @@DEFAULT :$LEDGERENTRIES.LEDGERNAME

    Compute : PartyName : $$FuncDSPAccName:$Parent
    ;
    ; ColumnVar: AgeFrom, AgeTo

    [SYSTEM : FORMULAE]

    ALLSALES : $$IsDr:$FINALBALANCE
    ALLSALES1 : $$IfCr:$FINALBALANCE

    ;;UDF definition

    [System:UDF]

    My UDF:String:1000

    ;;modify Ledger Master entry screen and add a line

    [# Part:LEd Other Details]
    Add:Line:MyLine

    [Line :My Line]
    Field:Short Prompt,My Field
    Local :Field:Short Prompt:Set as:"District"
    [Field:My Field]
    Use:Short Name Field
    Storage :My UDF
    ;;End of Code
     
    kishoreji, May 24, 2017
    #12


  13. saif

    saif New Member


    [#Field: EI ValueSubTotal]
    Inactive:Not $$IsSales:##SVVoucherType
    [#Field:EIAccRate]
    Set as: if ($$IsSales:##SVVoucherType and #EIAccDesc="Cash Discount" and #EIValueSubTotal > 0 and #EIValueSubTotal <= 10000 ) Then -12 Else $$Value
    Set Always:$$IsSales:##SVVoucherType
    ;please solve this problem.
    upload_2017-6-29_18-31-44.png



    Cash discount upto 0% to 12%

    Then 13% cash discount don`t voucher accept.
     
    saif, Jun 29, 2017
    #13


  14. Mithilesh

    Mithilesh New Member


    anyone provide solution for this issue. need sales person wise report also.

     
    Mithilesh, Jul 15, 2017
    #14


Share This Page