Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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!

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Unable to purge Project Detail

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to purge Project Detail

    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
    RE: Unable to purge Project Detail

    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

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans