Area Wise Outstanding Report

Discussion in 'Requests' started by Salman, Feb 2, 2017.

    
  1. Salman

    Salman Member


    Dear All Experts,
    I want outstanding report area wise please share me the code
     


  2. Salman

    Salman Member


    This is my code please correct my code 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
     


Share This Page