News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) How can I purge legacy...

Microsoft Dynamics SL (Archived)

How can I purge legacy projects?

(0) Share

Report

Report

Posted on by Jeanne Fischer

207

I want to purge several old projects but when I run analysis I get message the projects contain record(s) in the invoice detail table (PJINVDET) with a selected or unbilled status. These projects were started in legacy system with summary information imported into DSL. Checking the detail shows offsetting entries resulting in -0- balance. Can I change the entry values to -0- through SQL? If so, what other tables would I need to adjust?

DSL version 7, SQL 2009 R2.

Jeanne Fischer

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Jana Glaser-MacDonald on at

Like (0)

Report

Re: How can I purge legacy projects?

Dear Jeanne,

You can update the Pjinvdet.Bill_status field to B (indicating that the item has been billed.

You can update the Pjinvhdr.inv_status field to PO

the where clause on the sql statement should include the draft_num of the invoice in question.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1

Community Member 136

#2

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3

REUser 8

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans