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
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
Try like this Local Formula : MyQty : ($$Number:$Column3) 140: Set value :Actualqty: $$Tgtobject($$AsqtyMyqty)*-1)