Problem in Item Master Import

Discussion in 'Tally Developer' started by Ranjit Ambare, Jul 13, 2018.

    
  1. Ranjit Ambare

    Ranjit Ambare New Member


    I wrote code for stock item master import from excel, While i'd tried to import opening balance(qty) and opening rate, Then execution gets failed, Here is my code,

    252: Insert Collection Object: BatchAllocations
    253: Set Value:GodownName:##RSSPlant1
    251: Set Value:OpeningBalance:$$AsQty:##RSSQuantity1
    254: Set Value:OpeningRate:$$AsRate:##RSSPrice1
    325 : Set Target : ..

    Please suggest me the right code.

    Thank you.
     


  2. Johar

    Johar Member


    1561 : WALK COLLECTION : Batch Allocations
    ; 1581 : INSERT COLLECTION OBJECT : Batch Allocations
    ; 1600 : SET VALUE : GodownName : "Main Location"
    ; 1601 : SET VALUE : BatchName : "Primary Batch"
    ; 1602 : SET VALUE : OpeningBalance : $OpeningBalance
    ; ;1608 : SET VALUE : OpeningRate : $OpeningRate
    ; 1603 : SET VALUE : OpeningValue : $OpeningValue
    ; 1605 : SET TARGET : ..
    ; 1609 : END WALK

    Try with Batch Name
     


  3. Ranjit Ambare

    Ranjit Ambare New Member


    @Johar Sir..... Its not working yet
     



  4. u want item import?
     


  5. Ranjit Ambare

    Ranjit Ambare New Member


    Yes...Its done
     


  6. Ranjit Ambare

    Ranjit Ambare New Member


    Is it possible to import value in UDF?
     



  7. yah possible u want that
     


  8. Ranjit Ambare

    Ranjit Ambare New Member


    yes...i want to import excel value in my udf at stock item master.
    How Can i do it?
     



  9. sir if u want i can give u full code of stock import with hsn code taxable rate n opening bal import

    bt it will chargable
     


  10. Johar

    Johar Member


    by using below mentioned code you can from Excel column Number

    0370 : Set : VRate : $Column6
    0380 : Set : VQty : $Column5
     


  11. Ranjit Ambare

    Ranjit Ambare New Member


    ok...sir
    Thank you:)
     


Share This Page