Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Session date with Electronic Reporting

Posted on by 52
I am experiencing some inconsistent behaviour around the session date when importing Bank Statements using Electronic Reporting definitions and I'm hoping someone can shed some light on this? The Accounting Date on any manually created Bank Statement defaults to the session date, but on importing statements using an Electronic Reporting definition, this behaviour is not consistent.
  1. If I change the session date to July 1st 2023 by clicking the calendar on the home screen, then import, it ignores this session date and sets the Accounting Date on the statement to the literal current date. If I then go to check the session date and time afterwards using any UI method, it shows as July 1st 2023.
  2. If I change the session date under Common > Common > Session date and time, and tick the /cascade to business operations/ option, then do the import, it correctly sets the Accounting Date on the statement to July 1st 2023, as expected.
I have debugged and found that the value is set by Tables//BankStmtISOAccountStatement.initValue(), which defaults the Accounting Date like so:
 
this.AccountingDate = DateTimeUtil::getSystemDate(DateTimeUtil::getUserPreferredTimeZone());
 
Debugging this line, if I set the session date using method 1 above, this.AccountingDate gets the value of the literal date and time. With option 2, it changes to the session date. Therefore this is the root cause of the inconsistency, but I can't understand why this behaviour is occurring. DateTimeUtil::getSystemDate() effectively does not appear to get the session date correctly when it is set using the calendar on the Default Dashboard, but only in the context of an ER import. Does an ER import run under a different user context or something along those lines?
 
So far, I have tested and replicated this in 10.0.33 and 10.0.35
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,786 Most Valuable Professional on at

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans