1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Bill wise Outstanding all debtors but when i export to excel manage column so please correct my code

Discussion in 'Free Source Codes' started by pramod5542, Jul 25, 2018.

    
Page 1 of 2
  1. pramod5542

    pramod5542 Member


    ;; The sample code gives report showing All the Party Leger name with its Bill Wise Outstanding in One report - Zero balance filter given

    [#Part: CMP AccFeat Right]

    Option: CS_EnableViewReport : NOT $$IsRemoteCompany

    [!Part:CS_EnableViewReport]

    Add: Line: CS_EnableViewReport


    [Line: CS_EnableViewReport]

    Fields : Medium Prompt, CS_EnableViewReport
    Local : Field : Medium Prompt : Info : $$LocaleString:"BIll-Wise Outstanding Report"
    Space Top : 0.4


    [Field: CS_EnableViewReport]

    Use : Logical Field
    Storage : CS_EnableViewReport

    [System: UDF]

    CS_EnableViewReport: Logical : 7532



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




    [#Menu : Gateway Of Tally]

    Add: Option : CS_ViewLedItemReport : $CS_EnableViewReport:company:##SVCurrentCompany

    [!Menu:CS_ViewLedItemReport]

    Add: Item : Before : ~locQuit : Bill Wise Outstanding : Menu : Bill Wise Outstanding



    [Menu : Bill Wise Outstanding]


    Item : Outstanding Bill Breakup : Display : Bill Wise Outstanding

    [Report : Bill Wise Outstanding]


    Form : MyTdl
    Family : "Outstandings"

    List Name : "Bill-wise Details"
    Variables : SV CurrentCompany, SVFromDate, SVToDate, SVSortMethod, LedgerName, SVBudget, SVVariance
    Variables : ExplodeFlag, IsForexReport
    Variable : DSPShowMonthly, DSPHasMultiLevel
    Variable : ShowDaysByBillDate
    Variable : ShowBillRange, IsBillWiseReport, IsLedgerReport, IsCCReport, IsVchTypeReport
    Variable : DSPNotScaleable, DSPHasColumnTotal, DSPAgeByDueDate
    Variable : AgeFrom, AgeTo, ShowReminders, ShowForex
    Variable : IsMultiPage, InNewPages, ShowBillType, IsGrpBillReport
    Repeat : AgeFrom, AgeTo


    Set : SV Sort Method : @@Default
    Set : DSPShowMonthly : No
    Set : ShowDaysByBillDate: Yes
    Set : IsBillWiseReport : Yes
    Set : IsLedgerReport : Yes
    Set : IsGrpBillReport : No
    Set : DSPHasMultiLevel : No
    Set : DSPNotScaleable : Yes
    Set : DSPHasColumnTotal : No
    Set : IsMultiPage : No
    Set : SVBudget : ""

    Set : SV From Date : $$MonthStart:##SVCurrentDate
    Set : SV To Date : $$MonthEnd:##SVCurrentDate

    Export : Yes



    [Form : MyTdl]
    Use : DSP Template
    Width : 100% Page
    Height : 100% Page
    BackGround : Light Sea Green
    Parts : Subbu Title, Subbu Body ;;;,SubbuTotal
    Button : Print Button,AgeWiseAnalysis

    Add : Buttons : Remove Line, Restore Line, Restore All

    [Button : Remove Line]
    Action : Remove Line : Remove Line
    Key : Alt + R

    [Button : Restore Line]
    Action : Show Last Removed Line : Restore Line
    Key : Alt + U

    [Button : Restore All]
    Action : Show Removed Lines : Restore All
    Key : Ctrl + U

    [Part : Subbu Title]
    Line : subbu Title
    [Border : Subbu Title Border]
    Top : Thin
    Bottom : Thin


    [Line : Subbu Title]
    Border : Subbu Title Border
    Fields : Subbu Title
    Right Fields : Subbu DrAmount Title, Subbu CrAmount Title


    [Field : Subbu Title]
    Use : Name Field
    Set as : "Particulars"
    FullWidth : Yes
    Style : Large
    Border : Thin Bottom
    BackGround : yellow

    [Field : Subbu DrAmount Title]
    Width : @@AmountWidth
    Set as : "Debit"
    Style : Large
    Border : Thin Bottom
    Align: Right
    BackGround : yellow

    [Field : Subbu CrAmount Title]
    Use : Subbu DrAmount Title
    Set as : "Credit"
    Style : Large
    Border : Thin Bottom
    BackGround : yellow


    [Part : Subbu Body]

    Line : Subbu Body Detail ;;,Subbu
    Repeat : Subbu Body Detail : Ledger
    Scroll : Vertical
    Local : Collection : Ledger : Filter : OnlyCplParty

    [Line : Subbu Body Detail]
    Left Fields : MyLedName
    Right Fields : MyDrAmount , MyCrAmount
    Explode : MyExplodPart : ($$KeyExplode OR ##ExplodeFlag)



    [!Part : MyExplodPart]
    Lines: JlLedger Bills Title, JlLedger Bills, Jl OnAccount Bills, ZJlEmptyLine
    Repeat: JlLedger Bills : Ledger Bills
    Scroll: Vertical
    Vertical: Yes



    [Line : ZJlEmptyLine]
    Fields : Info Field
    Local : Field : Info Field : Info : ""

    [Line : JlLedger Bills Title]
    Line : JlLedger Bills Title1, JlLedger Bills Title2

    [Line : JlLedger Bills Title1]


    Fields: JLBill DateTitle, JLBillNoTitle, JLBill OpeningAmountTitle, JLBill AmountTitle, JlBill CBlackitPeriodTitle, JlBill OverduedaysTitle

    Local : Field : JLBill DateTitle : Info : ""

    Local : Field : JLBillNoTitle : Info : ""
    Local : Field : JLBill OpeningAmountTitle : Info : "Opening"
    Local : Field : JLBill AmountTitle : Info : "Pending"
    Local : Field : JlBill CBlackitPeriodTitle : Info : "Credit"
    Local : Field : JlBill OverduedaysTitle : Info : "Overdue"


    [Line : JlLedger Bills Title2]

    Fields: JLBill DateTitle, JLBillNoTitle, JLBill OpeningAmountTitle, JLBill AmountTitle, JlBill CBlackitPeriodTitle, JlBill OverduedaysTitle
    Local : Field : JLBill DateTitle : Info : "Bill Date"
    Local : Field : JLBill JLBillNoTitle : Info : "Bill Number"
    Local : Field : JLBill OpeningAmountTitle : Info : "Amount"
    Local : Field : JLBill AmountTitle : Info : "Amount"
    Local : Field : JlBill CBlackitPeriodTitle : Info : "Period"
    Local : Field : JlBill OverduedaysTitle : Info : " Days"



    [Field : JLBill DateTitle]

    Use: Short Name Field
    Set as: "Bill Date"
    Style: Small bold
    Width: 15
    Align: Center
    Color: Black
    BackGround : yellow

    [Field : JLBillNoTitle]
    Use: Short Name Field
    Set as: "Bill Number"
    Style: Small bold
    Width: 11
    Align: Right
    Color: Black
    BackGround : yellow

    [Field: JLBill OpeningAmountTitle]
    Use: Short Name Field
    Set as: "Opening Amount"
    Style: Small bold
    Width: 16
    Align: Right
    Color: Black
    BackGround : yellow

    [Field: JLBill AmountTitle]
    Use: Short Name Field
    Set as: "Pending Amount"
    Style: Small bold
    Width: 15
    Align: Right
    Color: Black
    BackGround : yellow

    [Field : JLBill CBlackitPeriodTitle]
    Use: Short Name Field
    Set as: "CBlackit Period"
    Style: Small bold
    Width: 15
    Align: Right
    Color: Black
    BackGround : yellow

    [Field : JlBill OverduedaysTitle]
    Use: Short Name Field
    Set as: "Overdue by Days"
    Style: Small bold
    Width: 15
    Align: Center
    Color: Black
    BackGround : yellow

    [Line : Jl OnAccount Bills]

    Empty: $$IsEmpty:$OnAccountValue:Ledger:#LedgerName
    Fields: JLBill Date, JL OnAccount Bills Title, JL OnAccount Amount
    Local: Field : JLBill Date : Set as : " "

    [Field : Jl OnAccount Bills Title]
    Use: Short Name Field
    Style: Small Bold
    Width: 14
    Align: Right
    Set as: "On Account "
    Invisible: $$IsEmpty:$OnAccountValue:Ledger:#LedgerName

    [Field : Jl OnAccount Amount]
    Use: Amount Field
    Set as: $OnAccountValue:Ledger:#LedgerName
    Style : Small bold
    Width : 15
    Format : "DrCr,NoZero," + ##ShowForex
    Invisible: $$IsEmpty:$OnAccountValue:Ledger:#LedgerName

    [Line : JlLedger Bills]


    Fields: JLBill Date, JlBillNo, JLBill OpeningAmount, JLBill Amount, JlBill CBlackitPeriod, JlBill Overduebydays



    [Field : JLBill Date]
    Use: UniDateField
    Set as: $BillDate
    Style: Small
    Width: 14
    Align: Center

    [Field : JLBillNo]
    Use: Short Name Field
    Set as: $Name
    Style: Small
    Width: 14
    Align: Right

    [Field: JLBill OpeningAmount]
    Use : AmountField
    Type : Amount
    Set as : $OpeningBalance
    Style : Small
    Width : 15
    Format : "DrCr,NoZero," + ##ShowForex


    [Field: JLBill Amount]
    Use : AmountField
    Type : Amount
    Set as : $FinalBalance
    Style : Small
    Width : 15
    Format : "DrCr,NoZero," + ##ShowForex

    [Field : JLBill CBlackitPeriod]
    Use : UniDateField
    Set as : If $$IsEmpty:$BillCBlackitPeriod then $BillDate else $BillCBlackitPeriod
    Style : Small
    Width : 16


    [Field : JlBill Overduebydays]
    Set as : if ##ShowDaysByBillDate then @DaysByBillDate else @DaysByDueDate
    DaysByBillDate : $$String:mad:BillDays
    DaysByDueDate : if @@DSPToDate >= @@CBlackitPeriod then $$String:mad:OverDueDays else ""
    OverDueDays : @@DSPToDate - @@CBlackitPeriod
    BillDays : @@DSPToDate - $BillDate
    Width : 8
    Style : Small
    Align : Right
    Invisible : NOT ($$InPixelMode OR $$InExportMode)


    [Field : MyLedName]
    Set As: $Name
    Variable: LedgerName
    Modifies: ledgerName
    Style: Small bold
    FullWidth: Yes
    Invisible: $$IsEmpty:$ClosingBalance
    Color: Black


    [Field : MyCrAmount]
    Type: Amount
    Width: @@AmountWidth
    Align: Right
    Style: Small bold
    Border: Thin Bottom: $$IsExploded
    Set as: If Not $$Isdr:$ClosingBalance Then $ClosingBalance Else 0
    Invisible: $$IsEmpty:$ClosingBalance
    [Field : MyDrAmount]
    Use: MyCrAmount
    Set as: If $$IsDr:$ClosingBalance Then $ClosingBalance Else 0
    Invisible: $$IsEmpty:$ClosingBalance

    -------------------------------------------------------------------------------------
    Please see the image below which i want
     

    Attached Files:

    • 1.jpg
      1.jpg
      File size:
      98.7 KB
      Views:
      322
    Last edited: Jul 25, 2018
    pramod5542, Jul 25, 2018
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    ok...will check it after 31st...am out of town -- on Audit till then...........
     
    Amit Kamdar, Jul 26, 2018
    #2
    pramod5542 likes this.


  3. pramod5542

    pramod5542 Member


    I WANT TO LIKE THIS EXCEL ..SEE THE IMAGE BELOW
     

    Attached Files:

    pramod5542, Jul 27, 2018
    #3


  4. pramod5542

    pramod5542 Member


    I SOLVE MY PROBLEM......FINAL CODE IS GIVEN BELOW :

    ;; The sample code gives report showing All the Party Leger name with its Bill Wise Outstanding in One report - Zero balance filter given

    [#Part: CMP AccFeat Right]

    Option: CS_EnableViewReport : NOT $$IsRemoteCompany

    [!Part:CS_EnableViewReport]

    Add: Line: CS_EnableViewReport


    [Line: CS_EnableViewReport]

    Fields : Medium Prompt, CS_EnableViewReport
    Local : Field : Medium Prompt : Info : $$LocaleString:"BIll-Wise Outstanding Report"
    Space Top : 0.4


    [Field: CS_EnableViewReport]

    Use : Logical Field
    Storage : CS_EnableViewReport

    [System: UDF]

    CS_EnableViewReport: Logical : 7532



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




    [#Menu : Gateway Of Tally]

    Add: Option : CS_ViewLedItemReport : $CS_EnableViewReport:company:##SVCurrentCompany

    [!Menu:CS_ViewLedItemReport]

    Add: Item : Before : ~locQuit : Bill Wise Outstanding : Menu : Bill Wise Outstanding

    [Menu : Bill Wise Outstanding]
    Item : Outstanding Bill Breakup : Display : Bill Wise Outstanding

    [Report : Bill Wise Outstanding]


    Form : MyTdl
    Family : "Outstandings"

    List Name : "Bill-wise Details"
    Variables : SV CurrentCompany, SVFromDate, SVToDate, SVSortMethod, LedgerName, SVBudget, SVVariance
    Variables : ExplodeFlag, IsForexReport
    Variable : DSPShowMonthly, DSPHasMultiLevel
    Variable : ShowDaysByBillDate
    Variable : ShowBillRange, IsBillWiseReport, IsLedgerReport, IsCCReport, IsVchTypeReport
    Variable : DSPNotScaleable, DSPHasColumnTotal, DSPAgeByDueDate
    Variable : AgeFrom, AgeTo, ShowReminders, ShowForex
    Variable : IsMultiPage, InNewPages, ShowBillType, IsGrpBillReport
    Repeat : AgeFrom, AgeTo


    Set : SV Sort Method : @@Default
    Set : DSPShowMonthly : No
    Set : ShowDaysByBillDate: Yes
    Set : IsBillWiseReport : Yes
    Set : IsLedgerReport : Yes
    Set : IsGrpBillReport : No
    Set : DSPHasMultiLevel : No
    Set : DSPNotScaleable : Yes
    Set : DSPHasColumnTotal : No
    Set : IsMultiPage : No
    Set : SVBudget : ""

    Set : SV From Date : $$MonthStart:##SVCurrentDate
    Set : SV To Date : $$MonthEnd:##SVCurrentDate

    Export : Yes



    [Form : MyTdl]
    Use : DSP Template
    Width : 100% Page
    Height : 100% Page
    BackGround : Light Sea Green
    Parts : Subbu Title, Subbu Body ;;;,SubbuTotal
    Button : Print Button,AgeWiseAnalysis

    Add : Buttons : Remove Line, Restore Line, Restore All

    [Button : Remove Line]
    Action : Remove Line : Remove Line
    Key : Alt + R

    [Button : Restore Line]
    Action : Show Last Removed Line : Restore Line
    Key : Alt + U

    [Button : Restore All]
    Action : Show Removed Lines : Restore All
    Key : Ctrl + U

    [Part : Subbu Title]
    Line : subbu Title
    [Border : Subbu Title Border]
    Top : Thin
    Bottom : Thin


    [Line : Subbu Title]
    Border : Subbu Title Border
    Fields : Subbu Title
    Right Fields : Subbu DrAmount Title, Subbu CrAmount Title


    [Field : Subbu Title]
    Use : Name Field
    Set as : "Particulars"
    FullWidth : Yes
    Style : Large
    Border : Thin Bottom
    BackGround : yellow

    [Field : Subbu DrAmount Title]
    Width : @@AmountWidth
    Set as : "Debit"
    Style : Large
    Border : Thin Bottom
    Align: Right
    BackGround : yellow

    [Field : Subbu CrAmount Title]
    Use : Subbu DrAmount Title
    Set as : "Credit"
    Style : Large
    Border : Thin Bottom
    BackGround : yellow


    [Part : Subbu Body]

    Line : Subbu Body Detail ;;,Subbu
    Repeat : Subbu Body Detail : Ledger
    Scroll : Vertical

    Local : Collection : Ledger : Filter : OnlyCplParty

    [Line : Subbu Body Detail]

    Left Fields : MyLedName

    Right Fields : MyDrAmount , MyCrAmount
    Explode : MyExplodPart : ($$KeyExplode OR ##ExplodeFlag)



    [!Part : MyExplodPart]
    Lines: JlLedger Bills Title, JlLedger Bills, Jl OnAccount Bills, ZJlEmptyLine
    Repeat: JlLedger Bills : Ledger Bills
    Scroll: Vertical
    Vertical: Yes


    [Line : ZJlEmptyLine]
    Fields : Info Field
    Local : Field : Info Field : Info : ""

    [Line : JlLedger Bills Title]
    Line : JlLedger Bills Title1
    [Line : JlLedger Bills Title1]

    LeftFields : JLBill DateTitle1, JLBill DateTitle2, JLBill DateTitle3, JLBill DateTitle, JLBillNoTitle, JLBill OpeningAmountTitle, JLBill AmountTitle, JlBill CBlackitPeriodTitle, JlBill OverduedaysTitle
    Border : Column Titles




    Local : Field : JLBill DateTitle1 : Info : ""+$$NewLine
    Local : Field : JLBill DateTitle1: Line : 0
    Local : Field : JLBill DateTitle2 : Info : ""+$$NewLine
    Local : Field : JLBill DateTitle2: Line : 0
    Local : Field : JLBill DateTitle3 : Info : ""+$$NewLine
    Local : Field : JLBill DateTitle3: Line : 0
    Local : Field : JLBill DateTitle : Info : "Bill Date"
    Local : Field : JLBillNoTitle : Info : "Bill Number"
    Local : Field : JLBill OpeningAmountTitle : Info : "Opening Amount"+$$NewLine
    Local : Field : JLBill OpeningAmountTitle: Line : 0
    Local : Field : JLBill AmountTitle : Info : "Pending Amount"+$$NewLine
    Local : Field : JLBill AmountTitle: Line : 0
    Local : Field : JlBill CBlackitPeriodTitle : Info : "Credit Period"+$$NewLine
    Local : Field : JlBill CBlackitPeriodTitle : Line : 0
    Local : Field : JlBill OverduedaysTitle : Info : "Overdue Days"+$$NewLine
    Local : Field : JlBill OverduedaysTitle : Line : 0



    [Field : JLBill DateTitle1]
    Use: Short Name Field
    Set as: ""
    Style: Small bold
    Width: 10
    Align: Right
    Color: Black


    [Field : JLBill DateTitle2]
    Use: Short Name Field
    Set as: ""
    Style: Small bold
    Width: 10
    Align: Right
    Color: Black


    [Field : JLBill DateTitle3]
    Use: Short Name Field
    Set as: ""
    Style: Small bold
    Width: 10
    Align: Right
    Color: Black


    [Field : JLBill DateTitle]
    Use: Short Name Field
    Set as: "Bill Date"
    Style: Small bold
    Width: 12
    Align: Centre
    Color: Black
    BackGround : yellow
    Border : Thin LeftRight

    [Field : JLBillNoTitle]
    Use: Short Name Field
    Set as: "Bill Number"
    Style: Small bold
    Width: 18
    Align: Centre
    Color: Black
    BackGround : yellow
    Border : Thin LeftRight

    [Field: JLBill OpeningAmountTitle]
    Use: Short Name Field
    Set as: "Opening Amount"
    Style: Small bold
    Width: 13
    Align: Center
    Color: Black
    BackGround : yellow
    Border : Thin LeftRight


    [Field: JLBill AmountTitle]
    Use: Short Name Field
    Set as: "Pending Amount"
    Style: Small bold
    Width: 13
    Align: Center
    Color: Black
    BackGround : yellow
    Border : Thin LeftRight

    [Field : JLBill CBlackitPeriodTitle]
    Use: Short Name Field
    Set as: "CBlackit Period"
    Style: Small bold
    Width:10
    Align: Centre
    Color: Black
    BackGround : yellow
    Border : Thin LeftRight

    [Field : JlBill OverduedaysTitle]
    Use: Short Name Field
    Set as: "Overdue by Days"
    Style: Small bold
    Width: 8
    Align: Center
    Color: Black
    BackGround : yellow
    Border : Thin LeftRight

    [Line : Jl OnAccount Bills]

    Empty: $$IsEmpty:$OnAccountValue:Ledger:#LedgerName
    Fields: JLBill DateTitle1, JLBill DateTitle2,JLBill DateTitle3, JLBill Date, JL OnAccount Bills Title, JL OnAccount Amount
    Local: Field : JLBill Date : Set as : " "
    Local: Field : JLBill DateTitle1 : Set as : " "
    Local: Field : JLBill DateTitle2 : Set as : " "
    Local: Field : JLBill DateTitle3 : Set as : " "

    [Field : Jl OnAccount Bills Title]
    Use: Short Name Field
    Style: Small Bold
    Width: 14
    Align: Right
    Set as: "On Account "
    Invisible: $$IsEmpty:$OnAccountValue:Ledger:#LedgerName

    [Field : Jl OnAccount Amount]
    Use: Amount Field
    Set as: $OnAccountValue:Ledger:#LedgerName
    Style : Small bold
    Width : 15
    Format : "DrCr,NoZero," + ##ShowForex
    Invisible: $$IsEmpty:$OnAccountValue:Ledger:#LedgerName

    [Line : JlLedger Bills]
    LeftFields: JLBill DateTitle1, JLBill DateTitle2, JLBill DateTitle3, JLBillDate, JlBillNo, JLBill OpeningAmount, JLBill Amount, JlBill CBlackitPeriod, JlBill Overduebydays




    [Field : JLBillDate]
    Use: UniDateField
    Set as: $BillDate
    Style: Small
    Width: 12
    Align: Left


    [Field : JLBillNo]
    Use: Short Name Field
    Set as: $Name
    Style: Small
    Width: 18
    Align: Left


    [Field: JLBill OpeningAmount]
    Use : AmountField
    Type : Amount
    Set as : $OpeningBalance
    Style : Small
    Width : 13
    Format : "DrCr,NoZero," + ##ShowForex
    Align: Left

    [Field: JLBill Amount]
    Use : AmountField
    Type : Amount
    Set as : $FinalBalance
    Style : Small
    Width : 13
    Format : "DrCr,NoZero," + ##ShowForex
    Align: Left

    [Field : JLBill CBlackitPeriod]
    Use : UniDateField
    Set as : If $$IsEmpty:$BillCBlackitPeriod then $BillDate else $BillCBlackitPeriod
    Style : Small
    Width : 10
    Align: Left


    [Field : JlBill Overduebydays]
    Set as : if ##ShowDaysByBillDate then @DaysByBillDate else @DaysByDueDate
    DaysByBillDate : $$String:mad:BillDays
    DaysByDueDate : if @@DSPToDate >= @@CBlackitPeriod then $$String:mad:OverDueDays else ""
    OverDueDays : @@DSPToDate - @@CBlackitPeriod
    BillDays : @@DSPToDate - $BillDate
    Width : 8
    Style : Small
    Align : Center
    Invisible : NOT ($$InPixelMode OR $$InExportMode)



    [Field : MyLedName]
    Set As: $Name
    Variable: LedgerName
    Modifies: ledgerName
    Style: Small bold
    FullWidth: Yes
    Invisible: $$IsEmpty:$ClosingBalance
    Color: Black


    [Field : MyCrAmount]
    Type: Amount
    Width: @@AmountWidth
    Align: Right
    Style: Small bold
    Set as: If Not $$Isdr:$ClosingBalance Then $ClosingBalance Else 0
    Invisible: $$IsEmpty:$ClosingBalance
    [Field : MyDrAmount]
    Use: MyCrAmount
    Set as: If $$IsDr:$ClosingBalance Then $ClosingBalance Else 0
    Invisible: $$IsEmpty:$ClosingBalance
     
    pramod5542, Jul 27, 2018
    #4


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    congrats....well done.............will check it once am back.........good job..
     
    Amit Kamdar, Jul 27, 2018
    #5


  6. pramod5542

    pramod5542 Member


    In that report how to open particular Ledger when enter the Ledger Name..(ex. Alter On Enter)
     
    pramod5542, Jul 28, 2018
    #6


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    ADD Line -----> Display : Ledger Vouchers in [Field : MyLedName]
     
    Amit Kamdar, Jul 29, 2018
    #7


  8. Devaki

    Devaki Member


    how to replace mad
     
    Devaki, Jul 29, 2018
    #8


  9. Devaki

    Devaki Member


    i am learner, please reply
     
    Devaki, Jul 29, 2018
    #9


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    wherever MAD comes in the TDL file replace it with Colon n open bracket i.e. : @

    no space between the two.....
    I've given space because it will convert to MAD SMILEY here too....

    If Colon already exists then simply replace MAD: with @
     
    Last edited: Jul 29, 2018
    Amit Kamdar, Jul 29, 2018
    #10


  11. Devaki

    Devaki Member


    Thank you amit kamdar sir, now it is working, but one doubt , why your putting mad ??
     
    Devaki, Jul 29, 2018
    #11


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    no one is putting mad.....it gets converted automatically.....like a smiley.... it is a shortcut for smiley...sad face etc..

    Hence we request all people to upload the code using the insert Code.............
     
    Amit Kamdar, Jul 29, 2018
    #12


  13. pramod5542

    pramod5542 Member


    Thank You Sir..
     
    pramod5542, Jul 30, 2018
    #13


  14. pramod5542

    pramod5542 Member


    Sir how to add Total Figure in "Opening Amount" & "Pending Amount" ?
     
    pramod5542, Jul 30, 2018
    #14


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Where ?? at the bottom......?

    show screenshot on what and where u want?
     
    Amit Kamdar, Jul 30, 2018
    #15


  16. pramod5542

    pramod5542 Member


    Untitled.jpg
     
    pramod5542, Jul 30, 2018
    #16


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Do the following changes...........

    Code:
    [!Part : MyExplodPart]
    Lines        : JlLedger Bills Title, JlLedger Bills, Jl OnAccount Bills, ZJlEmptyLine
    Repeat        : JlLedger Bills : Ledger Bills
    Scroll        : Vertical
    Vertical    : Yes
    Bottom Line    : JLedgerTotals
    Totals        : JLBill OpeningAmount, JLBill Amount
    Add this...........code.............

    Code:
    [Line : JLedgerTotals]
LeftFields : JLBill DateTitle1, JLBill DateTitle2, JLBill DateTitle3, JLBill DateTitle, JLBillNoTitle, JLBill OpeningAmountTitle, JLBill AmountTitle, JlBill

CBlackitPeriodTitle, JlBill OverduedaysTitle
Border : Column Titles
Local : Field : JLBill DateTitle1 : Info : ""
Local : Field : JLBill DateTitle2 : Info : ""
Local : Field : JLBill DateTitle3 : Info : ""
Local : Field : JLBill DateTitle : Info : ""
Local : Field : JLBillNoTitle : Info : "GRAND TOTAL"
Local : Field : JLBill OpeningAmountTitle : Set As : $$Total:JLBillOpeningAmount
Local : Field : JLBill AmountTitle : Set As : $$Total:JLBillAmount
Local : Field : JlBill CBlackitPeriodTitle : Info : ""
Local : Field : JlBill OverduedaysTitle : Info : ""
     
    Amit Kamdar, Jul 30, 2018
    #17


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It won't take the "ON ACCOUNT" because your On Account is outside that form.....so you need to incorporate your "on account" field inside it.
     
    Amit Kamdar, Jul 30, 2018
    #18


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In
    [Line : JLedgerTotals]

    Add this....
    Local : Field : Default : Background : <Color choice> ;;; for background color
    Local : Field : Default : Color : <Color choice> ;;; for Font color
     
    Amit Kamdar, Jul 30, 2018
    #19
    info.ap and pramod5542 like this.


  20. pramod5542

    pramod5542 Member


    Is that possible to filter to "Reference No" or "Voucher No"?
     
    pramod5542, Jul 30, 2018
    #20


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    give SORT in your collection.....
     
    Amit Kamdar, Jul 30, 2018
    #21


  22. pramod5542

    pramod5542 Member


    Sir i Put that - Local : Collection : Ledger : Filter : OnlyCplParty
    but its only filter "ledger"
     
    pramod5542, Jul 30, 2018
    #22


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    well make a collection.....rename ledger with JlLedger or something as Tally default by that name already exists...

    Put your filter inside that collection. And also put your SORT.
     
    Amit Kamdar, Jul 30, 2018
    #23


  24. pramod5542

    pramod5542 Member


    Not Working Sir -
    [Collection : JlLedger]
    Type : Vouchers
    Fetch : Date,Amount,VoucherTypeName,PArtyLedgerName,VoucherNumber
     
    pramod5542, Jul 30, 2018
    #24


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member

    Amit Kamdar, Jul 30, 2018
    #25


Page 1 of 2

Share This Page