Skip to main content

Notifications

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?

  • Suggested answer
    CFROTON Profile Picture
    4,710 on at
    RE: YTD account date issue

    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

  • Sandy Maharaj Profile Picture
    25 on at
    RE: YTD account date issue

    Oh there are no GL batches.

  • Suggested answer
    Sandy Maharaj Profile Picture
    25 on at
    RE: YTD account date issue

    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.

  • CFROTON Profile Picture
    4,710 on at
    RE: YTD account date issue

    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
    RE: YTD account date issue

    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
    RE: YTD account date issue

    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

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans