Share
ReportHi,
Please suggest me how to delete data in microsoft dynamics nav 2013 r2.
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi,
Please suggest me how to delete data in microsoft dynamics nav 2013 r2.
*This post is locked for comments
Caution: This response is only to be used by an experienced Database Administrator!
To delete all the records in a table your Database Administrator can do so by using the TSQL DML Statement "DELETE"
msdn.microsoft.com/.../ms189835.aspx
The following example would delete all records from the Sales Header and Sales Line tables because a WHERE clause is not used to limit the number of rows deleted. This will remove all Document Types including Quotes, Orders, Return Orders, (there are 6 total document types in the Sales Header & Sales Line table):
DELETE FROM Sales Header
GO
DELETE FROM Sales Line
GO
You can limit the types of documents deleted by using a WHERE statement. The following would delete all of the Sales Orders from the Sales Header table, but would leave the Quotes, Return Orders, Blanket Orders, and other documents in that same table:
DELETE FROM Sales Header
WHERE [Document Type] = 1
GO
The types of Documents in this table are as follows:
0 = Quote
1 = Order
2 = Invoice (unposted)
3 = Credit Memo (unposted)
4 = Blanket Order
5 = Return Order
Deleting Sales Orders from the Sales Header & Sales Line tables can be done as long as the Orders have been Archived. However, your Database Administrator has to do the back-end research and testing in a test environment, and they will need to take responsibility for any damage done to your system.
*I cannot take responsibility for how you use the available TSQL DML Statements.
Mr. Chandrasekara we will create new database and have a fresh start.
Is there any specific reason for delete data?
If you want to start from fresh, best method is to create a new company and use rapid start packages as mohana mentioned.
Deleting data will cause some problems in the system in long run. Best method is start with a new company.
1. you can create new company and insert the data from existing company using rapid start packages. please search for more info regarding rapid start packages.
2. try this blog
www.olofsimren.com/record-deletion-tool-for-dynamics-nav-2015
Sir we want to delete all our data like sales order ,purchase order, all voucher entry etc.
what type of data?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (