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.
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
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
by using below mentioned code you can from Excel column Number 0370 : Set : VRate : $Column6 0380 : Set : VQty : $Column5