Testing to Live - Data Cleaning.
JAYESH
Member Posts: 290
HI Experts,
I want to know which is the best way to clean data from all tables.
I have Navision SP3. I found one form called Implementation in that form last tab is data cleaning. but when i click on clean up button in form to clean up data it shows me license message.
I want to clean only posting data like item ledger, warehouse entry etc.
Thank you
I want to know which is the best way to clean data from all tables.
I have Navision SP3. I found one form called Implementation in that form last tab is data cleaning. but when i click on clean up button in form to clean up data it shows me license message.
I want to clean only posting data like item ledger, warehouse entry etc.
Thank you
JAYESH PATEL
0
Comments
-
JAYESH wrote:HI Experts,
I want to know which is the best way to clean data from all tables.
I have Navision SP3. I found one form called Implementation in that form last tab is data cleaning. but when i click on clean up button in form to clean up data it shows me license message.
I want to clean only posting data like item ledger, warehouse entry etc.
Thank you
Hi Jayesh,
The data cleaning routine available in version 4 does part of this for you. A no of tables are not cleaned out though e.g. Bank Ac Ledger and of course any custom tables that you have.You can add these to the Data cleaning codeunit to have them included as well.
The No Series -Last No Used is also not reset . Is this for a Live deployment?0 -
HI Thanx for the information
Yes this is for live Project.
Then what is the best way to clean all data ?JAYESH PATEL0 -
JAYESH wrote:HI Thanx for the information
Yes this is for live Project.
Then what is the best way to clean all data ?
After you feel that your setup is complete ,do a backup and keep this as the start template. If you notice any setup related errors during testing ,just note them down so you correct them in the clean company when ready for start...
Others may of course be using different methods , this is just one of mine...
0 -
ThanxJAYESH PATEL0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions