Import purchase from excel!!

Dear Sir
I need to understand, while we are importing data from excel with item how can we set repeat for repeted item on single invoice. below are the inventory part of my full codes.
How to insert multiple item on single invoice while importing from excel??
260 : Insert Collection Object : ALLINVENTORYENTRIES

261 : Set : myitemName : $myItemName
262 : Set : myBillQty : $myBilledQty
270 : SET VALUE : STOCKITEMNAME : $$TgtObject$$String:##myitemName)
280 : SET VALUE : ISDEEMEDPOSITIVE : Yes
281 : SET VALUE : ACTUALQTY : $$TgtObject$$AsQty:##myBillQty)

when excel data Table is like below????

 

SHARE FULL CODE WILL HELP YOU

 

You r using ODBC Concept. Use File read concept, you can do easily this. Sample code Tally.Developer9.

 

Dear Nallsivam,

I am in middle of importin item invoice. Could you help me fix the following code. Am getting action execution failed error at line 670. i tried multiple ways but ended in vain. please help.


620 : INSERT COLLECTION OBJECT : ALLINVENTORYENTRIES
630 : SET VALUE : STOCKITEMNAME : $$FileReadCell:##RowIndex:6
640 : SET VALUE : ISDEEMEDPOSITIVE : "No"
650 : SET VALUE : ACTUALQTY :$$FileReadCell:##RowIndex:9
660 : SET VALUE : BILLEDQTY :$$FileReadCell:##RowIndex:9
670 : SET VALUE : RATE : $$FileReadCell:##RowIndex:8
680 : SET VALUE : Amount : $$AsAmount:$$FileReadCell:##RowIndex:11

690 : INSERT COLLECTION OBJECT : BATCH ALLOCATIONS
700 : SET VALUE : GODOWNNAME : "Main Location"
710 : SET VALUE : BatchName : "Primary Batch"
720 : SET VALUE : Amount : $$AsAmount:$$FileReadCell:##RowIndex:11
730 : SET VALUE : ActualQty :$$FileReadCell:##RowIndex:9
740 : SET VALUE : BilledQty :$$FileReadCell:##RowIndex:9
750 : SET TARGET : ..

760 : Insert Collection Object : ACCOUNTINGALLOCATIONS
770 : SET VALUE : LedgerName : "Sales Account"
780 : SET VALUE : Amount : $$AsAmount:$$FileReadCell:##RowIndex:11
790 : SET VALUE : ISDEEMEDPOSITIVE : "No"
800 : SET VALUE : ISLASTDEEMEDPOSITIVE : "No"
820 : SET TARGET : ..

830:SET TARGET : ..