Clean up closed and unused on-hand inventory transactions

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2


This topic does not apply to versions of Microsoft Dynamics AX 2012 prior to cumulative update 7 for AX 2012 R2.

This procedure describes how to delete closed and unused entries for on-hand inventory that is assigned to one or more tracking dimensions. Closed transactions contain the value of zero for all quantities and cost values, and are marked as closed. Deleting these transactions can improve the performance of queries for on-hand inventory. Transactions will not be deleted for on-hand inventory that is not assigned to tracking dimensions.


If you have implemented customizations in Microsoft Dynamics AX that use on-hand inventory transactions, you should carefully consider whether to delete these transactions.

Delete entries for on-hand inventory

To delete entries for serialized on-hand inventory, follow these steps:

  1. Inventory management > Periodic > Clean up > On-hand entries cleanup

  2. Optional: In the Delete if not updated for this many days field, enter the number of days in which entries have been unchanged. Entries that have been changed during this period are not deleted.

  3. Click OK.

Technical information for system administrators

If you don't have access to the pages that are used to complete this task, contact your system administrator and provide the information that is shown in the following table.



License keys

Trade and logistics

Security roles

Information technology manager

See also

On-hand inventory (form)