Explode not work

Discussion in 'Tally Developer' started by Jagdishkumar, Aug 14, 2020.

    
  1. Jagdishkumar

    Jagdishkumar New Member


    Dear Admin and experts

    i create a sub form and aggregate udf in sales entry and want to explode the details of sub form value to main screen but not able to do.
    so please help for how to explode the details.

    Thanks.
    Code.
    [System:UDF]
    SpandanMIItem :String :2001
    SpandanMIQty :Quantity :2001
    SpandanMINEntries :Aggregate :2000
    [#Field:VCHBATCH BilledQty]
    Option:Jagdish : @@ISSales OR @@ISCreditNote

    [!Field:Jagdish]
    Sub Form:SpandanMINEntryForm : NOT $$IsEmpty:#VCHBATCHBilledQty
    ;;=======================================
    ;; material use entry through sub form
    ;;=======================================
    [Report:SpandanMINEntryForm]
    Form :SpandanMINEntryForm
    Object :Voucher
    ; Object :Company

    [Form:SpandanMINEntryForm]
    Height : 50% Screen
    Width : 50% Screen
    Horizontal Align: Left
    Vertical Align : Bottom
    Part:SpandanMINTitle,SpandanMINDetails
    [Part:SpandanMINTitle]
    Line:SpandanMINTitle
    [Line:SpandanMINTitle]
    Field:Name Field
    Local:Field:Name Field:Info :"Material Use"
    Local:Field:Name Field:Align :Centre
    Local:Field:Name Field:Full Width :Yes
    Space Bottom:.5
    [Part:SpandanMINDetails]
    Line :SpandanMINDetailsTitle,SpandanMINDetails
    Repeat :SpandanMINDetails:SpandanMINEntries
    Vertical :Yes
    Scroll :Vertical
    Common Border :Yes
    BreakOn :$$IsEnd:#SpandanMIItem

    [Line:SpandanMINDetailsTitle]
    Field :SpandanMISlNoTitle,SpandanMIItemTitle
    Right Field :SpandanMIQtyTitle
    Border :Thin Column Titles

    [Field:SpandanMISlNoTitle]
    Use :Simple Field
    Set as :"Sl.No."
    Width :5

    [Field:SpandanMIItemTitle]
    Use :Name Field
    Info :$$LocaleString:"Material"
    Full Width :Yes
    Border :Thin Left
    Style :Normal
    Align :Centre
    [Field:SpandanMIQtyTitle]
    Use :Qty Title Field
    Info :$$LocaleString:"Qty"
    Border :Thin Left
    Style :Normal
    Align :Centre
    [Line:SpandanMINDetails]
    Fields:SpandanMISLNo,SpandanMIItem
    Right Field:SpandanMIQty
    [Field: SpandanMISLNo]
    Use :Number Field
    Set As :$$Line
    Width :5
    Skip :Yes

    [Field:SpandanMIItem]
    Use :Name Field
    Set Always :Yes
    Show Table :Always
    Table :List of Stock Items,End of List
    Storage :SpandanMIItem
    Full Width :Yes
    [Field:SpandanMIQty]
    Use :Qty Field
    Set Always :Yes
    Set as :$$AsQty:$SpandanMIQty
    Storage :SpandanMIQty
    Border :Thin Left
    Inactive :$$IsEnd:$SpandanMIItem
    ;;===========================================
    ;; Explode material use details
    ;;===========================================
    [#Line: EI InvInfo]
    Explode:EILineExplode:NOT $$Isempty:#VCHStockItem
    [Part:EILineExplode]
    Line :EILineScreenExplode
    Repeat :EILineScreenExplode:SpandanMINEntries
    Scroll :Vertical
    Vertical:Yes
    Break On:$$IsEmpty:$SpandanMIItem

    [Line:EILineScreenExplode]
    Field:EILineScreenExplodeItem,EILineScreenExplodeQty
    [Field:EILineScreenExplodeItem]
    Use :Name Field
    Set Always :Yes
    Set as :$SpandanMIItem
    Background :Red

    [Field:EILineScreenExplodeQty]
    Use :Qty Field
    Set Always :Yes
    Set as :$SpandanMIQty
    Background :Red
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field:EILineScreenExplodeItem]
    Use :Name Field
    Set Always :Yes
    Set as : "Hello this is the Value"
    Background :Red

    See, if the above is working and displaying..... means there is no problem with the code.
    It is not working, because the value has not been saved.
    You have made a sub-form in the Voucher....... means you have to use a Function to save the values before it is displayed.

    Please study the BasicUserDescription and how the value is being saved.......... same way you will have to do it.
     


  3. Jagdishkumar

    Jagdishkumar New Member


    sir logic is same and find the sub form of basicuserdescription but i cant find the basicuserdescription field.
    so please more guide about it.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    basicuserdescription is a UDF, not a field..... the Field name is "EI Desc".

    Am not good with functions and understand less so........ but to guide you..... look for FORM : Voucher
    in that, there are many ........On : Form Accept ............ Default Tally has a long lon TRAIN... i.e. functions within functions.......... You need to find the whole train and insert your value to be saved. This is my understanding.

    The Function for BasicUserDescription is ------ [Function : CopyUserDescription] ..... from here you need to backward trace the original CALL function.
     


  5. Vijay Shetye

    Vijay Shetye Member


    Dont add new field at explode level

    Use the same field that you have used at subform level the value will be fetched

    if you have add a new field at explode level with set as the method name

    the exploded part will work after you save the entry and reopen and check

    In case you need any else you ping us
     


  6. Jagdishkumar

    Jagdishkumar New Member



  7. Rohit Khedar

    Rohit Khedar Member


    Hi please post new code if your problem is fixed
     


Share This Page