Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

SL 7.0 Trxs with dates 01-01-1900

(0) ShareShare
ReportReport
Posted on by 25

Good day,

The version I am working with is SL 7.0 there are a number of transactions annually occurring in the GL with date of 01-01-1900. There are no GL transactions to support summarized  AcctHist period activity for these transactions. How do I fix or delete these transactions?

It appears the system is generating these transactions to specific accounts causing the trial balance not to balance. I could be incorrect. How to correct?

  • CFROTON Profile Picture
    4,710 on at
    RE: SL 7.0 Trxs with dates 01-01-1900

    Hello

    When you print preview the report, you can export the preveiw to excel where you can see the duplicated data , I think the button for that should be on the upper left..hover over the icons for "export report" (not remembering these days what it looks like in version 7)

    Best Regards,

    Jana MacDonald

  • Sandy Maharaj Profile Picture
    25 on at
    RE: SL 7.0 Trxs with dates 01-01-1900

    Good Day,

    I did a little brainstorming exercise on my own to understand what those entries related to. After a through thought and investigation those transactions are the budgeted amount uploaded into the system. The company created two ledger ID an these were included into the reports prior to my assignment on this project. I have excluded these from the trial balance report and detailed general ledger report.

    And it worked, forgive me as there is no support for the system where I work and I am new to Microsoft SL.

    The trail balance did not balance so I am working on this at the moment.

    Is there an easy way to extract the detail general ledger highlighting the double entry for each transaction?

  • CFROTON Profile Picture
    4,710 on at
    RE: SL 7.0 Trxs with dates 01-01-1900

    Dear Sandy,

    I asked a financial specialist. Note that version 7 is no longer supported, I did a quick check for a bug in that version and I don't find anything that would "set the date to null" while entering a transaction.

    You had an earlier post that sounded like someone had "deleted" detail, I don't know enough about the process to know if it will set any tran date to null...

    It sounds like you are saying there are gl transactions being created that are not or have not updated account history.  The only information  provided was the date of these transactions is blank (1900/01/01).  We would need more information than that.  Is there a crtd_prog,  lupd_prog, (there is also a crtd_datetime and lupd_date time) or a batnbr?  Maybe a module or journal type?

     

    If they didn’t update the accthist balances, and there is apparently no problem with the accthist balances, I would see no harm in deleting these transactions, but I would want to know a little bit more about them.  Where they came from.  When they were created.  What module or process created them.  Etc.

     Best Regards,

    Jana MacDonald

    Microsoft Dynamics SL

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,034 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans