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
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
Since we are giving Action as New Object. 410 : NEW OBJECT : Stock Item What can i change to Alter if already existed ? Thank you
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: $$SysNamerimary
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...