Intercompany and Direct Delivery orders are significantly contributing to the growth of customer's database, leading to usage overruns beyond the threshold.

Currently, there is no functionality to archive or clean up these types of orders, which limits customer's ability to manage database size effectively.

To address this, a propose developing a feature that allows for the archiving or clean-up of Intercompany and Direct Delivery orders. This feature should include criteria for archiving orders, such as orders older than a certain date or orders that have been fully processed and closed alongside the Inventory archival and not being allowed for data archival with intercompany chain linked to sales orders.

Additionally, an automated process should be implemented to periodically archive orders based on the defined criteria, along with a manual archiving option for users. It is also essential to ensure that archived orders can be easily retrieved if necessary for auditing or reference purposes.

Furthermore, a clean-up function may be developed to remove unnecessary data from the database, reducing its size and improving performance.

Implementing this archiving and clean-up function will help manage database growth, improve system performance, and ensure compliance with data retention policies.

However, it is important to note that addressing this issue will require additional resources and an increase in system resource requirements.

The impact of this issue is particularly significant for retail operations, where efficient database management is crucial for smooth functioning.