Copy paste Item Description from Excel to tally

Discussion in 'Tally Developer' started by Rakesh Kumar, Feb 14, 2020.

    
  1. Rakesh Kumar

    Rakesh Kumar Member


    Dear All,

    Is there any way or source code that help us to copy paste or any other procedure to copy paste
    Item Description from Excel to Tally. Because description is very lengthy.
     


  2. Varun Reddy

    Varun Reddy New Member


    You can write a function to read the values from the excel and same thing you insert through function.
     


  3. Rakesh Kumar

    Rakesh Kumar Member


    Sir, please give me some more clue to do.
     


  4. Rakesh Kumar

    Rakesh Kumar Member


    Sir, I want to write all description in a row. Kindly help me in below code :-

    [#Form: Stock Item]

    Add : Part : After : STKI Desc : STKI Desc1
    Height : 100 % screen
    Width : 100 % screen

    [Part: STKI Desc1]

    Line : STKI Desc1
    Repeat : STKI Desc1 : Description1
    Break on : $$IsEmpty:$Description1
    Scroll : Vertical

    [Line: STKI Desc1]

    Field : Medium Prompt, STKI Desc1
    Local : Field : Medium Prompt : Set as : "Stock Description:"
    Local : Field : Medium Prompt : active : $$Line > 5

    [Field: STKI Desc1]

    Use : Name Field
    Storage : Description1

    [System: UDF]

    Description1 : String : 20001


    [#Part: EI DescExplosion]

    Set : $$NumItems:DescColl

    [Collection: Desc Coll]

    Type : Description1 : StockItem
    Child of : #VCHStockItem

    [#Field: EI Desc]

    Set as : $$CollectionField:$Description1:$$Line:DescColl
     


Share This Page