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????
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 : ..