Skip to main content

Notifications

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

YTD account date issue

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
    CFROTON 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
    Sandy Maharaj 25 on at
    RE: YTD account date issue

    Oh there are no GL batches.

  • Suggested answer
    Sandy Maharaj Profile Picture
    Sandy Maharaj 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
    CFROTON 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
    Sandy Maharaj 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
    CFROTON 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans