Need help on Ledger wise report

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

  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very beautifully done Pankaj.....

    A few suggestions......
    a. In your Border definitions....use "FULL" so that the horizontal lines are flush with vertical ones.
    b. Use --- Color : If $$IsDr:#OpBalance Then "Blue" Else "Red" to visually identify DR n CR Amts.
    c. Add one column for OTHERS which will contain Journals n Payments (adjustments entries if any).
    d. Remove GROUP column and try to put that above the Column title,so you get more space in Data Report area.
    e. You can also put Invisible formula to hide columns if there are none data to display.

    If you are stuck, let me know.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Here is the screenshot...........

    6Capture.PNG
     
    Vashisth likes this.


  3. info.ap

    info.ap New Member



  4. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Respective Amit Kamdarji,
    please help, negative Quantity field no symbol (-) then color & background highlighted
     


  5. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please use appropriate forum....so that other members can follow the line..............

    you have already made a POST on this topic...so kindly use the same.......
     
    Jaydeep Shah likes this.


  7. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2018-8-12_14-24-4.png
    please, amitji negative qnty no symbol
     

    Attached Files:



  8. nasir

    nasir Member


    can u plz set formulas

    net sale = opening balance+sale amount
    and
    total (Rec-Dis)= Net sale-receipt -discount
    and
    ClosingBalance=net sale-total receipt
     


  9. nasir

    nasir Member


    can u plz set Grand totals as bottom plzzzzzz
     


  10. nasir

    nasir Member


    can u plz set grands total at bottom plzz for every column
     


  11. Devaki

    Devaki Member



  12. Johar

    Johar Member



  13. Rohit Khedar

    Rohit Khedar Member



  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


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


  15. mpal2311

    mpal2311 Active Member



  16. Umashankar

    Umashankar Member



  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


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

    7Capture.PNG
     


  18. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


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


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Thanks Pankaj....
     


  20. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


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


  21. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  22. 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..
     


  23. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


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


  24. 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
     


  25. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


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


Share This Page