Hi, I'd like some help with importing my excel file via tdl to tally. This was based on the post : http://tdlexperts.com/index.php?threads/import-payment_vch-excel-to-tally.251/#post-564 however i cant seem to get it to work. The start progress just starts and dissappears, when I check on the ledger vouchers, the entries aren't there. Code: [#Menu : Gateway of Tally] Item : Import : CALL : Import payment [Function : Import payment] 001 : Call : Import Of Payment Voucher [Function : Import Of Payment Voucher] Variable : Counter : Number 00 : SET : Counter : 0 01 : START PROGRESS : ($$NumItems:PaymentInfo) : "Vouchers Importing " : @@CmpMailName : "Payment Vouchers Importing ..." 02 : WALK COLLECTION : Payment Info 03 : SET : SVViewName : $$SysName:AcctgVchView 04 : NEW OBJECT : Voucher 05 : SET VALUE : Date : $$Date:@@EVchDatePost 06 : SET VALUE : VoucherTypeName : $ $VchTypePayment 07 : INSERTCOLLECTION OBJECT : AllLedgerEntries 08 : SET TARGET : LedgerEntries 09 : SET VALUE : LedgerName : $DSDLedgerNameDr 10 : SET VALUE : Amount : $DSDAmountdr 20 : SET VALUE : Is Deemed Positive: "Yes" 30 : SET TARGET : .. 40 : INSERTCOLLECTION OBJECT : ALlLedgerEntries 50 : SET TARGET : LedgerEntries 60 : SET VALUE : LedgerName : $DSDLedgerNameCr 70 : SET VALUE : Amount : $DSDAmountcr 80 : SET VALUE : Is Deemed Positive: "No" 90 : SET TARGET : .. 100 : SET VALUE : PersistedView : ##SVViewName 110 : SET VALUE : NARRATION :$DSDNarration 120 : CALL : Save Target Payment 130 : INCREMENT : Counter 140 : SHOW PROGRESS : ##Counter 150 : END WALK 160 : END PROGRESS 170 : RETURN [Function: Save Target Payment] 04 : Save Target [Collection: Payment Info] ODBC : "Driver={Microsoft Excel Driver (*.xls)};Dbq=" + @@MaterODBCExcelPath+"" SQL : "Select * from ["+@@MaterODBCExcelSheet+"$]" SQLObject : Payment Info Obj [Object : Payment Info Obj] DSDDATE: $_1 DSDLedgerNameDr : $_2 DSDLedgerNameCr : $_3 DSDAmountdr : $_4 DSDAmountcr : $_5 DSDNarration :$_6 [System : Formula] EVchNoPost : $_1 EVchDatePost : $$Date:@@EVchDateStrPost EVchDateStrPost : ($$StringPart:$_1:8:2) + "-" + + ($$StringPart:$_1:5:2) + "-" + + ($$StringPart:$_1:0:4) [System : Formula] Mater ODBC Excel Path : "C:\Program Files\Tally.ERP9\ImportVouchers.xls" ;; The Excel Sheet Path Mater ODBC Excel Sheet : "PaymentVCH" ;; Sheet name in That Excel File ;;End-of-File
IMPORT PAYMENT VOUCHER EXCEL TO TALLY is not working in tally 9 v2.14, plz resolve the problem is help full to me thanks
Dear Experts, Pls help I want to generate payment sheet for bank from payment voucher. Means when i make payment sheet, i want to add one option PAYMENT SHEET, as like payment advice. Payment sheet format: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Dt. xx.xx.xxxx To, The Bank Manager, BANK NAME FROM PAYMENT VOUCHER Sub: Transfer of payment by CHQ. NO. FROM PAYMENT VOUCHER. Dear Sir, We are enclosing herewith our Cheque Number FROM PAYMENT VOUCHER dated FROM PAYMENT VOUCHER for amount Rs. FROM PAYMENT VOUCHER in words Rupees FROM PAYMENT VOUCHER We request you to kindly transfer the amount as per the following details Sr No. Party Name Bank Account No. Amount Rs. 01 ABCDE XXXXXXXXXXX FROM PAYMENT VCH 02 XYZ XXXXXXXXXXX FROM PAYMENT VCH 03 PQR XXXXXXXXXXX FROM PAYMENT VCH Total Amount Rs. FROM PAYMENT VCH Thanking you. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - I requesting you to help me for preparing its TDL. Thanks.