Need help on Ledger wise report

Discussion in 'Requests' started by Venkat1433, Aug 8, 2018.

    
  1. Devaki

    Devaki Member



  2. Johar

    Johar Member



  3. Rohit Khedar

    Rohit Khedar Member



  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Have you finished?? submit screenshot here............
     


  5. mpal2311

    mpal2311 Active Member



  6. Umashankar

    Umashankar Member



  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Can someone help with this...........

    7Capture.PNG
     


  8. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Respective Amitji, above screenshot problems solve one week time, i am try it
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Thanks Pankaj....
     


  10. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Respective Amitji, Above screenshot problems solve, but my problem is not contra voucher debit & credit amount seprataly
     


  11. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If your problem is not contra voucher debit & credit amount seprataly .... then what is the real problem??? didn't get you..
     


  13. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    contra withdrawals & contra deposits amount (above screenshot-same amount)
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Filter out the debits n credits......

    However the TOTALS would be same....but one debit and other credit
     


  15. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    pease send filter formula
    Aggr Compute:ContraDebitExtract :Sum:if $$IsContra:$VoucherTypeName THEN $Amount ELSE ""
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    This is okay....

    In your field use condition.......... If $$IsDr:$ContraDebitExtract then $ContraDebitExtract Else ""
    same for credit extract.............
     


  17. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    im also try but figure empty
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You must be doing something wrong somewhere.......
     


  19. Vashisth

    Vashisth New Member



  20. sivam

    sivam Active Member


    Amit Kamdar,

    Just Try with this way

    in Set as : $$CollectionAmtTotal:<ExplodeCollection Name>:<Object Name>
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Am using the same format as you have suggested......

    The problem is like this....
    Main Group........Total not showing..... LEVEL1
    .......Sub Group..........showing..... LEVEL2
    .............Sub-Sub Group.......showing LEVEL3
    ......................Sub-Sub-Sub Group.......showing LEVEL4

    However if I go down one level...i.e. Level 2..........then sub-totals of level 3 n 4 will show and now since level2 becomes Main Group.... it does not show........

    See attached photos 1, 2 and 3

    Photo 1 - Level 1 ---- Main collection of Groups...of which Current Liabilities is a part.
    Photo 2 - Level 2 --- Under Current Liabilities there are sub-groups...so sub-groups totals are coming but not Sundry Creditors as it has more groups under it.
    Photo 3 - Level 3 --- If under Sundry Creditors...then all is well and computing as there are no further sub-level groups here.

    level 1 - Capture.PNG level 2 - Capture.PNG level 3 - Capture.PNG
     
    Jaydeep Shah likes this.



  22. wILL YOU SHARE ME THIS CODE ON MINE EMAIL ID

    SANDIPNITRO@GMAIL.COM
     


  23. sumer sharma90

    sumer sharma90 New Member



  24. Bipin Damania

    Bipin Damania Active Member



  25. Devaki

    Devaki Member



Share This Page