Purchase Register Include Debit Note also

Discussion in 'Free Source Codes' started by Bipin Damania, Jan 2, 2019.

    
  1. Bipin Damania

    Bipin Damania Active Member


    Hello Sir/Madam

    I want Purchase Register to Display Debit note also
    I tried this but not getting...

    [#Report: Purchase Register]
    Set : VoucherTypeName : ($$VchTypePurchase and $$VchTypeDebitNote)

    Please reply
     


  2. Bipin Damania

    Bipin Damania Active Member


    Hello Sir / Madam

    Please reply...
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use OR...instead of AND...........

    Also you need to combine the collection..............
     


  4. Bipin Damania

    Bipin Damania Active Member


    Tried with using OR
    but not getting

    will try again...

    Thanks
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Have u combined the collection??? You need to do that also.......... since you are working on the default report and not your own custom report.
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Won't work without the merged collection.............as simple as that............
     


  7. Rais Ahmed

    Rais Ahmed Member


    In UR report no need to put V.Type, Instead in collection put filter Filter : OnlyPurchaseDebitNote and make system formula . That's it
    Regards.
     



  8. Can u write a tdl for that in which purchase voucher & debit note is seen in Purchase Register at once ... it will be very helpful


    [#Report: Purchase Register]
    Filter : OnlyPurchaseDebitNote or $$IsPurchase:##SVVoucherType


     
    Last edited: Jan 13, 2019


  9. Rais Ahmed

    Rais Ahmed Member


    Are bhaji I told U, No need to write TDL Just put filter in Ur Collection as mention earlier it will show both. try and inform.
    Regards
     



  10. I am a new beginner plz guide by make a tdl for it or some pics ...


    [#Report: Purchase Register]
    Set : $$VchTypePurchase and $$VchTypeDebitNote
     


  11. Rais Ahmed

    Rais Ahmed Member


    Dear Experts,
    U might have solved Purchase and Debit note entry problem. But if not Out filter in collection and make system formula for that . EX. Filter : 123, system formula 123: $$ISPURCHASE:$VOUCHERTYPENAME OR $$ISDEBITNOTE:$VOUCHERTYPENAME.
    I have tried, working fine. But today one problem came and that is I want only IGST,CGST,SGST ledger entries and how to put such condition in these filter that I don't know If any one can suggest highly appreciated.
    Thanks n Regards
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code:
       
    IsGSTDutyLed                    : $IsVATDutyLedger:Ledger:$LedgerName AND $$IsSysNameEqual:GST:($TaxType:Ledger:$LedgerName)
     


Share This Page