News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) how is the best way to...

Microsoft Dynamics GP (Archived)

how is the best way to clean out a test db of transactions so I can use it as a live company

(0) Share

Report

Report

Posted on by Community Member

Is there an easy way to delete all practice transactions from a test db?

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: how is the best way to clean out a test db of transactions so I can use it as a live company

This tech note may help.

groups.google.com/forum
Community Member on at

Like (0)

Report

RE: how is the best way to clean out a test db of transactions so I can use it as a live company

Dynamics GP >> Maintenance >> Clear Data. Pick the transaction tables you want to clear and voila! I recommend a check links / reconcile after if you're clearing a lot of data to make sure you got all the related tables in case you miss some. -Trevor
sueconrod 337 on at

Like (0)

Report

RE: how is the best way to clean out a test db of transactions so I can use it as a live company

From now on once you have a test company all set up. Do a Back up and later you can recover the backup at any time on your server and be back to a clean company.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans