4 in 1 Ledger Display screen....

Discussion in 'Tally Developer' started by Amit Kamdar, Oct 16, 2018.

         
Tags:
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Only for Debtors & Creditors Ledgers.

    1. Normal Ledger screen
    2. Bill-wise Outstanding
    3. Ageing as per Bill Date
    4. Ageing as per Due Date

    Work ongoing on 3 & 4.

    4 in 1 Ledger display.PNG
     
    Meena Mhatre, Rohit Khedar and Jenny like this.


  2. knsivam89

    knsivam89 Active Member


    Nice Ji,
    I think you fixed that Age-wise Periods. Give it in Based on Configuration. Because Customers may use Different set of days.
     


  3. sekharchana

    sekharchana Member


    amit sir i have started recently using against reference in receipts its also showing previous references which have been settled without reference option

    is there any way in tally to hide those old invoices
    upload_2018-10-16_18-3-40.png
     


  4. sekharchana

    sekharchana Member


    sorry for going off-topic
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yet to start work on the age-wise for this though.................. Yes I am thinking on same line though............
    default will be this set period and i think the default period-sets is more or less standard and meaningful.
    However customer choice will also be done..... yet to figure out a way for this. Been working few weeks to get these 4 together. will work on age-wise in a few days.
     
    knsivam89 likes this.


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Not possible in conventional way ....either set-off the same or don't use references...........only these 2 options.

    By TDL way.....you need to find the Collection for these pending bills and introduce a filter for date cut-off.
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    But i need help also...... see code below........

    [Collection : Monthly Ledger TiO]
    Use : List of Ledgers
    Variable : LedgerName
    Report : LedgerDisplayTiO
    Trigger : LedgerName
    Fetch : Name, Parent
    Filter : IsLedgerDrsCrs

    [System : Formula]
    IsLedgerDrsCrs : $$IsBelongsTo:$$GroupSundryDebtors OR $$IsBelongsTo:$$GroupSundryCreditors

    This is working ----- but it display all LEDGERS, but allows to select Debtors/Creditors only.......... I want to display only Drs/Crs Ledgers...........
     


  8. knsivam89

    knsivam89 Active Member


    Try This Way

    [Collection : ABCD]

    Use : VLedTable
    Type : Ledger
    Fetch : Name
    Include : Group:$$GroupSundryDebtors, Group:$$GroupSundryCreditors
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Not working though............ Is it because of variable and trigger in this collection??
     


  10. knsivam89

    knsivam89 Active Member


    You can remove Use, and Add Trigger Variable. I use This way only. It is Working

    Or Else Check this Default Collection "Party Ledgers", There Same way Collections are there.
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You are right...........i tried all that before.......... in normal it will work.... but here.........

    In this case........ Variable and trigger is required as common fodder for all 4 parts of my report.... when i comment them out, it does not open at all.

    Let me try other things as u said..............
     


  12. Maulik Patel

    Maulik Patel Active Member


    Hi Amitji,

    Instead of $$BelongsTo use $$IsLedOfGrp function, hope it will work
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Hi Maulik...tried that also..........

    I think I will make another collection from scratch...............
     


  14. knsivam89

    knsivam89 Active Member


    Ji Check This Filter

    IsLedgerDrsCrs : $$IsGrpOfGrp:$Parent:$$GroupSundryDebtors OR $$IsGrpOfGrp:$Parent:$$GroupSundryCreditors
     


  15. Maulik Patel

    Maulik Patel Active Member


    Amitji,

    Have you tried calling your own trigger report instead of LedgerName as default trigger will fetch all ledgers.
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dear Maulik,

    Tried that also long back ....but then my reports are deprived of a Variable and shows blank............ See screenshot below.

    Thing is during various R&D on permutations and combination.....one thing is sure........... if there is no variable and trigger in the collection, the whole 4-in-1 concept will not work.

    Capture.PNG
     


  17. knsivam89

    knsivam89 Active Member


    Dear Amit,
    4-in-1 concept is not a mater. You can use a single Variable in whole Report. You r using Default Trigger Report. Change Like This you can Get Result

    [Collection: VC Monthly Ledger]

    Type : Ledger
    Variable : Ledger Name
    Report : Ledger Vouchers
    Trigger : VC Ledger Name
    Fetch : Name
    Filter : VCOnlyDrCrLedger

    [Report: VC Ledger Name]

    Use : Ledger Name
    Local : Field : Ledger NAme : Delete : Table
    Local : Field : Ledger NAme : Add : Table : VC Monthly Ledger
    Local : Field : Ledger NAme : Local : Table : Default : Title : "List Of Parties"

    [System: Formulae]

    VCOnlyDrCrLedger : ($$IsGrpOfGrp:$Parent:$$GroupSundryDebtors) Or ($$IsGrpOfGrp:$Parent:$$GroupSundryCreditors)
     
    vinoth likes this.


  18. Maulik Patel

    Maulik Patel Active Member


    Dear Amitji,

    Try below code
    Code:
    [Collection : Monthly Ledger TiO]
        Use        : List of Ledgers
        Variable: LedgerName
        Report    : LedgerDisplayTiO
        Trigger    : MLKLedgerName
        Fetch    : Name, Parent
        Filter    : IsLedgerDrsCrs
    
    [Report: MLK Ledger Name];;Auto Report
    
                Use     : Collection Variable
                Local   : Line : Collection Variable : Field : MLK Ledger Name
                Local   : Field: MV Title            : Info  : $$LocaleString:"Name of Ledger"
               
                [Field: MLK Ledger Name]
    
                    Use         : Name Field
                    Key         : Create Ledger
                    Modifies    : LedgerName
                    Table       : MLK List of Ledger
                    Show Table  : Always
                    CommonTable : No
       
    [Collection : MLK List of Ledger]
        Use        : List of ExtractLedgers
        Fetch    : Name
        Format    : $Name, Parent
        Filter    : IsLedgerDrsCrs
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dear Maulik,

    This worked wonders.....many thanks..........never thought of using this way........ you are well experienced.

    See screenshot.........

    Capture.PNG
     
    Meena Mhatre likes this.


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dear KNSivam,

    Thanks for your efforts..........now i can concentrate on Ageing Analysis in the coming days............

    Any other ideas / opinions are welcome.

    Thanks again.
     


  21. garima

    garima Active Member


    Ha Ha.. I like the way you draft reports.. it is superb.. beautiful, useful and picturesque.
     
    Amit Kamdar likes this.


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Any reason for the email???? I do not act when there is no rhyme or reason.
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Thank you......Years of experience in designing MIS reports helps........ :)
     
    Meena Mhatre and garima like this.


  24. Swadilas

    Swadilas New Member



    not working for me. can you plz share code again.
     


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    What is not working for you???
     


Share This Page