Please help on error

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

 

add following line

SET VALUE : Is Deemed Positive : Yes

 

Sir,

Same answer, Bill allocation is importing as credit balance instead of debit

 

please see this

http://tdlexperts.com/index.php?threads/payment-import-from-excel.3454/

 

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.

 

SET VALUE:Amount: (($$Number:$PaybillAmt)*-1)

 

Thanks Jobimon,

It is working properly, once again thanks a lot.

 

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.

 

Sorry,

not working properly in ERP 9 - 4.8

 

Please Please help me...

 

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

 

Sir, I agree your point, but I cloud not understand that how to do.

Please please pleas helpme

 

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