Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Yahia Khaled Bsat]

When doing bank account reconciliation, there is a column for “Value Date” which I want to use to record the real date the bank will consider interest on the amount and so forth. When I fill the field, it seems like it doesn’t affect anything? Or where can I find this information when looking at the bank ledger entries?

——————————
Yahia Bsat
Evanston IL
——————————

[Ramin Marghi]

Hi Yahia,

I assume this is the Bank Reconciliation with auto-match you’re referring to (bank statement on the left, subledger details on the right)?

The Value Date is ancillary information and does not flow to the Posted Bank Rec. or anywhere in the Bank/Cheque Ledgers. The field only lives in two tables:

• Table #274 (Bank Acc. Reconciliation Line)
• Table #1296 ??(Posted Payment Recon. Line)

So if you’re doing a Payment Reconciliation (see: How Do I: Reconcile Bank Payments in the Reconciliation Journal in Microsoft Dynamics NAV 2015 – Microsoft Dynamics NAV Community) you could technically trace it to the Applied Document, but if you’re doing a run-of-the-mill bank rec. the base product does not seem to keep that link.

If you want to retain that link, you’d need a customization to modify the Bank / Cheque Ledger Entry to have a custom “Statement Value Date” field, à la the following existing fields that get populated when it gets processed in the Bank Rec.:

And then modify any function where that’s set, such as the SetReconNo function in Codeunit #375 (Bank Acc. Entry Set Recon.-No.):

Hope that helps!
?

——————————
Ramin Marghi , CPA, CGA
CPA, CGA | ERP Consultant
Catapult ERP
VANCOUVER BC
——————————
——————————————-

[Yahia Khaled Bsat]

Thank you! This makes sense. Will have to customize then!

——————————
Yahia Khaled Bsat
Evanston IL
——————————
——————————————-