i have to load the new customer data to AX. i want to wipe the existing customer records, how can i delete all customer in one shot?
Highlight all the customers and press delete. If you have any related transactions or data of course this would not be allowed
i have 170000 customer records. by deleting from Thick client it will take long time. how to do it by code/any in built class. i have wiped all transnational data for the Customer. Now i have to delete the customers. Please help
Deleting the customers would also require the deleting the data that was build with the customer data,
Example: Dimension attribute, business relations …
Look at custTable.delete();
You may also need to decide whether you are going to keep the party information after this delete. This is parameter driven
If you look at the delete, you get more info.
I would suggest to have a code that calls the custTable.delete() and will be running on a server or in a batch.
i would like to delete all records related to Customers like addresses, contacts information also. What is the best way to code to delete one after other and how? thanks for reply
Looping through all the customers and calling the delete on custTable would probably delete all its related information.
delete handles the delete of party information and deleting the party internally deletes the postal address stuff.
You can test that with a single record to get it confirmed.
i tried calling for one customer Delete. But i still see the records for that customers in related table DirPartyTable and DirPartyLocation. Is there any way to delete related data also? Please reply Thanks
Would they have deleted by now from the client? [:D]
You will have to keep writing code and deleting related tables and keep testing it if you are doing this through a job.
Is “Delete parties with no roles” parameter enabled in Global address book parameters?
i checked the field checkbox. Now it is deleting related data. Thanks