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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Deleting posted entries
Microsoft Dynamics NAV (Archived)

Deleting posted entries

(0) ShareShare
ReportReport
Posted on by Kord Meister 85

I have prepared a database for production with all setup, but I also use ​​it for test (I posted different documents).

I want to delete all data from posted entries tables. How I can do it on easy way?

I use Dynamics NAV 2009.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

    You can make a report. In DataItem of this report, you need to fill all tables you want to delete.

    For each DataItem, in C/AL editor, in OnPreDataItem(),  you need to write DELETEALL;

    It is important that you have partner license.

  • Kord Meister Profile Picture
    Kord Meister 85 on at

    Why I need a partner license?

  • Verified answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

    Depends of table you want to delete. More of them require partner license permissions. I guess you want to delete G/L Entry, Item Leder Entry, Customer Entry... If I am in right, these tables surely require partner license permissions.

  • Andri Wianto Profile Picture
    Andri Wianto 385 on at

    I ever saw a feature like this in NAV 4 SP3, but not in later version.

    I have tried it, and prefer to create a Database from the scratch.

    You can utilize Data Migration, and always backup your DB after setting up Setup tables, before you use it for testing purposes.

    Later, you can restore it, for Production use.

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans