Hi Experts, I am done the TDL for Import from excel to Tally, it is working but in bill allocation in debit side it will come credit balance, please refer my below code and correct the same. Thanks in advance. 00 : SET : Counter : 0 01 : START PROGRESS : ($$NumItemsaymentInfo) : "From Excel" : "Vouchers Importing ..." 02 : WALK COLLECTION : Payment Info 03 : SET : SVViewName : $$SysName:AcctgVchView 04 : NEW OBJECT : Voucher 05 : SET VALUE : VoucherNumber : $VchNum 06 : SET VALUE : VoucherTypeName : $VchType 07 : SET VALUE : Date : $$Date@EVchDatePost 08 : Walk Collection : DrLedFilter 09 : INSERTCOLLECTION OBJECT : AllLedgerEntries 10 : SET TARGET : LedgerEntries 11 : SET VALUE : LedgerName : $TSLedgerNamedr 12 : SET VALUE : Amount : $TSAmountdr 13 : SET VALUE : Is Deemed Positive : Yes 14 : INSERT COLLECTION OBJECT : BILLALLOCATIONS ;00 : SET : Counter : 0 15 : SET VALUE : BILLTYPE : "Agst Ref" 16 : SET VALUE : Name : $STDrBillNo 17 : SET VALUE: Amount : $STAgstDebitAmout 18 : SET TARGET : .. 19 : SET TARGET : .. 20 : End Walk
Thanks Mr jobimon, It is importing correct, but putting negative in values in excel is not correct. Anyway please give me the correct formula as per tally for : SET VALUE : Amount: -1 * $$AsAmount:$STAgstDebitAmout Thanks in advance.
Dear Jobimon, I have done attached TDL, it is working properly in ERP 9 - 4.7 but not working properly in ERP 9 - 4.7, I mean bank ledger not importing, (getting error: Proper Pay Link Name not given for 'Bank Name') please help for getting solution. Thanks in advance.
I am little busy for three or four days. But when i have a quick look in your TDL .I found the following Line No 11 & Line 23 Value is taken from $TSLedgerName.But you have given Correct in Bank Allocations I think you $TSLedgerName will bring Party name not bank name. Since I do not have Excel file. I guess so.
Thanks Mr Jobimon, I have not get any idea, why it is not importing. Please find attached excel format for your reference. Whenever you will get time, Kindly help me on this issue. Thank your very much for your time.
As per this coding Each line in excel file is a set of data for new voucher in tally. You have to give all data in a single line and you need to increase the number of columns
Dear Manjappa, Please add following two lines after line 34 and it should work fine. 34a: SET VALUE : PaymentMode : $$SysName:Transacted 34b: SET VALUE : Name : $$MakeUniqueID