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

Hi @Thomas Prügl 

The scheduled task is set to 0 days and ‘no’.

Many thanks

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

Hi @Thomas Prügl 

Unfortunately this has not cleared them either.

Thanks

Delete the task and re do it with the same parameters, had the same issue as above. I recreated the job and all lines were deleted as expected.

Did you find a solution to this?  I am having the same issue.  Most locations clear, but some will not clear.

Hi ​@TosohLBlum 

A few were stuck because they were showing on count reports as 0 and they had not been approved and cleared. For the rest, I raised a case with IFS and they ran a script through our system which removed the 0 lines as there was no way to do it myself.

Many thanks

If the transactions occur on the same day you are running the Cleanup job, you can input a negative number in Days Before Current Date field (i.e. -1).