How to fetch subform field value to default field

Discussion in 'Free Source Codes' started by Jenny, Jul 28, 2023.

    
  1. Jenny

    Jenny Active Member


    I tried for that but if in 1st sub-form value updated with default field but
    if i entered 2nd stock item then its fetch 1st stock item value (Sub-form)

    How to fetch current stock item value ? please help me on this

    Code:
    [#Report:voucher]
        Variable:Lastsrno
        Set:Lastsrno:0
    
    [Function:checkqty]
        Parameter:pCheckQty:Number
        20:Return:##pCheckQty
    
    [#Field: VCHBATCH BilledQty]
        Delete:Switch
        Set as:$$AsQty:($$checkqty:(##lastsrno-1))
        Set always : yes
        Type : Quantity: forced   
    
    [Variable:lastsrno]
    Type:Number
    
    [System:Variable]
    lastsrno:0
     

    Attached Files:

    • 1.jpg
      1.jpg
      File size:
      209.6 KB
      Views:
      45
    • 2.jpg
      2.jpg
      File size:
      216.6 KB
      Views:
      45


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Collection: CurrentLineSr]
    Data Source : Report : Current
    Client Only : Yes

    in Set as : $$CollectionField:{your UDF or Variable}:1:CurrentLineSr
     


  3. Jenny

    Jenny Active Member


    Sir same result...as per first stock item entered that qty value fetch in 2nd item
     


  4. Jenny

    Jenny Active Member


    [Collection: CurrentLineSr]
    Data Source : Report : Current
    Client Only : Yes
    [#Field: VCHBATCH BilledQty]
    Delete:Switch
    Set as:$$CollectionField:(##Lastsrno-1):1:CurrentLineSr
    Set always : yes
    Type : Quantity: forced
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    remove -1
     


  6. Jenny

    Jenny Active Member


    If I remove -1 then on 1st stock item count line +1 and after 2nd item fetch value from 1st item
     


  7. Jenny

    Jenny Active Member


    Problem solved....
     


  8. Sanjeev S

    Sanjeev S Active Member


    Please close the thread with solution :)
     


  9. Jenny

    Jenny Active Member


    see solutions for Amit sir reply
     


Share This Page