Hi i am using a payol import TDL. Suddenly i get this error. how to rectify this i am using ERP 4.92 64 bit. FUNCTION: 'TSPL FFE ImportAttendanceVoucher' LABEL: 220 : No Entries in Voucher! Plz help to resolve this issue immed.
Are u Importing Excel Sheet Data Check whether Required Data Fields in vouchers have Data No Entries in Voucher , Means some values are missing while trying to create a voucher
Sir s importing from excel only. but it produces error. using 4.92 version 64 bit. even tried in 32 bit. used various excel version too. attaching payroll tds for ur verification. had been using it for last 2 yrs no issues. now suddenly issue started. ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara /* Objective(s) :- - To import Employee Masters and Attendance Vouchers from Excel Data Source - Also the Excel File Templates are made available - This code is Remote Client compatible Will work both at either ends viz., Server and Remote Client End Dependencie(s) :- - Tally.ERP9 Release 2.0 onwards - Excel Files containing relevant data Updation History :- - Altered on 01/09/2010 */ [#Menu: Gateway of Tally] Add : Key Item : After : @@locIndentImport : "Import of Payroll Data" : P : Menu : TSPL FFE Import Payroll Data [Menu: TSPL FFE Import Payroll Data] Item : "Employee Masters" : Menu : TSPL FFE Employee Masters Item : "Attendance Vouchers" : Menu : TSPL FFE Attendance Vouchers Title : "Import Payroll Data" [Menu: TSPL FFE Employee Masters] Item : "Create Template" : CALL : TSPL FFE Employee Template Item : "Employee Masters" : Execute : TSPL FFE Employee Master Import Title : "Employee Masters" [Menu: TSPL FFE Attendance Vouchers] Item : "Create Template" : CALL : TSPL FFE Attendance Template Item : "Attendance Vouchers" : Execute : TSPL FFE Attendance Vch Import Title : "Attendance Vouchers" [Function: TSPL FFE Export Excel Template] ;; Common Function Template 00 : SET : SVExportFormat : $$SysName:Excel 10 : SET : SVExcelExportUpdateBook : No 20 : SET : SVExcelExportWithFormatting : Yes 30 : SET : SVExcelExportWithColour : Yes [Include: AttendanceImport.TDL] [Include: EmployeeImport.TDL] ;; End-of-File attendance import TDL ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara [System: Formula] TSPL FFE AttdVchFilePath : ##TSPLFFESVAttdVoucherExcelPath ;;****************************************** ;; Configuration Report ;;****************************************** [Report: TSPL FFE Attendance VCH Import] ;; Auto Report Form : TSPL FFE Attendance VCH Import Title : $$LocaleString:"Import of Attendance Voucher" Auto : Yes Variable : TSPL FFE SVAttdVoucherDate Set : TSPL FFE SVAttdVoucherDate : ##SVCurrentDate [Form: TSPL FFE Attendance VCH Import] No Confirm : Yes Space Top : 1 Space Left : 1 Space Right : 1 Space Bottom : 1 Option : Small Size Form Full Width : No Full Height : No Vertical Align : Centre Part : TSPL FFE Attendance VCH Import Title, TSPL FFE Attendance VCH Import Details On : Form Accept : Yes : CALL : TSPL FFE ImportAttendanceVoucher [Part: TSPL FFE Attendance VCH Import Title] Lines : TSPL FFE Attendance VCH Import, TSPL FFE Attendance VCH Import Info [Line: TSPL FFE Attendance VCH Import] Fields : Form Sub Title Space Bottom : 0.25 Local : Field : Form Sub Title : Info : $$LocaleString:"Import of Attendance Voucher" [Line: TSPL FFE Attendance VCH Import Info] Field : Simple Field Space Bottom : 0.75 Local : Field : Simple Field : Info : $$LocaleString:"(Only Tally (XLS) Format is Supported)" Local : Field : Simple Field : Full Width : Yes Local : Field : Simple Field : Align : Centre [Part: TSPL FFE Attendance VCH Import Details] Line : TSPL FFE Employee Master Import FileName, TSPL FFE Attendance VCH Import VchDate Local : Field : TSPL FFE Employee Master Import FileName : Modifies : TSPL FFE SVAttdVoucherExcelPath : Yes Local : Field : TSPL FFE Employee Master Import FileName : Variable : TSPL FFE SVAttdVoucherExcelPath [Line: TSPL FFE Attendance VCH Import VchDate] Field : Medium Prompt, TSPL FFE Attendance VCH Import VchDate Local : Field : Medium Prompt : Info : $$LocaleString:"Voucher Date :" [Field: TSPL FFE Attendance VCH Import VchDate] Use : Short Date Field Modifies : TSPL FFE SVAttdVoucherDate : Yes Variable : TSPL FFE SVAttdVoucherDate Align : Left [Variable: TSPL FFE SVEmpMasterExcelPath] Type : String Default : "" Persist : Yes [Variable: TSPL FFE SVAttdVoucherExcelPath] Type : String Default : "" Persist : Yes [Variable: TSPL FFE SVAttdVoucherDate] Type : Date Volatile: Yes [System: Variable] TSPL FFE SVEmpMasterExcelPath : "" TSPL FFE SVAttdVoucherExcelPath : "C:\Tally.ERP9\Attendance.XLS" TSPL FFE SVAttdVoucherDate : "" ;;****************************************** ;; Excel File Reading ;;****************************************** [Collection: TSPL FFE AttendanceDataExcelColl] ODBC : "Driver={Microsoft Excel Driver (*.xls)}; Dbq=" + @@TSPLFFEAttdVchFilePath SQL : "Select * from [Attendance$]" SQLObject : TSPL FFE Attendance Excel Voucher Client Only : Yes [Object: TSPL FFE Attendance Excel Voucher] EmployeeName : $_1 AttendanceType : $_2 AttendanceValue : $_3 [Collection: TSPL FFE ExcelInventory] Source Collection : TSPL FFE AttendanceDataExcelColl By : EmployeeName : $EmployeeName By : AttendanceType : $AttendanceType Compute : AttendanceValue : If NOT $$IsEmpty:$AttendanceValue Then $AttendanceValue Else 0 Client Only : Yes ;; --------------------------------------------------------------------------------------------------------------------- [Function: TSPL FFE ImportAttendanceVoucher] LOCAL FORMULA : ProdAttdValue : $$String:$AttendanceValue + $BaseUnits:AttendanceType:$AttendanceType ;; To Fetch Object Production Type 'Absent' in case of Remote Company 00 : IF : $$IsRemoteCompany 01 : CALL : TSPL FFE FO AttendType 02 : ENDIF ;; Create Production Type "Absent" if not yet created 05 : IF : $$IsEmpty:$Name:AttendanceType:"Absent" 10 : NEW OBJECT : Attendance Type 20 : SET VALUE : Name : "Absent" 30 : SET VALUE : Attendance Production Type : "Leave Without Pay" 40 : SET VALUE : Attendance Period : "Days" 50 : SAVE TARGET 60 : ENDIF 70 : NEW OBJECT : VOUCHER 80 : SET VALUE : Date : ##TSPLFFESVAttdVoucherDate 90 : SET VALUE : VoucherTypeName : $$VchTypeAttendance 100 : WALK COLLECTION : TSPL FFE ExcelInventory 110 : INSERT COLLECTION OBJECT : AttendanceEntries 111 : IF : $$IsRemoteCompany 112 : CALL : TSPL FFE FO AttendProdType 113 : ENDIF 120 : SET VALUE : Name : $EmployeeName 130 : SET VALUE : AttendanceType : $AttendanceType 140 : IF : $$IsSysNameEqualroduction:$AttendanceProductionType:AttendanceType:$AttendanceType 150 : SET VALUE : AttdTypeValue : $$TGTObject:$$AsQtyProdAttdValue 160 : ELSE: 170 : SET VALUE : AttdTypeTimeValue : $AttendanceValue 180 : END IF 190 : SET TARGET : .. 200 : END WALK 210 : SET TARGET : .. 220 : SAVE TARGET ;; Report displaying imported Attendance Voucher 230 : DISPLAY : TSPL FFE AttendanceVoucherSummary 240 : RETURN [Function: TSPL FFE FO AttendType] Fetch Object : Attendance Type : "Absent" : $Name 00 : LOG : "Fetched Object - " + $Name:AttendanceType:"Absent" [Function: TSPL FFE FO AttendProdType] Fetch Object : Attendance Type : $AttendanceType : $AttendanceProductionType 00 : LOG : $AttendanceProductionType:AttendanceType:$AttendanceType ;; --------------------------------------------------------------------------------------------------------------------- ;; Display Report of Attendance Voucher Summary ;; --------------------------------------------------------------------------------------------------------------------- [Report: TSPL FFE AttendanceVoucherSummary] Use : Attendance Vouchers Set : SV From Date : ##TSPLFFESVAttdVoucherDate Set : SV To Date : ##TSPLFFESVAttdVoucherDate ;; Template-------------------------------------------------------------------------------------------------------------- [Function: TSPL FFE Attendance Template] 00 : CALL : TSPL FFE Export Excel Template 10 : SET : SVPrintFileName : $$MakeExportName:"AttdTemplate":##SVExportFormat 20 : EXPORT : TSPL FFE Attendance Template : TRUE 30 : EXEC COMMAND : Excel : "AttdTemplate.XLS" [Report: TSPL FFE Attendance Template] Form : TSPL FFE Attendance Template Title : "Attendance" [Form: TSPL FFE Attendance Template] Parts : TSPL FFE Attendance Template Height : 100% Screen Width : 100% Screen Option : Small Size Form Excel Sheet Name: "Attendance" [Part: TSPL FFE Attendance Template] Lines : TSPL FFE Attendance Template Title [Line: TSPL FFE Attendance Template Title] Fields : TSPL FFE AttdTmpl EmpName, TSPL FFE AttdTmpl AttdType, TSPL FFE AttdTmpl AttdValue Border : Column Titles [Field: TSPL FFE AttdTmpl EmpName] Use : Name Field Set as : $$LocaleString:"Employee Name" Style : Normal Bold [Field: TSPL FFE AttdTmpl AttdType] Use : Name Field Set as : $$LocaleString:"Attendance/Production Type" Style : Normal Bold [Field: TSPL FFE AttdTmpl AttdValue] Use : Name Field Set as : $$LocaleString:"Attendance Value" Style : Normal Bold ;; End of File
There is no any issue with tdl but the version you are using. Use 4.92 tally 32bit and try. It will run properly. If you want to run on the Tally 64bit only then install 64bit excel to run the same. Both applications should be on the same platform to run rather to integrate with each others. aaradhya.tallysolutions@gmail.com
@ RBS Prasad - I used excel template created by the tdl only. @ aaradhya chaudhari - i too felt the same & tried 64 bit excel before posting in forum. it throws same error. now i have 64 bit tally 4.92 and 64 excel 2013. same error. now tried 32bit tally 4.92 same error. @NAGARAJKMAR SUBRAMANIAN - sir pfa for excel
Save the excel file in XLS format (not in xlsx) then try I have tested after saving the file in XLS format, its working fine My tally config is 64bit Tally.ERP9 4.92 Excel 2010
tried it prasad. didnt work. even changed to excel 2013 64bit. all format. no luck. pfa my attachment
Yes, It is working fine with Tally.ERP 9 4.91 32 Bit Exe , MS OFFICE 2010 XLS Format But in Tally.ERP Rel 4.91 64 bit EXE/ MS Office 2010 /XLS or XLSX Format , it is not working Problem is unable to Gather Collection from Excel Sheet through ODBC Might be problem in Tally 64 Bit ODBC Driver We can ask Tally for this issue.
I got reply from Tally for Tally.ERP9 64 Bit, Excel should also be 64 Bit compatible to rectify this error.
when I use tally's exported template, still its not working. When I import employee master, only 1st group creates, rest of the things not created and did not see any error for that not creation of master. Please guide.
Hi Check this points. 1. ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + @@JournalXLSFilePath SQL : "Select * from [Sheet1$]" 2. Excel 64bit & Tally 64 bit & OS also 64 Bit 3. Excel 32bit & Tally 32 bit & OS also 32 Bit
