Receipt Vouchers Imported from Excel into Tally not showing in Bank Reconciliation

Dear Experts,

I tried to use the below code after lot of search on web but result is zero the below code is not working. I don't know how to rectify. Please help and correct.


1280 : INSERTCOLLECTION OBJECT : BANKALLOCATIONS
1290 : SET TARGET : BANKALLOCATIONS
1300 : SET VALUE : BANKERSDATE : $$Date@EVchDatePost;$ABRBankersDate
1301 : Set Value : Name : $$MakeUniqueID
1302 : Set Value : Payment Mode : "Transacted"
1310 : SET TARGET : ..


Thanks & Regards,

 

Please Explain In details with Screenshot of your problem

 

Sir,
when I import Receipt Voucher from Excel, and when we go to the bank reconciliation screen by pressing F5 to reconcile the bank, it does't show these entries there.

 

You have to fill full detail of Bank Allocation like Transaction Type, Cheque Number, Cheque Date etc then only it will show in Bank Reconciliation screen

 

You set, 1300 : SET VALUE : BANKERSDATE : $$Date@EVchDatePost;$ABRBankersDate
here Bankersdate means bank reconciliation date it may be already reconciled thus not showing bank reconcilation screen by pressing F5.
In bank reconciliation screen press F12 Then show reconciled transaction also set to "yes" then look that transaction showing or not?

 

It May cause as Bipin Damania said, please reply

 

Sir,

I have already checked the reconciled voucher.
Only I need to check now after putting all the field as Suggested by Mr. Bipin Damania.
However I am enclosing current screenshot and will let you know after adding all the field.

Thank you all for your such a quick response.

 

Please check
I think you have input Reconciliation Date also
Just check Reconciliation with already Reconcile detail YES

 

Sir,

I have re-written the below code please check which is not working. Moreover the moment I include the below code then no receipts are imported at all.

1280 : INSERTCOLLECTION OBJECT : BANKALLOCATIONS
1290 : SET TARGET : BANKALLOCATIONS
1300 : SET VALUE : BANKERSDATE : $$Date@EVchDatePost;$ABRBankersDate
1301 : Set Value : Name : $$MakeUniqueID
1302 : Set Value : Payment Mode : "Transacted"
1303 : Set Value : TransactionType : "Transacted"
1304 : Set Value : ChequeNumber : "Transacted"
1305 : Set Value : ChequeDate : "Transacted"

1310 : SET TARGET : ..

Please have a look at above code and correct...

Thanks

 

Sorry please ignore above code, will post new..

 

Give below is the correct code:


1280 : INSERTCOLLECTION OBJECT : BANKALLOCATIONS
1290 : SET TARGET : BANKALLOCATIONS
1300 : SET VALUE : BANKERSDATE : $$Date@EVchDatePost;$ABRBankersDate
1301 : Set Value : Name : $$MakeUniqueID
1302 : Set Value : Payment Mode : "Transacted"
1303 : Set Value : TransactionType : $ABRTransactionType
1304 : Set Value : ChequeNumber : $ABRInstrumentNumber
1305 : Set Value : ChequeDate : $ABRInstrumentDate

1310 : SET TARGET : ..


Thanks & Regards

 

Please check
I think you have already inputed Reconciliation Date
Just check Reconciliation Press F12
and set YES to Show Reconcile Transactions also

 

Sir,

There are two problem in fact.
1. If I do not include above block of code in my TDL then Receipts are imported successfully, but entries are not showing in Reconciliation Statementment, neither they are comming under reconciled voucher nor otherwise.

2. If I include above block of code in my TDL then No Receipts are imported.

I would request you to please go through my above block of code where I am making some mistake like the I am inserting collection object etc.

Please have a look at screenshot of Tally Error message....



I hope I am able to explain my problem..

 

Try This Way and Revert Me Back

1280 : INSERTCOLLECTION OBJECT : BANKALLOCATIONS
1290 : SET TARGET : BANKALLOCATIONS
1300 : SET VALUE : DATE : $$Date@EVchDatePost;$ABRBankersDate
1301 : Set Value : INSTRUMENTDATE : $ABRInstrumentDate
1302 : Set Value : Name : $$MakeUniqueID
1303 : Set Value : TransactionType : $ABRTransactionType
1304 : Set Value : ChequePrinted : $$Number:1
1305 : Set Value : PAYMENTFAVOURING : "Here Put Your Value"
1306 : SET VALUE : INSTRUMENTNUMBER : $ABRInstrumentNumber
1307 : SET VALUE : UNIQUEREFERENCENUMBER : $$MakeTallyUniqueID
1308 : SET VALUE : PAYMENTMODE:"Transacted"
1309: SET VALUE : Amount : -1* "Here Put Your Value"
1310 : SET TARGET : ..

 

After trying the below code:

1280 : INSERTCOLLECTION OBJECT : BANKALLOCATIONS
1290 : SET TARGET : BANKALLOCATIONS
1300 : SET VALUE : DATE : $$Date@EVchDatePost;$ABRBankersDate
1301 : Set Value : INSTRUMENTDATE : $ABRInstrumentDate
1302 : Set Value : Name : $$MakeUniqueID
1303 : Set Value : TransactionType : $ABRTransactionType
1304 : Set Value : ChequePrinted : $$Number:1
1305 : Set Value : PAYMENTFAVOURING : $ABRPARTYLedgerNameCr
1306 : SET VALUE : INSTRUMENTNUMBER : $ABRInstrumentNumber
1307 : SET VALUE : UNIQUEREFERENCENUMBER : $$MakeTallyUniqueID
1308 : SET VALUE : PAYMENTMODE:"Transacted"
1309: SET VALUE : Amount : -1* $ABRPARTYAmountCr
1310 : SET TARGET : ..

Getting the below error...

 

share your ledger entries code just before BANKALLOCATIONS.
And 1305 : Set Value : PAYMENTFAVOURING : $ABRPARTYLedgerNameCr (Put $ sign)
1309: SET VALUE : Amount : -1* $ABRPARTYAmountCr (Put $ sign)

 

Sir, Please find attached code.

 

Sir,

I have now attached Excel File also along with code file.

Please have a look.

 

Try This

 

Sir, I tried but getting below error...

 

It seems like + or - symbol at 1309: , I tried after removing - sign, then it worked but again not showing in Bank Reconciliation.

Or, Please have a look at the Excel file.

 

Please check
I think you have already inputed Reconciliation Date
Just check Reconciliation Press F12
and set YES to Show Reconcile Transactions also

Try this & Reply

 

Sir, Check many time but same result.

Please have a look at the screenshot.

 

If I Alter that entry by pressing Enter, Enter......
Then it shows under Un-Reconciled Item.

Please have a look at the screen shot... This is after removing -1 from line no. 1309:

 

I am unable to check
As I am getting this error