This is code to show in the bank ledger if reconciliation is done, but not working in Tally Prime 6. Please help update the same [#LineSP VCHAccTitles] add:Right Field:afterSP VCHNumberTitle:VKYMALIKBDT [field:VKYMALIKBDT] Use:Medium Prompt Set As:"Reconciled" [#LineSP VCHDetail] add:Right Field:afterSP VCHNumber:VKYMALIKBD [field:VKYMALIKBD] Useate Field Set As:$AllLedgerEntries[-1].BankAllocations.BankersDate Width:20 [#Collection:Vouchers of Ledger] Fetch:AllLedgerEntries.BankAllocations.BankersDate
There is no difference in earlier version and Tally Prime -- with regards to above code. It should work fine ---
Amit Sir Before march in Tally 6.1 when we reconcile bank statement, we were able to see the reconciled date in the ledger of the bank , but after 1st April 25 we aren unable to see the same even we have same TDL loaded.
In Tally 6 or above -- majority people are importing transactions and even though the NEW Recon format shows reconciliation, the manual method is left untouched. e.g. Go to Bank A/c -- press Ctrl+R for Reconcile ---- then once again press Ctrl+R for Manual Recon --- then see --- the Bankers Date is empty. The reason -- when importing transactions all entries are passed on same date as the Bank Entries --- so BankersDate is BLANK. So you can use a CONDITIONAL formula --- If empty-Bank date then Instrument Date else Bank Date. HOWEVER -- you will need to refresh all the vouchers --- Enter the Voucher and Press Ctrl+A to exit --- the date will appear then.
Thanks for your prompt response, Amit Ji. Is there an alternative option, or can we edit the TDL to allow us to reflect the dates in the ledger according to the new reconciliation system?
In whatever option the TDL will have to be altered. There is no NEW reconciliation system in Prime -- it is the same as before -- as you can see under "Manual Recon". The new Reco you see is not the ACTUAL reco -- it is just a report that shows which entry exists in Tally or the Bank and adjusts the balance accordingly, leading user to believe the Reco is done. It is not as the BANKERSDate is still empty. In my earlier post I have guided you to the changes to be made in the TDL. Make the changes and accordingly thereafter, it will display.
