Help in Totalling and Filter

Discussion in 'Tally & TDL Learning HUB' started by Marina Colors, Feb 17, 2022.

    
Tags:
  1. Marina Colors

    Marina Colors Member


    Dear Amit Kamdar Sir...

    Please assist me in fine tuning the TDL for summing up Purchases and Material returns (Credit Note) and also Filtering Stock itemwise...

    Thanks
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Not sure i have relevant data to check out. submit dummy Tally data.

    Also please make screenshots and explain what you need and trying to get. You need to implant your ideas in others mind to enable us to understand correctly.

    Will take a little time, as it is travel time, till end of month, so have patience.
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    from code your collection is of SALES Vouchers and you are trying to compute the values of Purchase n CN. So how is it gonna work when the collection does not have any data of Purchase and CN ???

    This is another copy-paste project ...... so one cannot understand or learn from such activities. Instead you must understand the logic and structure of the coding language, so you can learn faster an better.
     


  4. Marina Colors

    Marina Colors Member


    Sir...Yes I do agree ...it is copy paste but...not fully...as I dont know the "Default fields" in Tally, need to search and understand the fields...will understand step by step by doing my required report TDL creation...

    Pls find attached, the screen shot and i want to have the Purchase Qty + Returned Qty...which will equate the Closing Stock on that date.
    Also i would like to have the Item Selection for a particular item.

    Please assist.

    Thanks
     

    Attached Files:



  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    That is good attitude to learn and develop, step by step. Good luck.

    Regarding your query for Pur+CN, i have already given you the solution, you need to make another collection for Purchase voucher and Credit note, then compute the values and CALL for the same in your main collection.
     


  6. Marina Colors

    Marina Colors Member


    Thanks Sir...
    will try...
     


  7. Marina Colors

    Marina Colors Member


    Sir...Can you share the name of Default Fields of Purchase and CNs?...pls ...is it $IsPurchase or other?....
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You do not need the FIELD ........

    You already have a existing collection of SALES Vouchers......... similarly make another collection of Purchase vouchers by changing the type in the collection.
     


  9. Marina Colors

    Marina Colors Member


    ok sir...thanks
     


Share This Page