1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

In "Outstanding Receivable" how to fetch on account value and closing balance?

Discussion in 'Free Source Codes' started by Jenny, Feb 6, 2020.

    
Page 1 of 2
  1. Jenny

    Jenny Active Member


    Code:
    [#Part: GRPLedBILL Details]
    Add: Lines: After:GRPLedBILL Total :JennyOnaccountDetail,JennyFinalBalDetail
   

[Line: JennyOnaccountDetail]

    Left Fields : BILLFixed1, LedBILLOp1, LedBILLCl1
    Repeat      : LedBILLCl1
   
[Field: BILLFixed1]
    Fields : BILLDate1, BILLRef1, BILLIsAdvance1, BILLParty1
   
[Field: BILLDate1]
    Use     : NameField
    Set as  : ""
    Width   : If ($$InExportMode AND @@IsHTMLFormat) Then (@@ShortDateWidth + 4) Else @@ShortDateWidth
   
[Field: BILLRef1]
    Use     : NameField
    Set as  : ""
    Width       : 12
    SpaceLeft   : if ##IsBillWiseReport AND $$InPixelMode then 2.5 else 0.5
   
[Field: BILLIsAdvance1]
    Use     : NameField
    Set as  : ""
    Width       : If $$InPrintMode Then 6 Else 7
   
[Field: BILLParty1]
    Use     : NameField
    Set as  : ""
    Width       : if NOT $$InPixelMode then @@NameWidth - 3 else if (##ShowOpBillAmt OR $$NumSets > 1) then @@ShortNameWidth + 5 else @@NameWidth + 5
   
[Field: LedBILLOp1]

     Use         : NameField
     Set as      : "On Account"
     Width       : if NOT $$InPixelMode then @@AmountWidth else if ##IsBillWiseReport then @@AmountWidth - 1 else @@NumberWidth + 3
       
[Field: LedBILLCl1]

    Use         : AmountField
    Set as      : $OnAccountValue
    Border        : Sub Totals
    Width       : if NOT $$InPixelMode then @@AmountWidth else if ($$Numsets>1 AND $$InPrintMode) Then @@NumberWidth+1 Else If ##IsBillWiseReport then @@AmountWidth - 1 else @@NumberWidth + 3
    Format         : "DrCr,NoZero," + ##ShowForex
   

   
;;;;;;;;;;;;;;;;;;;;;;Final Balance;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;


[Line: JennyFinalBalDetail]

    Left Fields : BILLFixed11, LedBILLOp11, LedBILLCl11
    Repeat      : LedBILLCl11
   
[Field: BILLFixed11]
    Fields : BILLDate11, BILLRef11, BILLIsAdvance11, BILLParty11
   
[Field: BILLDate11]
    Use     : NameField
    Set as  : ""
    Width   : If ($$InExportMode AND @@IsHTMLFormat) Then (@@ShortDateWidth + 4) Else @@ShortDateWidth
   
[Field: BILLRef11]
    Use     : NameField
    Set as  : ""
    Width       : 12
    SpaceLeft   : if ##IsBillWiseReport AND $$InPixelMode then 2.5 else 0.5
   
[Field: BILLIsAdvance11]
    Use     : NameField
    Set as  : ""
    Width       : If $$InPrintMode Then 6 Else 7
   
[Field: BILLParty11]
    Use     : NameField
    Set as  : ""
    Width       : if NOT $$InPixelMode then @@NameWidth - 3 else if (##ShowOpBillAmt OR $$NumSets > 1) then @@ShortNameWidth + 5 else @@NameWidth + 5
   
[Field: LedBILLOp11]

     Use         : NameField
     Set as      : "Final Amount"
     Width       : if NOT $$InPixelMode then @@AmountWidth else if ##IsBillWiseReport then @@AmountWidth - 1 else @@NumberWidth + 3
       
[Field: LedBILLCl11]
    Use         : AmountField
        Type        : Amount
        Set as      : $FinalBalance
        Style       : "Normal"
        Width       : if NOT $$InPixelMode then @@AmountWidth else @@NumberWidth
        Format      : "DrCr,NoZero," + ##ShowForex
        Border        : Sub Totals
     

    Attached Files:

    Jenny, Feb 6, 2020
    #1


  2. Gangadhar C Beldar

    Gangadhar C Beldar Member


    I you Analysis and Use this [Line: BILL OnAccDetail] : Is this a way to Find the Solutions
     
    Gangadhar C Beldar, Feb 6, 2020
    #2


  3. zakirhossain_diu

    zakirhossain_diu Member


    Please check something like
    $OnAccountValue:Ledger:#LedgerName
     
    zakirhossain_diu, Feb 7, 2020
    #3


  4. Jenny

    Jenny Active Member


    i do but not working
     
    Jenny, Feb 8, 2020
    #4


  5. zakirhossain_diu

    zakirhossain_diu Member


    You can not use #ledgername
    You need to change it accordingly field name within your report. On account value of referred field.
    Otherwise you may have to send sample data and your codes for detailed check. Thank you
     
    zakirhossain_diu, Feb 8, 2020
    #5


  6. Jenny

    Jenny Active Member


    Thank you........my query solved.....
     
    Jenny, Feb 8, 2020
    #6
    zakirhossain_diu likes this.


  7. Rupesh H

    Rupesh H New Member


    Nice work madam
    Can you send me the file on roopeshrh@gmail.com
     
    Rupesh H, Dec 15, 2020
    #7


  8. NainaSiraj

    NainaSiraj Member


    nice janny you
     
    NainaSiraj, Dec 15, 2020
    #8


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    @Jenny --- Have you Solved this ???
     
    Amit Kamdar, Dec 16, 2020
    #9


  10. Rupesh H

    Rupesh H New Member


    No sir
    I didnt get the on account all Billwise receipt details in outstanding BR
    Please help !!!
    Thanks
     
    Rupesh H, Dec 16, 2020
    #10


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You need to compute the values in the COLLECTION of that report.
     
    Amit Kamdar, Dec 16, 2020
    #11
    Jaydeep Shah likes this.


  12. Rupesh H

    Rupesh H New Member


    Dear sir
    Give me some hint on this code
    Since I am new in this field
    Pls help!!!
     
    Rupesh H, Dec 16, 2020
    #12


  13. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    [#Line: GRPLedBILL Total]
    Local : Field : BILLParty : Set as : $PartyName
    Local : Field : BILLParty : Full Width:Yes
     
    PANKAJ BHONDLE, Dec 16, 2020
    #13


  14. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    [#Line: GRPLedBILL Total]
    Local : Field : BILLParty : Set as : $PartyName
    Delete:Repeat
    Local : Field : BILLParty : Width:68
     
    PANKAJ BHONDLE, Dec 16, 2020
    #14


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    What is the purpose of this code snippet vis-a-vis the query of this Topic ???
     
    Amit Kamdar, Dec 16, 2020
    #15


  16. Rupesh H

    Rupesh H New Member


    Not Working Sir
    On Account Bills Receipts amount not fetch
    Please member
    can anybody help
     
    Rupesh H, Dec 16, 2020
    #16


  17. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    [#Part: GRPLedBILL Details]
    Add: Lines: After:GRPLedBILL Total :pKOnaccountDetail,PkFinalBalDetail

    [Line: PKOnaccountDetail]
    Left Fields : BILLFixed1, LedBILLOp1, LedBILLCl1

    [Field: BILLFixed1]
    Fields : BILLDate1, BILLRef1, BILLIsAdvance1, BILLParty1

    [Field: BILLDate1]
    Use : NameField
    Set as : ""
    Width : If ($$InExportMode AND @@IsHTMLFormat) Then (@@ShortDateWidth + 4) Else @@ShortDateWidth

    [Field: BILLRef1]
    Use : NameField
    Set as : ""
    Width : 12
    SpaceLeft : if ##IsBillWiseReport AND $$InPixelMode then 2.5 else 0.5

    [Field: BILLIsAdvance1]
    Use : NameField
    Set as : ""
    Width : If $$InPrintMode Then 6 Else 7

    [Field: BILLParty1]
    Use : NameField
    Set as : ""
    Width:if ##DSPAgeByDueDate then 47.5 else 60

    [Field: LedBILLOp1]
    Use : NameField
    Set as : "On Account"
    Width : if ##IsBillWiseReport AND $$InPixelMode then 23.5 else ""

    [Field: LedBILLCl1]
    Use : AmountField
    Set as : $OnAccountValue:Ledger:$PartyName
    Width : if NOT $$InPixelMode then @@AmountWidth else if ($$Numsets>1 AND $$InPrintMode) Then @@NumberWidth+1 Else If ##IsBillWiseReport then @@AmountWidth - 1 else @@NumberWidth + 3
    Format : "DrCr,NoZero," + ##ShowForex
    Style : Normal bold
    Color : blue


    ;;;;;;;;;;;;;;;;;;;;;;Final Balance;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;


    [Line: PkFinalBalDetail]
    Left Fields : BILLFixed11, LedBILLOp11, LedBILLCl11

    [Field: BILLFixed11]
    Fields : BILLDate11, BILLRef11, BILLIsAdvance11, BILLParty11

    [Field: BILLDate11]
    Use : NameField
    Set as : ""
    Width : If ($$InExportMode AND @@IsHTMLFormat) Then (@@ShortDateWidth + 4) Else @@ShortDateWidth

    [Field: BILLRef11]
    Use : NameField
    Set as : ""
    Width : 12
    SpaceLeft : if ##IsBillWiseReport AND $$InPixelMode then 2.5 else 0.5

    [Field: BILLIsAdvance11]
    Use : NameField
    Set as : ""
    Width : If $$InPrintMode Then 6 Else 7

    [Field: BILLParty11]
    Use : NameField
    Set as : ""
    Width:if ##DSPAgeByDueDate then 47.5 else 60

    [Field: LedBILLOp11]
    Use : NameField
    Set as : "Final Amount"
    Width : if ##IsBillWiseReport AND $$InPixelMode then 23.5 else ""

    [Field: LedBILLCl11]
    Use : AmountField
    Type : Amount
    Set as : $$NettAmount:$FinalBalance:#LedBILLCl1
    Style : Normal bold
    Width : If ##IsBillWiseReport then @@AmountWidth - 1 else @@NumberWidth + 3
    Format : "DrCr,NoZero," + ##ShowForex
    Border : Sub Totals
    Color : red
     
    PANKAJ BHONDLE, Dec 17, 2020
    #17
    naren1234 likes this.


  18. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2020-12-17_1-59-49.png
     
    PANKAJ BHONDLE, Dec 17, 2020
    #18
    naren1234 likes this.


  19. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    [Line: PKOnaccountDetail]
    Left Fields : BILLFixed1, LedBILLOp1, LedBILLCl1
    OPTION:YourLine:##ExplodeFlag

    [Line:YourLine]
    field:FieldName
     
    PANKAJ BHONDLE, Dec 17, 2020
    #19
    naren1234 likes this.


  20. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Rupesh Ji, kuch aap bhi try karo tab hi aap sikh paonge
     
    PANKAJ BHONDLE, Dec 17, 2020
    #20


  21. Rupesh H

    Rupesh H New Member


    Yes sir
    I am trying to learn!
    Main isme naya hoon
    Toh aap jaise experts se Sikh payunga
    Kripya co-operate kijiye sir
    Help ke liye shukriya
     
    Rupesh H, Dec 17, 2020
    #21


  22. Rupesh H

    Rupesh H New Member


    Sir
    Kripya Mujhe koi book reference bataye
    Jo basic sikhane main help kare
    Thanks once again sir
     
    Rupesh H, Dec 17, 2020
    #22


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Abhi sab reference manual ONLINE hai Tally ke website pe.........
    Purana manual aap Google pe search kar lijiye....for basic..........

    TDL is best learned with hands on practical training...........
    Developer download ke saaath kaafi SAMPLES bhi hai.............
    app dheer dheer ek ke baad ek....karke learn kijiye.....about that........

    Also there are many tutorials on youtube for TDL learner.... basics and advanced.
     
    Amit Kamdar, Dec 18, 2020
    #23


  24. Rupesh H

    Rupesh H New Member


    Thank you once again for your support
     
    Rupesh H, Dec 18, 2020
    #24


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The Bottom total does not reflect.........
    Nor does it reflect properly in all reports as well as Age-wise.
     
    Last edited: Dec 18, 2020
    Amit Kamdar, Dec 18, 2020
    #25
    naren1234 likes this.


Page 1 of 2

Share This Page