Hi Friends, Kindly find the attached Folder for Stock Item Master Import. Here i'm attaching the TDL's for Stock Item Import from Excel to Tally. and also create a Stock Item Master template also. In this TDL we import all fields of stock item.... Ur's D NaraSimhulu
very usefully tdl . But Two Colum add in xls file (1) Sale Percentage % (2) Vat Percentage % . User use include vat tax (sale % 95.24 + vat % 4.76 )
Hi. Seems to be what I am hunting for. But whenever I load all the TDLs I get "Error T0009: duplicate description name Report - SL Stock Import & in second line " is previous declaration". Please tell what wrong am I doing. Regards, Atul
That means , you have loaded the TDL Two times otherwise you have used Report Name already used in Tally. Pls check.
Thanx Mr. Nagarajkmar, When I load just one TDL the error disappears. But I can't find any menu item in tally added to import data. Honestly speaking I am new to this. Please guide how to use this StockItem.zip. You can even mail me at atulg7@yahoo.com Thanx.
i want import stock item along with alternet unit plz help me when i use this code i get error msg conversions factor from base to alt unit excel file Item Name Group Units size width altunit ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara [Report: TSPL Smp SIC Error Report] Form : TSPL Smp SIC Error Report Title : "Import Status" [Form: TSPL Smp SIC Error Report] Parts : Form Subtitle, TSPL Smp SIC Error Report Local : Field : Form SubTitle : Info : "Status of Stock Item import" [Part: TSPL Smp SIC Error Report] Lines : TSPL Smp SIC Error Title, TSPL Smp SIC Error Details Repeat : TSPL Smp SIC Error Details : TSPL SMP SIC LOGVarColl Summ Scroll : Vertical Common Border : Yes [Line: TSPL Smp SIC Error Title] Use : TSPL Smp SIC Error Details Local: Field: Default : Style : Normal Bold Local: Field: Default : Align : Centre Local: Field: TSPL Smp SIC Error Item : Set As : "Particulars" Local: Field: TSPL Smp SIC Error Status : Set As : "Status" Border : Thin Top Bottom [Line: TSPL Smp SIC Error Details] Fields : TSPL Smp SIC Error Item Right Fields: TSPL Smp SIC Error Status Option : TSPL Smp SIC Success : $SICStatus CONTAINS "Imported Successfully" OR $SICStatus CONTAINS "Item already exists" [!Line: TSPL Smp SIC Success] Local : Field : Default : Style : Normal Italic [Field: TSPL Smp SIC Error Item] Use : Name Field Set As : $SICStockItem FullWidth : Yes [Field: TSPL Smp SIC Error Status] Use : Name Field Set As : $SICStatus Border : Thin Left Width : 50% Page [Collection: TSPL SMP SIC LOGVarColl] Data Source : Variable : Item Import Status [Collection: TSPL SMP SIC LOGVarColl Summ] Source Collection : TSPL SMP SIC LOGVarColl By : SICStockItem : $ItemName By : SICStatus : $Status Keep Source : (). Filter : TSPL SMP NonEmpty Item Client Only : Yes ;; End-of-File ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; master item level [#Form: Stock Item] Delete:Full Height:No Add:Height:100% Page [#Form: MSTSimpleOutput] Delete:Full Height:No Add:Height:100% Page [#Part: STKI Basic] Deleteart : MST Basic Addart : Viva Item Name, MST Basic New Viva Vertical:Yes Border : Full Thin Bottom : ##UseStockDescription OR ##UseStockItemNarr OR ##UseDefaultLedgers Option : STKIWithPartNos : ##MSTHasPartNos OR ##UsePartNumbers Space Right : 0.25 [Part:MST Basic New Viva] Use:MST Basic Local:Field:Mst name:Skip:Yes [#Part: STKIWithPartNos] Right Parts : STKI PartNos Vertical : Yes [Part:Viva Item NAme] Line: Viva Item Name [Line: Viva Item Name] Space Bottom:2 mms Field:Medium Prompt, VVItem ,Short Prompt,width,Long Prompt,lenth,size,comboname Local:Field:Medium Prompt: Set as:"Item Name" Local : Field : Short Prompt : Info : $$LocaleString:"Width" Local : Field : Short Prompt : Width : @@ShortNameWidth Local : Field : long Prompt : Info : $$LocaleString:"Length" Local : Field : long Prompt : Width : @@ShortNameWidth [Field: VV Item] Use:Name Field Storage: VVItem Set Always:Yes Width:50 mms Style:Normal Align:Left [Field: Comboname] Use:Name Field Storage:Comboname Set as:$VVItem+" "+$$String:$VivaSize Set Always:Yes Width:80 mms Style:Normal Bold Align:Left On: Accept: Yes: Call: TestFunction1:$$Value:$Masterid On: Accept: Yes: Field Accept Skip:not $$IsCmpOwner and $$InAlterMode [Function: Test Function1] Parameter: TestVar : String Parameter: Mastervar : Number Variable: NewVar : String 10 : Set: NewVar :"ID:"+$$String:##Mastervar 11 : Set TargetStockitem,##NewVar). 12 : Set Value:name:##TestVar 13 : Save Variable 14 :Return [Field: Size] Use : short name field Width : 25 mms Max : @@MaxSymWidth Storage:VivaSize Set as :$$String:$vivaWidth+"x"+$$String:$vivaLength Set Always:Yes Invisible:Yes [Field: width] Use : number field Width :15 mms Max : @@MaxSymWidth Storage:vivaWidth Align:Centre [Field: lenth] Use : number field Width :15 mms Max : @@MaxSymWidth Align:Centre Storage:vivalength [System:UDF] vivalength :Number :1017 Vivawidth :Number :1018 vivasize :String :1019
Dear Sir, I tried this tdl but whenever I load all the TDLs I get "Error T0009: duplicate description name Report - SL Stock Import & in second line " is previous declaration". can't find any menu item in tally added to import data. Can you please help me in this ...
Dear Sir, I have used your code sir for Import Stock Master. I need only import Stock Item name, Stock Group Name and Units I have changed code sir. but it's not working kindly help me sir. I have enclosed code and Stock Item also sir. Thanks Anbhu.
Dear Sir, Thank you very much for your Support. Sir, Still im facing same issue sir, Kindly help me sir. i have enclose issue scree shot. Thanks, Anbhu.
HI NARASIMHULU help in this accouting allocation problem [#Part : DBL Line Narration] Add:Line : Po Genrate Line [Line : Po Genrate Line] Field : Long Prompt,Po Genrate Fld Local : Field : Long Prompt : Info : "Generate Purchase Order ?" Local : Field : Long Prompt : Color : Red Local : Field : Long Prompt : Style : Normal Italic Invisible : (NOT @@IsSales) [Field : Po Genrate Fld] Use : Logical Field Storage : GenAutoPo SubForm : POSubForm : $$Value ;;Skip : $$InCreateMode [System : Udf] GenAutoPo : Logical : 1176 [Report : POSubForm] Form : POSubForm [Form : POSubForm] Space Top : 3% Page Space Bottom : 3% Page Space Right : 2% Page Space Left : 2% Page Height : 70% Page Width : 70% Page Horizontal Align : Center BackGround : White Part : PodetailPart On : Form Accept : Yes : Form Accept On : Form Accept : Yes : CALL : AutoPOCreate [Part : PodetailPart] Line : FormSubtitle,PodetailPart Local : Field : FormSubtitle : Info :"PO Details" [Line : PodetailPart] Field :mediumprompt;,cstnamefield Right Field : Short Prompt,PODateFld Local : Field : Short Prompt : Set as :"PO.Date :" [Field : PODateFld] Use : Short Date Field Storage : Date Set as : $Date [Function: AutoPOCreate] ;; Definition Block Variable : Counter : Number FETCH OBJECT : Voucher : ($$SPrintF@VCHMasterID:##pVchId) : InventoryEntries.*, LedgerEntries.* ;; Procedural Block 00 : SET FILE LOG ON 01 : SET : SVViewName : $$SysName:InvVchView 02 : QUERYBOX : "Create Purchase Order ?":Yes:No 03 : IF : $$LastResult 04 : NEW OBJECT : VOUCHER 05 : SET VALUE : Date : $Date ;; ##InputDate1 06 : SET VALUE : Reference : $VoucherNumber 660 : SET VALUE : PartyLedgerName : $PartyLedgerName ;;711 : SET VALUE : Is Deemed Positive : "yes" ;;12 : Set Value : ISPARTYLEDGER : Yes 07 : SET VALUE : VoucherTypeName : "Purchase Order" 08 : SET Value : IsInvoice : Yes ; 19e : WALK Collection : PartyAddress ; 19g : INSERT COLLECTION OBJECT : Address ; 19i : SET VALUE : Address : $Address ; 19j : Set Target : .. ; 19k : End Walk 09 : INSERT COLLECTION OBJECT : Ledger Entries 10 : SET VALUE : LedgerName : $LedgerName 710 : SET VALUE : Is Deemed Positive : "yes" ;;12 : Set Value : ISPARTYLEDGER : Yes 120 : SET VALUE : Amount : $Amount;*-1 140 : SET TARGET : .. 700 : SET : Counter : 1 810 : WALK COLLECTION : All Inventory Entries 150 : INSERT COLLECTION OBJECT : INVENTORY ENTRIES 320 : IF : ##Counter = 1 430 : SET TARGET : All Inventory Entries ;;[1] 340 : ELSE: 350 : INSERT COLLECTION OBJECT : All Inventory Entries 360 : ENDIF 160 : SET VALUE : StockItemName : $StockItemName 170 : SET VALUE : IsDeemedPositive : No ;;171 : SET VALUE : ActualQty : ($$TgtObject$$AsQty:"100")) * -1 175 : SET VALUE : ActualQty : $ActualQty;$$TgtObject:$BilledQty 177 : SET VALUE : BilledQty : $billedqty;$$AsQty:"10" ;;$$TgtObject:$$Number:$BilledQty ;;($$TgtObject$$AsQty:"100")) * -1 ;;173 : SET VALUE : Rate : ($$TgtObject$$AsRate:$Rate)) 180 : SET VALUE : Amount : $Amount 190 : INSERT COLLECTION OBJECT : BATCH ALLOCATIONS 200 : SET TARGET : BatchAllocations ;; [1] 201 : SET VALUE : OrderDueDate : $$DateRange:"10 Days"$$TgtObject:$Date):True 210 : SET VALUE : GodownName : $GodownName ;; "Main Location" 220 : SET VALUE : BatchName : $BatchName ;; "Test" 230 : SET VALUE : OrderNo : $OrderNo ;; "Test" 240 : SET VALUE : ActualQty : $$TgtObject:$actualqty ;;($$TgtObject$$AsQty:"100")) * -1 255 : SET VALUE : BilledQty : $$TgtObject:$BilledQty ;;($$TgtObject$$AsQty:"100")) * -1 ;;260 : SET VALUE : Rate : ($$TgtObject$$AsRate:$Rate)) ;110 : Set Value: LedgerName : "Purchase @ 14.5%" 270 : SET VALUE : Amount : $Amount ;; ($$TgtObject$$AsAmount:$Amount)) 280 : SET TARGET : ... ;258 : Walk Collection:ALL LEDGER ENTRIES 19 : INSERT COLLECTION OBJECT :LEDGER ENTRIES 109 : SET TARGET :LEDGER ENTRIES 110 : Set Value: LedgerName : "Purchase @ 14.5%" 111 : Set Value : Is Deemed Positive :"No" ;"" 249a: SET VALUE : ISLASTDEEMEDPOSITIVE : No 254 : SET VALUE : TAXCLASSIFICATIONNAME : $$SysName:NotApplicable ;;112 : Set Value : ISPARTYLEDGER : No 113 : Set Value : Amount : $Amount 114 : Set Target:..... ;115: End Walk 330 : INCREMENT : Counter 33 : End Walk ; 18 : WALK COLLECTION : All ledger Entries ; 19 : INSERT COLLECTION OBJECT : LEDGERENTRIES ; 109 : SET TARGET : LEDGERENTRIES ; 110 : SET VALUE : LedgerName : "Purchase @ 14.5%" ; 111 : SET VALUE : Is Deemed Positive : "No" ; ;;112 : Set Value : ISPARTYLEDGER : No ; 113 : SET VALUE : Amount : $Amount ; 117 : SET TARGET : ... ; 118 : End Walk ; 13 : INSERT COLLECTION OBJECT : BillAllocations ; 14 : SET VALUE : BillType : $$SysName:NewRef ; 15 : SET VALUE : Name : $VoucherNumber ; 16 : SET VALUE : Amount : $Amount ; 17 : SET TARGET : .. ; 19 : INSERT COLLECTION OBJECT : Accounting Allocations ; 110 : SET VALUE : LedgerName : "PURCHASE" ; 111 : SET VALUE : Is Deemed Positive : "No" ; ;;112 : Set Value : ISPARTYLEDGER : No ; 113 : SET VALUE : Amount : $Amount ; 117 : SET TARGET : ... 34 : SET VALUE : PersistedView : ##SVViewName 35 : CREATE TARGET 36 : ENDIF 37 : Return ;; END [#Field:EIACCALLOCNAME] [#Field:vchbatchactualqty]