Stock Import Via Excel- TDL Code

Discussion in 'Tally Integration' started by admin, Apr 13, 2012.

    

  1. WHAT IS THIS BOX FOR ????? PLEASE SOLVE

    PIC FILE ATTACHED
     

    Attached Files:

    • GGG.jpg
      GGG.jpg
      File size:
      164.2 KB
      Views:
      116


  2. kosi

    kosi Member


    What is file IO
    Somebody help me understand
    Trying to import stock items and its not importing
    Any excel sheet.
    Please share because I try using my own excel sheet and not importing
    The import status report opens but no error message and stock is not importing
     


  3. Gehna

    Gehna New Member


    The suggestion you provide is not working, Can you please provide me the correct TDL file? Please
     


  4. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    There are many codes for Stock Item Import are available in this forum
     


  5. Gehna

    Gehna New Member


    Where? Please share link... to download TDL file.
     


  6. svn

    svn Member


    Sir,

    Please send the tdls for bellow excel sheet to srinu.mrk123@gmail.com

    Thanking you sir.
     

    Attached Files:




  7. Hello sir,

    How can we alter stock item details when Item is already created in Tally?

    Thank you
    Hello sir,

    How can we alter stock item details when Item is already created in Tally?

    Thank you
     


  8. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Yes, You can alter it
     
    zakirhossain_diu likes this.



  9. Since we are giving Action as New Object.

    410 : NEW OBJECT : Stock Item

    What can i change to Alter if already existed ?

    Thank you
     


  10. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Well,

    If want to alter every stock item that comes in excel sheet and which already exists in tally, Create your own form to alter the stock item name that exists, which will be loaded from the function, when the item exists.

    I can attach the code of the form that can alter the stock item details.





    First Modify Function give in the Post by administrator As Follows ,only relevant part is give here

    400 : IF : $$IsEmpty:$Name:StockItem:$SICStockItem
    410 : NEW OBJECT : Stock Item
    420 : SET VALUE : Name : $SICStockItem

    430 : IF : NOT $$IsEmpty:$Name:StockGroup:$SICStockGroup

    440 : SET VALUE : Parent : $SICStockGroup
    450 : ELSE:
    460 : SET : LastStatus: "Group " + $SICStockGroup + " does not exist"
    470 : ENDIF

    480 : IF : NOT $$IsEmpty:$Symbol:Unit:$SICStockUOM
    490 : SET VALUE : Base Units : $SICStockUOM
    500 : ELSE:
    510 : SET : LastStatus : "Unit " + $SICStockUOM + " does not exist"
    520 : ENDIF
    530 : IF : $$IsEmpty:##LastStatus
    540 : SAVE TARGET
    550 : SET : Last Status : "Imported Successfully"
    560 : ENDIF

    570 : ELSE
    571 : Alter : RbcVTopItem
    572 : END IF



    [Report: RbcVTopItem]
    Use: Stock Item
    Form: RbcVTopItem
    Full Screen: No

    [Form: RbcVTopItem]
    Use: Stock Item
    ; Width: 70 % Screen



    ; Horizontal Alignment: Right

    Local : Field : MST Name : Set as: $SICStockItem
    Local : Field : STKI Parent : Delete: Set as
    Local : Field : STKI Parent : Set as: $SICStockGroup
    Local : Field : STKI BaseUOM : Set as: $SICStockUOM
    Local : Field : STKI GSTApplicable : Set as: Yes
    Local : Field : STKI Category : Delete: Set as
    Local : Field : STKI Category : Add : Set as: $$SysName:primary
     
    zakirhossain_diu likes this.


  11. anish

    anish Member




  12. Th
    Thank you very much. Now I am trying to follow the same you had said. Thank you
     


  13. Neeru

    Neeru Active Member


    How i can connect with Tally from Excel to import..

    I create Excel from import All master and Entry from Excel but i am looking for connection to import in tally automatic...
     


  14. TCreat

    TCreat New Member


    give me a example for combine collection of voucher and bill wise allocations
     


Share This Page