Can Anybody help ?

Discussion in 'Requests' started by Raj_ap_2016, Oct 18, 2016.

         
  1. Raj_ap_2016

    Raj_ap_2016 New Member


    Iam unable to import Stock Journal from Excel to Tally getting Error at #140, Please help me out.

    Thanks

    [Report: JnrlImportVchrs]

    Title : $$LocaleString:"Journal Import from Excel"

    [Form: JnrlImportVchrs]

    Part : VCHFilepathEnter
    On : Form Accept : Yes : Form Accept
    On : Form Accept : Yes : Call : VCHReadfromExcel
    On : Form Accept : Yes : Call : Create StkJournal
    Back Ground : Pale Orange
    Option : Small Size Form : NOT $$InPrintMode
    Width : 60 % Page
    Space Left : 1
    Space Right : 1



    [Function : Create StkJournal]

    Variable : RateOfStockItem : Amount
    Variable : QtyOfStockItem : String
    Variable : ValueOfStockItem : Amount

    10 : Set : QtyOfStockItem : $Column2
    20 : Set : RateOfStockItem : $Column3
    30 : Set : ValueOfStockItem : $Column4

    40 : New Object : Voucher
    50 : Set Value : VoucherTypeName : $$VchTypeStockJrnl
    60 : Set Value : Date : $$MachineDate
    70 : Set Value : PersistedView : "Voucher View"

    80 : WALK COLLECTION : VCHExcell Collections

    90 : Insert Collection Object : InventoryEntriesIn
    100 : SET VALUE : StockItemName : $Column1
    110 : SET VALUE : IsDeemedPositive : "Yes"
    120 : SET VALUE : Rate : $$AsAmount:$Column3 ;;##RateOfStockItem
    130 : SET VALUE : Amount : $$AsAmount:$Column4 ;;##ValueOfStockItem
    140 : SET VALUE : ActualQty : -$$TgtObject:($$AsQty:$Column3) ;;##QtyOfStockItem)
    150 : SET VALUE : BilledQty : -$$TgtObject:($$AsQty:$Column3) ;;##QtyOfStockItem)

    160 : Insert Collection Object : BatchAllocations
    170 : Set Value : Amount : $$AsAmount:$Column4 ;;##ValueOfStockItem
    180 : Set Value : ActualQty : -$$TgtObject:($$AsQty:##QtyOfStockItem)
    190 : Set Value : BilledQty : -$$TgtObject:($$AsQty:##QtyOfStockItem)
    200 : Set Value : Rate : $$AsAmount:$Column3 ;;##RateOfStockItem
    210 : End Walk
    220 : Set Target : ..

    230 : Create Target
     

    Attached Files:




  2. Raj_ap_2016

    Raj_ap_2016 New Member


    Experts & Admin,

    Why is it so when we ask for help no body response, and if somebody ask for TDL every body say you give us your coding and we are there to help you out.

    please any body give idea how to go about or what wrong in my TDL

    Thanks
     



  3. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Try like this

    Local Formula : MyQty : ($$Number:$Column3)

    140: Set value :Actualqty: $$Tgtobject:(($$Asqty:mad:Myqty)*-1)
     



  4. BHARATKHABAR

    BHARATKHABAR New Member


    dear sir

    how units are set in this .
     



Share This Page