How to find only debit entries only in Ledger Entries

Discussion in 'Free Source Codes' started by ABDUL AZIZ, May 28, 2019.

    
  1. ABDUL AZIZ

    ABDUL AZIZ Member


    Dear Experts,

    I have a collection of Payment and Journal Vouchers. But I want to include in my report all the Payment Vouchers because in payment party is always debited, but in case of Journal Voucher it is not sure whether a party ledger will be debited or credited. Thus I want to capture only debit entries of a Ledger Entries.

    Example:
    Dr. Abc Ltd Rs. 2000/-
    Dr. Boarding and Lodging Rs. 1000/-
    Cr. Travel Exp. Rs. 3000/-

    In this case party is being debited, So I want to capture this entry of Rs. Abc 2000/- only.
    If Abc Ltd is credited then I don't want it.

    Hope I am able to Explain my view...

    Thanks & Regards
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use $$IsDr.........

    You can check TDE and find how it has been applied..............
     
    ABDUL AZIZ likes this.


  3. ABDUL AZIZ

    ABDUL AZIZ Member


    Thanks a lot Sir,

    Done it!
     


  4. rony

    rony Member


    Dear Aziz,
    Can U explain How U have Done. Actually I M trying to fetch group detail like creditors,or exp or Duty ledgers but could not succeeded.
    Thanks
     


  5. ABDUL AZIZ

    ABDUL AZIZ Member


    What I could understand form your query is that you want to extract the ledgers under creditor and duty group. for that you can use formula like.. $parent contains creditor and so on.....

    if you need further help then share your code...
     


  6. rony

    rony Member


    Sir,
    I mean 2 say that if I M using journal voucher or Payment or receipt voucher entries . Only those entries which belongs to duty group or creditors group only can come and not the all.
    Thanks
     


Share This Page