Import BOM ( Bill Of Material) Item Master Excel to Tally.ERP9 Error , Please help me

Discussion in 'Tally Developer' started by MIttal Sharma, Jan 8, 2016.

    
?

Import BOM ( Bill Of Material) Item Master Excel to Tally.ERP9 Error , Please help me

  1. Please help Me

    0 vote(s)
    0.0%
  2. Please

    0 vote(s)
    0.0%
Multiple votes are allowed.
  1. MIttal Sharma

    MIttal Sharma New Member


    ;;Dear All,
    ;;Please help me for Importing Bill of Item Master Excel to Tally.ERP9
    ;;TDls code Given below

    [Collection: ExceltemMasterBOMCollection]
    ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=D:\BOM.xlsx"
    SQL : "Select * from [Sheet1$]"

    [Function: ImportFromExcelBOM]
    Variable : TotalEntries : Number
    Variable : Count : Number
    00 : Set : TotalEntries : $$NumItems:ExceltemMasterBOMCollection
    10 : Start Progress: ##TotalEntries : "Item Master BOM Creation" : "Importing Stock Item BOM in" : ##SVCurrentCompany
    20 : Walk Collection : ExceltemMasterBOMCollection
    30 : New Object : STOCKITEM
    40 : Set Value : Name : $_1
    50 : Set Target : ..
    60 : Set Value : BASEUNITS : $_2
    70 : Insert Collection Object:MULTICOMPONENTLIST ;;MultiComponentList
    80 : Set Value : COMPONENTLISTNAME : $_3
    90 : Set Value : COMPONENTBASICQTY : $_4
    100 : Walk Collection : ItemMultiBillOfMaterialsItems;;BoMItemComponentList
    110 : Insert Collection Object :ItemMultiBillOfMaterialsItems;;MultiComponentItemList;; ;;MultiComponentItemListNames
    120 : Set Value : NATUREOFITEM : $_5
    130 : Set Value : STOCKITEMNAME : $_6
    140 : Set Value : ACTUALQTY : $_7
    150 : Set Target : ..
    160 : Set Object Values
    330 : Create Target
    340 : Show Progress : ##Count
    350 : Increment : Count
    360 : End Walk
    370 : End Progress
    380 : Msg Box : "Status" : "Item BOM Import Successfully"

    [#Menu: Gateway of Tally]

    Add : Item : Before : @@locQuit : "Import BOM" : Call : ImportFromExcelBOM
     

    Attached Files:

    zakirhossain_diu likes this.


  2. varun tarun kumar

    varun tarun kumar New Member



Share This Page