Tally Support also Failed to solve the Query

Discussion in 'Free Source Codes' started by Rishi kumar, Sep 6, 2023.

  1. Rishi kumar

    Rishi kumar Member

    Dear Sir,.

    I have created a Sales Order Report with all details of Sales Order .In this sales order Report one Column is Sales Voh no. and another is Billed Qty .
    I used SearchKey for getting Sales Vch No . Its work Fine no problem.

    The code and collection I have used for this is below.

    [Field:Cust ProInvNo]
    Use: Name Field
    Set as:$$ReportObject:$$CollectionFieldByKey:$vouchernumber:#CustProOrderNo:test
    Width: 10

    Child Of:$$VchTypeSales
    Belongs To:yes
    Search Key:$BasicPurchaseOrderNo

    Problem is when i used same method for getting the stock item qty that is billed then this is not working
    may any solve this problem?
    Screen shot of report is attached . In blue field i want sales item qty.

    thanks & Regards

    Attached Files:

  2. Hems

    Hems Member

    Fetch : *.*

    करने से सभी fetch हो जाते है
    ये भी कर के देख लीजिए

    शायद काम कर जाए

  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member

    Kindly stop OPENING a new Thread for each and every query.

    All your issues are regarding the SalesOrder --- so you must continue your subsequent queries in the same thread. It will be easier for others to have a proper LINE and grasp of the subject.

    कृपया प्रत्येक प्रश्न के लिए एक नया थ्रेड खोलना बंद करें।

    आपके सभी मुद्दे सेल्सऑर्डर के संबंध में हैं --- इसलिए आपको अपने बाद के प्रश्नों को उसी थ्रेड में जारी रखना चाहिए। दूसरों के लिए उचित लाइन और विषय पर पकड़ बनाना आसान होगा।

  4. Devendra_Rawat

    Devendra_Rawat Well-Known Member

    Add fetch : inventoryentries.* to your collection
    Remove search key
    then create new collection using first one as source

    In new collection

    walk : InventoryEntries
    Compute: BilledQty : $billedQty
    Compute: BasicPurchaseOrderNo :$$owner:$BasicPurchaseOrderNo

    SearchKey: $BasicPurchaseOrderNo

    Use search key here and us new collection in report

    Note: reply from mobile, there may be spelling errors

Share This Page