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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / The ledger date bank t...
Microsoft Dynamics AX (Archived)

The ledger date bank transaction dates showing different

(0) ShareShare
ReportReport
Posted on by Premnath C Nair 10

I have made AR payment journal with 15 lines with multiple bank accounts.I have checked the deposit slip option.The transaction happened in February and bank reconciliation was also done in  march.At that time multiple lines where available for reconciliation.However when I am checking now the ledger transactions and ledger vouchers shows the correct date that is February  and the bank transactions shows a date of May.There were multiple lines for the bank.However now the bank transaction shows only one line with the consolidated sum and the last voucher number is showing against the transaction.The already reconciled transactions are coming up in the reconciliation screen as well.Under which scenario this can happen, can any body help me.

I am using ax 2009 R2

The screen shots are attached

2148.ledger.jpgLedger screen shot

bank.jpgBank transaction screen shot 

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Premnath C Nair,

    There are not sufficient information available regarding this issue.

    In the second screenprint you selected to show only open bank transactions. If you untick this parameter do you see any other probably previously reconciled transactions?

    Best regards,

    Ludwig

  • Premnath C Nair Profile Picture
    Premnath C Nair 10 on at

    Thank you Dr.Ludwig Reinhard for the quick response.

    There is no difference after un ticking the said parameter.

    As you can see the vouchers sum and ledger transaction sum is matching

    My main concern is date ? i.e the date showing in the bank transaction screen and the ledger transaction screen are different.

    Can you please guide me : under which scenario bank transaction statement will show a single line while ledger transactions are having multiple transactions.

    It may also be noted that all the AR payment journals are from different customers. 

    The  bank reconciliations are also done in march ( transaction date was February).To my astonishment However the bank transaction date now showing as May, and reconciliation date is missing

  • Pranav Kumar Profile Picture
    Pranav Kumar Microsoft Employee on at

    The screen shots shows different voucher number. Can you audit trail this transaction from Bank transaction form and ledger transaction form and see the trnsaction details.

    Thanks,

    Pranav

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Premnath C Nair,

    It is difficult to say why the bank transaction was posted in May and not in Feb/March as you mentioned.

    Have you followed Pranav's suggestion to check the audit trial form?

    Is it possible that the AR payment was posted through a briding account that was later on just cleared through a posting against your bank? Can this explain the time difference?

    Best regards,

    Ludwig

  • Premnath C Nair Profile Picture
    Premnath C Nair 10 on at

    Hai Pranav,

    Please see the last voucher number in the ledger is showing against the bank transaction screen.The amount shown in bank transaction is the consolidation of 5 Vouchers in the ledger.

  • Premnath C Nair Profile Picture
    Premnath C Nair 10 on at

    Hai Dr Ludwig,

    The transaction was posted in February and the reconciliation was done in February itself. This date change has happened sometime after that .

    As far as I believe no changes can be done to bank transaction after the reconciliation.But this is very strange.

    We are not using bridging.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans