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

I am unable to check
As getting this error

 

Sir, Image not displayed.

 

Sir,

This is the Excel file and Code file in which I have included all the fields of Bank Allocations but even then Entry not showing in Bank Reconciliation.

Please help...........

 

Please look at the screenshot, where in I have displayed the Bankersdate and Mode, it is showing there
but not showing in reconciled vouchers list after pressing show reconciled entries YES.

 

Sir,

Not showing in reconciled vouchers list after pressing show reconciled entries YES.

Please help...

 

Sir, Please help....

 

Finally done!

Thanks a lot to all the experts who helped me !!!

 

Sir, I want you use my customized voucher type instead or simple "Receipt" how set it in TDL lik "Receipt-AA" instead of Receipt.

I Tried below code but did't work.

130 : SET : SVViewName : $$SysName:AcctgVchView
131 : Set Value : VCHTYPE : $ABRVoucherType

Thanks & Regards,

 

131 : Set Value : VoucherTypeName : $ABRVoucherType

 

But where should i inster this code?
just below the...
130 : SET : SVViewName : $$SysName:AcctgVchView

or some where else?

 

is This your code or you just copy paste.First you have study the code carefully then you implement it

 

Done sir!

 

Sir,

Suppose I have imported one excel file which has 10 entries, if I again Import the same file currently it is imported again and entries are duplicated and so on.. Is there any way to stop the duplication.

Thanks & Regards,

 

Sir, I am looking for that code only...

If possible please share.

Thanks!

 

Sir, Please tell me how to set REMOTEID. I think it is controlled by this Method.

 

Sir,

I am able to control it through VBA ... but in TDL it hasn't happened so far.

 

Hi can you please let me know how it was done, as I am still unable to get the vouchers to show under reconciliation after import.

 

You need to capture all schema carefully.

 

I have tried in all possible ways but still couldn't got success, I use for Receipt as well as Payment. Will appreciate if you can help me out I suspect mistake in below code :


75 : Insert Collection Object : AllLedger Entries
75As: Set Target : LedgerEntries
76 : Set Value : Ledger Name : $PremierCrLedger
77 : Set Value : IsDeemedPositive : No
78 : Set Value : Amount : $$AsAmount:$PremierVchAmountCR;*-1

80 : Insert Collection Object : Bank ALLOCATIONs
81 : Set Target : BankAllocations[1]
81A : Set Value : Date : $$DateremierVchDate
81B : SET VALUE : Bank Party Name : $PremierDrLedger
81C : SET VALUE : Transaction Type : "e-Fund Transfer";"cheque"
81D : Set Value : Instrument Date : $$Date:$PremierVchDate
81E : Set Value : Bank Name : "Not Applicable"
81F : Set Value : Amount : $$AsAmount:$PremierVchAmount
81G : Set Value : Payment Favouring : $PremierDrLedger
81H : Set Value : INSTRUMENTNUMBER : " "
81I : Set Value : Name : $$MakeUniqueID
81J : Set Value : PaymentMode : "Transacted"
frff : Log : $PremierDrLedger
100 : Save Target
;89 : Set Value : PaymentMode : "Transacted"
;110 : Refresh Target
90 : End Walk
104 : Return

[Function : SA_SavTargt]
105 : Save Target

 

Congratulations....I am still unable to get import vouchers into bank reconciliations......You have done a good job..

 

Simple, Open Company - Press Alt + Ctrl + M - Select Modules to Migrate - Select All Items - Take Backup before Migrating - Then check bank reconciliation. It surely will show all the entries which imported from MS Excel to Tally.

 

Thank you sir for so much of valuable information...I really appreciate...I took back-up and did the Migrate and it worked......Tnx......

 

Most Welcome