string that contains Items Included in bill

Discussion in 'Tally Developer' started by Properson2020, Oct 11, 2020.

    
  1. Properson2020

    Properson2020 New Member


    I want a string that contains

    item + qty + amt

    item1 10pcs 10000 item2 5pcs 500

    and as go on
    for the all item included in bill
     


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Create System Formula that Will Calculate Qty and Amount
    Example:
    [System:Formula]
    Qty:$ActualQty
    Amt:$Amount

    Create a field that will show the value and convert everything in String
    Example:
    [Field:Example]
    Set as: $$String:$StockItemName + $$String:mad:@Qty + $$String:mad:@Amt
     


  3. Properson2020

    Properson2020 New Member


    I try but Not working please help me how can i use feild in string
    here is code I used

    [#Form: Sales Color]
    Add : Button : WhatsApp
    On : Form Accept: @@IsSales : CALL : onformaccept

    [Button: WhatsApp]
    Option : SalesjayA : $VoucherTypeName="Sales"

    [!Button: SalesjayA]
    Key : Alt + W
    Action : Browse URL : "whatsapp://send?Phone=" + @@mobileno+ +"&text=" + @@List


    [System: Formula]

    Qty:$ActualQty
    Amt:$Amount

    [Field:List]
    Set as: $$String:$StockItemName + $$String:mad:@Qty + $$String:mad:@Amt

    [Function:eek:nformaccept]
    10 : QUERYBOX : "Send Whatsapp msg" : Yes:No
    20 : IF : $$LastResult
    30 : CALL : whatsappstring
    40 : ENDIF

    [Function: whatsappstring]
    00 : Browse URL : "whatsapp://send?Phone=" + @@mobileno+ +"&text=" + @@List
     


  4. Himanshu-2002

    Himanshu-2002 Active Member


    It will not work because I gave you example not solution...You have to learn from example
     


  5. Properson2020

    Properson2020 New Member


    I don't want to display field I want collection of all StockItemName in string
    how can I do that ?
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make a Collection of all StockItem......... there are ample examples of such Collections in Developer.

    Then in your FIELD .... use $$FullList:CollectionName:$UDF to get the data in a single line.
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There are 28 StockItems.....All Items are in a Single line.



    Capture.PNG

    Capture2.PNG
     


  8. Properson2020

    Properson2020 New Member


    Sir, I tried but I didn't understand. sir can you explain in brief please sir
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Have already explained in BRIEF.......

    It is a simple collection of StockItems.......and then you need to use the Function $$FullList...........
     


Share This Page