Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
The customer needs to delete a site that was created by error, which has no on-hand inventory or past transactions associated with it.
Reason:
This arises when a site is mistakenly created in the production environment, leading to the need for its deletion to prevent users from creating transactions against it.
Resolution:
- Confirm that the site and warehouse have not been used in any transactions.
- If they have not been used, consider the following options for deletion:
- Manual Deletion: Remove any references to the site and warehouse in related tables, ensuring no dependencies exist.
- Data Management Framework: Use the Data Management Framework to export the relevant data entities, manually remove the unwanted records, and then re-import the cleaned data. This method requires careful handling to avoid data integrity issues.
- Custom Cleanup Script: Develop a custom script to identify and delete the specific records related to the site and warehouse. This script should be thoroughly tested in a non-production environment before execution in production.
- If the Inventory dimension cleanup job was attempted but failed, check for any installed extensions that may affect the process. Uninstall any extensions and retry the cleanup job.
- For further assistance, utilize the X++ Zero Downtime Tool as per the Microsoft documentation to facilitate the removal of the site and warehouse.