Dear all Member, I want import production voucher from excel.I tried but cant get success.I cant understand what is wrong about this code. Sir please help me. Thank you all. Below is my code and excel file.
It shows error. FUNCTION:'Import of production voucher' LABLE :01:invalid numbers of steps FUNCTION:'Import of production voucher' LABLE :01:Action execution failed! FUNCTION:'Import production' LABLE :001:Action execution failed!
Invalid Number of Steps means 01 : START PROGRESS : ($$NumItemsroductionInfo) : "Vouchers Importing " : @@CmpMailName : "ProductionVCH Importing ..." Collection not gathered $$NumitemsroductionInfo=0 Check Bit Operating System Windows 32/64 Bit Tally 32 bit/64 Bit Ms Office 32 bit/64 bit OS + Tally + MS Office should be same bit 32 or 64
Sir in my system OS + Tally + MS Office all are same bit 32. There might be another issue sir. Please help me
for Excel file *.xlsx use this odbc connectionstring [Collection: ProductionInfo] ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" +@@ProductionMaterODBCExcelPath SQL : "Select*from[Production$]"
[System : Formula] locImportofXLXData : "Payroll Import" [#Menu: Gateway Of Tally] Add : Key item : @@locImportofXLXData: X : menu : Production Import [Menu: Production Import] Indent: "EXCEL TO TALLY" Item: Blank Item: Production Import : call : Import Production [Function : Import Production] 001 : Call : Import of Production Voucher Variable : SVViewname : String [Function : Import of Production Voucher] Variable : Counter : Number 00 : SET : Counter : 0 01 : START PROGRESS $$NumitemsroductionInfo=0) : "Vouchers Importing " : @@CmpMailName : "ProductionVCH Importing ..." ;;01a: SET : $$NumitemsroductionInfo=0 02 : WALK COLLECTION : Production Info 03 : SET : SVViewName : $$SysNameayrollVchView 04 : NEW OBJECT : Voucher 05 : SET VALUE : Date : $$Date@EVchDatePost 06 : SET VALUE : VoucherTypeName :$$VchTypeProduction 06a : Set : AccountsVch : No 06b : Set : InventoryVch : No 06c : Set : PayrollVch : Yes 07 : INSERTCOLLECTION OBJECT : PAYROLLENTRIES 08 : SET TARGET : ATTENDANCEENTRIES 09 : SET VALUE : Name :$DSDatdnsname 10 : SET VALUE : ATTENDANCETYPE: $DSDatdnstype 11 : SET VALUE : ATTDTYPEVALUE: $DSDatdnsvalue 12 : SET TARGET : .. 13 : SET VALUE : NARRATION :"Being Production for this Month " 14 : SET VALUE : CrDtTm1 :$$CmpUserName 15 : SET VALUE : CrDtTm2 :$$MachineDate 16 : SET VALUE : CrDtTm3 :$$MachineTime 17 : CALL : Save Target Production 18 : INCREMENT : Counter 19 : SHOW PROGRESS : ##Counter 20 : END WALK 21 : END PROGRESS 22 : RETURN [Function: Save Target Production] 04 : Save Target [Collection: ProductionInfo] ODBC : "Driver={Microsoft Excel Driver (*.xlsx)};Dbq=" + @@ProductionMaterODBCExcelPath+"" SQL : "Select*from[Production$]" SQLObject : Production Info Obj [Object : Production Info Obj] DSDDATE : $_1 DSDatdnsname : $_2 DSDatdnstype : $_3 DSDatdnsvalue : $_4 [System : Formula] ProductionMaterODBCExcelPath : "E:\Tally.ERP9\ImportPayrollVoucher.xlsx" ;; The Excel Sheet Path ProductionMaterODBCExcelsheet : "Production" ;; Sheet name in That Excel File ;;End-of-File
Change *.xlsx file in to *.xls file and keep yr old connection string it will work or use this as it is [Collection: ProductionInfo] ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" +@@ProductionMaterODBCExcelPath SQL : "Select*from[Production$]"
Sir,thanks for your constant help.Now Voucher imported Successfully but another problem arise.value not stored in production voucher. I attached image. sir please help.thanks. View attachment 2791
if you are inserting data into secondary collections use $$TgtObject while setting values.. for example.. 900 : SET VALUE : ACTUALQTY : $$TgtObject:$$AsQty:##vRBCVchItemQty*-1 910 : SET VALUE : BILLEDQTY : $$TgtObject:$$AsQty:##vRBCVchItemQty*-1