Cleanup of Inventory not clearing all stock when 0 are on hand

In the settings of the scheduled tasks there is the option how often and for which sites you want to perform this task.

Furthermore at the bottom you can find the option to exclude some specific location types.

Make sure that the option with “No” is selected and the Days before current date is set to your wanted clearing date.

In our configuration we are clearing all 0 values from the stock everyday from yesterdays transactions.

Best regards,

Thomas

From the Documentation the following criteria should be applicable to the job:

Once you run the record you should be able to see that inventory part records with on-hand quantity of zero and a last transaction date prior to the number of days specified in the Days Before Current Date field, are removed from the Inventory Part In Stock, Receive Inventory Part and the Issue Inventory Part windows.

On the screenshot from above Ive seen that the frozen Checkbox = FALSE.

Also that the last transaction date of those records are quite old.

One try would be to start the job manually with an offset of 400 to see if there is a restriction of the maximum date of the past, the job is considering