web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Input wrong year in Bank reconciliation date

(0) ShareShare
ReportReport
Posted on by 1,015

Hi there,

I have a question about “Bank Reconciliation” (Bank> Bank account detail details> Select Bank account> Function button> Account Reconciliation> Input ‘ Bank account statement date’). And here is the point. I have a problem with the wrong input date.

Imagine that I need to create Bank reconciliation as of August 31, 2009 and September 30, 2009 but we input in the ‘ Bank account statement date’ field with 8/31/2010 and 9/30/2010 respectively. Worst than that, we did reconcile the account before we realize that we input the wrong period.

The question is how to correct the period of bank reconciliation. And if we couldn’t correct the period, are there any effects if the period is wrong.

Because of the beginning balance and ending balance relation following the timeline, we couldn’t create the bank reconciliation using back date. Therefore, one of the alternative solution that I can think is only creating bank reconciliation of
* 31 October, 2009 (next month) with the date of 10/1/2010
* 30 November 2009  with the date of 10/2/2010
* 31 December 2009 with the date of 10/3/2010
and so on, until the period of 31 October, 2010 comes and we can use the real period of 10/31/2010 (The real period)
But I don’t know if there are any effects from the wrong year recording of current-year bank reconciliation.

Or if there are other appropriate solutions, please help

*This post is locked for comments

I have the same question (1)
  • Community Member Profile Picture
    on at

    Hi,

    with an updatejob you should update two tables with the proper date:

    • BankAccountStatement table, field AccountStatementDate
    • BankAccountTrans table, field AccountStatementDate

    Example of code:

    static void UpdateBankAccountStatement(Args _args)
    {
        BankAccountStatement    bankaccountstatement;
        BankAccountTrans        bankaccounttrans;
        ;
        ttsbegin;
        while select forupdate bankaccountstatement
        where bankaccountstatement.AccountStatementNum == 'fill in number'
        {
            bankaccountstatement.AccountStatementDate = str2date('01/01/2009',123);
            bankaccountstatement.update();
        }
        ttscommit;
       
        ttsbegin;
        while select forupdate bankaccounttrans
        where bankaccounttrans.AccountStatement == 'fill in number'
        {
            bankaccounttrans.AccountStatementDate   = str2date('01/01/2009',123);
            bankaccounttrans.update();
        }
       
        ttscommit;
       
        info('ready');
    }

    end example code.

    Please let a develop have a look at this, since the date function should be set according to your AOS settings.

    In this case a simple update will do the trick. No ledger postings are made when bank reconcilation has been used.

    Kind regards,

    Dennis

  • Kanchamas C. Profile Picture
    1,015 on at

    Hi Dennins,

               Thanks for your recommendation again. I did adjust the date in SQL directly and it seems like it works.

    and like you said, I did adjust into 2 tables which are exactly from what you suggest.

    Cheers,

    Kanchamas

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sanhthosh.Kumar.K Profile Picture

Sanhthosh.Kumar.K 2

#2
Raed Salah Bzour Profile Picture

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans