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
[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.
sir logic is same and find the sub form of basicuserdescription but i cant find the basicuserdescription field. so please more guide about it.
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.
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