How to fetch sales order details

Discussion in 'Free Source Codes' started by Rishi kumar, Aug 31, 2023.

    
  1. Rishi kumar

    Rishi kumar Member


    Sir,
    How to fetch sales order qty, sale oreder RATE. Sales order item ,

    Pls advice
    Regards
    Rishi
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make a Collection of SO Vouchers.
     


  3. Rishi kumar

    Rishi kumar Member


    Sir
    I have created some coll but no one is working.

    [Collection:salesordercoll]
    Type:vouchers:voucher type
    Childof: $$vchtypesalesorder
    Belongto:yes
    Fetch:stockitemname,RATE,billedqty

    [Collection:salesordercoll]
    Type:vouchers:voucher type
    Childof: $$issales order
    Belongto:yes
    Fetch:stockitemname,RATE,billedqty

    [Collection:salesordercoll]
    Type:vouchers
    Filter: issalesorder
    Fetch:stockitemname,RATE,billedqty

    [Systm:formula]
    Issalesorder: $$issalesorder: $vouchertypename

    Pls advice
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    That will work -- surely ---- BUT still it might not work ...... because if you need to call for SO values in a Report which has a collection of Ledgers or other vouchertype then you need use in-built function to fetch the values in your Report.

    Your query and prior queries are not sufficient for others to enumerate and present a Solution. So you are requested, that if you need to find a workable solution, present all the facts by putting up a structured and in-depth query as well as your code.
     


  5. Rishi kumar

    Rishi kumar Member


    Dear Sir,
    I am Creating a order and dispatch details Report. Dispatch Details retrieved very easily from sale Invoice but on exploded part where I have to show Sales order details ,
    when I Use method like StockItemName, Rate, BilledQty then displaying Sale Invoice Deatils whereas I want sales order details.
    I am pasting exploded part for your reference..

    [Part:Shipping order Status]
    Line: Shipping Order Explode Line
    Repeat:Shipping Order Explode Line: InventoryEntries

    [Line: Shipping Order Explode Line]
    Field : Cust ProMonth , Cust ProProduct , Cust ProPartyName , Cust PartyGroup ,Cust ProConsignee ,Cust ProDestination ;;6
    Right Field : Cust ProOrderNo , Cust ProOrderDate , Cust ProRate, Cust ProLength, Cust ProWidth ;;5
    Right Field : Cust ProThicknes , Custt ProOrdQty , Custt ProPending Size , Custt ProRemarks , Cust ProStatus,Cust ProDispQty, Cust ProInvNo ;;7
    Right Field: Cust ProDespdate , Custt ProShortEx , Custt ProFG ,Cust ProBalPro
    Border: Thin Bottom


    Local:Field:Cust ProProduct:setas: Need Sale order Stock Name
    Local:Field:Cust ProRate:setas: Need Sale Order Stk Rate
    Local:Field:Custt ProOrdQty :setas: Need Sale Order Qty
    Local:Field:Cust ProDispQty:setas: Easily get from Sale Invoice
    Local:Field:Cust ProInvNo:setas:Easily get from Sale Invoice
    Local:Field:Cust ProDespdate:setas:;; Easily get from Sale Invoice

    how can i get sale order details ?

    Remarks
    Rishi
     


  6. Hems

    Hems Member


    आप अपने वर्क की image भी पोस्ट कीजिये ताकि आसानी से पता चले कि आपके कोड से ये हो रहा हैं ।
    और आप ये चाहते है ।
     


  7. Rishi kumar

    Rishi kumar Member


    जब कुछ हो ही नहीं रहा है तो image किसकी डालू भाई
     


  8. Hems

    Hems Member


    तो जो चाहते हो उसकी इमेज डालो
    जैसे
    ये sale order ( image of sale order)
    इसकी ये ये detail

    इस रिपोर्ट ( image of आपकी रिपोर्ट) में इस तरह चाहता हूँ
     


  9. Rishi kumar

    Rishi kumar Member


    भाई मानलो एक sales order की रिपोर्ट है जिसमें हर sales order की details hai जैसे stock item , qty, RATE, तो तुम क्या collection बनाओगे ?
    मुझे sales order की पूरी जानकारी रिपोर्ट में चाहिए
    मुझे collection बनाने में दिक्कत आ रही है
     


  10. Hems

    Hems Member



  11. Rishi kumar

    Rishi kumar Member


    भा
    भाई बताने के लिए धन्यवाद
    मगर इसमें type: sales order यूज किया है इस नाम का कोई object नहीं है error बता रहा है
     


  12. Hems

    Hems Member



    Please see this

    आप भी अपनी problem से related word को पहले इस फोरम में सर्च करे फिर सारे मेंबर्स के कमेंट को देखे जिसमे से शायद आपकी समस्या का हल मिल जाये , फिर अपनी query को रिक्वेस्ट फॉर्म में पोस्ट कर । धन्यवाद ।
    IMG_20230902_180519.jpg
     


Share This Page