Import purchase from excel!!

Discussion in 'Free Source Codes' started by zakirhossain_diu, Sep 2, 2018.

         

  1. 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????
    upload_2018-9-2_1-32-57.png
     


  2. maulik khatri

    maulik khatri New Member


    SHARE FULL CODE WILL HELP YOU
     


  3. knsivam89

    knsivam89 Active Member


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


  4. karthik loganadin

    karthik loganadin New Member


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


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try......

    670 : SET VALUE : BATCHRATE : $$FileReadCell:##RowIndex:8
     


Share This Page