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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

YTD account date issue

(0) ShareShare
ReportReport
Posted on by 25

Why do the YTD account takes up a general ledger posting date of 01-01-1900?

Every time a transactions is posted to income/expense a one sided entry is automatically generated to YTD Net Income which is correct.

However why are these transactions all dated 01-01-1900?How to fix this?

I have the same question (0)
  • CFROTON Profile Picture
    4,710 on at

    I’m not sure what date you are looking at or where do you see this date...... but 1/1/1900 just means the date is null.  The date field has not been updated.  If  looking at a crtd_datetime or lupd_datetime, that just means the application is not updating that field.  When a record is created or updated, it’s not a sql function that updates those fields.  It’s the application code and some application codes don’t update the fields.  That would be a bug or an oversight.  I don’t think there are any applications that would deliberately not update those, but there are applications that don’t.

    Where do you see the date?

    Best Regards

    Jana MacDonald

  • Suggested answer
    Sandy Maharaj Profile Picture
    25 on at

    When I pull the Trial Balance report and detail general ledger reports I see the year to date account transactions all dated 01-01-1900.

  • CFROTON Profile Picture
    4,710 on at

    Hello Sandy,

    There is no date on that report. I don't see where I can put a date on this report.

    Do you see a GL batch ?  What version of SL are you running.

    Best Regards,

    Jana MacDonald

  • Suggested answer
    Sandy Maharaj Profile Picture
    25 on at

    Hello Carolyn

    The version of SL is 7.0, here is were the one sided entry occurs when a transaction is posted to income and expense directly to the balance sheet. These one sided transactions are all dated 01-01-1900.

  • Sandy Maharaj Profile Picture
    25 on at

    Oh there are no GL batches.

  • Suggested answer
    CFROTON Profile Picture
    4,710 on at

    Dear Sandy,

    The date would come from gltran, since there are no gltrans then it can't assign a transaction date.

    It seems that this is by design.  

    Best Regards,

    Jana MacDonald

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans