Need help regarding the List Variable

Discussion in 'Free Source Codes' started by MarutiKalekar, May 17, 2019.

    
  1. MarutiKalekar

    MarutiKalekar Member


    Here is my code, and receiving an error variable could not found, Please help me

    ;************* Function *****************
    [Function:ExcelImportutiltySales]
    Parameter:SelectExFilePath:String
    Variable: ItemRwCtr: Number: 1

    01 : Open File:##SelectExFilePath:Excel:Read
    01a : LIST ADD EX: UtiImportExcelData
    04 : While:($$FileReadCell:##ItemRwCtr:2)<>""

    81 : LIST ADD EX: UtiImportExcelData

    82 : SET: UtiImportExcelData[##ItemRwCtr].UtiGSTHeroTpyeNew : "B2B"
    83 : SET: UtiImportExcelData[##ItemRwCtr].UtiEIPartyGSTIN : $$FileReadCell:##ItemRwCtr:3
    84 : SET: UtiImportExcelData[##ItemRwCtr].UtiDate : $$FileReadCell:##ItemRwCtr:6
    85 : SET: UtiImportExcelData[##ItemRwCtr].UtiVoucherNumber : $$FileReadCell:##ItemRwCtr:5
    86 : SET: UtiImportExcelData[##ItemRwCtr].UtiGSTHeroIgstNew : $$FileReadCell:##ItemRwCtr:17
    87 : SET: UtiImportExcelData[##ItemRwCtr].UtiGSTHeroCgstNew : $$FileReadCell:##ItemRwCtr:15
    88 : SET: UtiImportExcelData[##ItemRwCtr].UtiGSTHeroSgstNew : $$FileReadCell:##ItemRwCtr:16
    89 : SET: UtiImportExcelData[##ItemRwCtr].UtiAssblVal : $$FileReadCell:##ItemRwCtr:13
    90 : SET: UtiImportExcelData[##ItemRwCtr].UtiInvTotValue1 : $$FileReadCell:##ItemRwCtr:7
    91 : SET: UtiImportExcelData[##ItemRwCtr].UtiGSTHeroCessNew : $$FileReadCell:##ItemRwCtr:14


    98: Increment :ItemRwCtr

    100: End While

    ;**************** List variable ********************
    [System: Variable]
    List Variable: UtiImportExcelData

    [Variable: UtiImportExcelData]
    Variable: UtiGSTHeroTpyeNew : String
    Variable: UtiEIPartyGSTIN : String
    Variable: UtiDate : String
    Variable: UtiVoucherNumber : String
    Variable: UtiGSTHeroIgstNew : Number
    Variable: UtiGSTHeroCgstNew : Number
    Variable: UtiGSTHeroSgstNew : Number
    Variable: UtiGSTHeroCessNew : Number
    Variable: UtiAssblVal : Number
    Variable: UtiInvTotValue1 : Number
    Persistent : Yes
     
    Last edited: May 17, 2019


Share This Page