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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Unable to purge Projec...
Finance | Project Operations, Human Resources, ...
Unanswered

Unable to purge Project Detail

(0) ShareShare
ReportReport
Posted on by Community Member

Client has a number of projects they'd like to purge and have set the status to Purge. Running the Delete Project Detail process (Project tab), we receive a list of errors similar to these for the projects: 

Analysis of project V20101 beginning

Transaction record(s) (PJTRAN) exist for project V20101 that are equal to or greater than the current fiscal year 201910

Analysis of project V20102 beginning

Transaction record(s) (PJTRAN) exist for project V20102 that are equal to or greater than the current fiscal year 201910

Even selecting the Purge Projects with warnings does not remove them. I ran the below script in SQL and received no records:

SELECT PROJECT, * FROM PJTRAN WHERE fiscalno >= '201910' AND PROJECT LIKE 'V%'

Finally, I tried Initialize mode to no avail. Any suggestions on what could be causing this?

Thanks!

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

    Dear Stuart,

    What is the current fiscal year?

    Did you try the select directly to pull all the transactions? Order by fiscalno and see what we get.

    Best Regards,

    Jana MacDonald

    MSDSL Support

  • Community Member Profile Picture
    Community Member on at

    Good afternoon, Jana. Nice to see you.

    Yes, I did the query directly for both of the projects noted above. The current fiscal year is 2019 with a current period of 10-2019. All of the records in PJTran for these projects were less than 201910. These were both small projects so there weren't many transactions involved.

    As noted above, I checked the option to delete projects with warnings. Shouldn't that have set the flag to delete?

    Thanks!

  • CFROTON Profile Picture
    CFROTON 4,710 on at

    Dear Stuart,

    Yes it should have set it to delete, if its only a warning. But it won't do that if its an "error" it may consider this an error because it thinks there are records. I'm speculating.

    But go to the Help file for that screen and look at Delete Project Detail Historical Purge -Error Conditions that block a purge

    Perhaps we should run a trace to see if we can catch exactly what its finding on that project.

    Best,

    Jana

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans