Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Changing the 'Data per company Property'
mbskapil
Member Posts: 43
Dear All
Live Database in my company is running on a company 'XXX' and i created a new company named 'YYY' .In 'XXX' company i altered the Item Master Property 'Data Per Company' to No .Now the problem i am facing is that if i made some changes in company 'YYY' then it is being effected in company 'XXX as well which i do not want to for this i want to change this property to Yes (Default) again, which i am not been able to since system is not allowing to . System is giving me this guideline to follow
*Export all records in the table to a file
*Delete all records from a table
*Modify the table Defination
*Import all the records from the table
but even this is not working as i am not ben able to delete the records in Item Master, Same is the case with Vendor Master and Customer Master
Live Database in my company is running on a company 'XXX' and i created a new company named 'YYY' .In 'XXX' company i altered the Item Master Property 'Data Per Company' to No .Now the problem i am facing is that if i made some changes in company 'YYY' then it is being effected in company 'XXX as well which i do not want to for this i want to change this property to Yes (Default) again, which i am not been able to since system is not allowing to . System is giving me this guideline to follow
*Export all records in the table to a file
*Delete all records from a table
*Modify the table Defination
*Import all the records from the table
but even this is not working as i am not ben able to delete the records in Item Master, Same is the case with Vendor Master and Customer Master
0
Answers
Try commenting out all code from the OnDelete-triggers in your Item, Vendor & Customer table. Now you can delete the records (but first export them or copy them to a new table).
Easiest thing to do is:
1. Create a new table ItemTemp (use SaveAs when designing table Item, to copy the table structure)
2. Create a codeunit or report to copy the records from table Item to your new table ItemTemp
3. Create a codeunit to delete all records from table Item using recItem.DELETEALL(FALSE);
4. Modify your table properties
5. Same as step 2 but now from your table ItemTemp to the table Item
Luc Van Dyck