Skip to main content

Hello,

I need to make warehouses inactive via a management event if there has been no stock movement for more than 6 months. 
Which screen do you think I should use?
Any ideas for the conditions to be set on the management event?
 

Version Flex : Version 23.1.2312.120 023.111.0026]

Thanks in advance.

I presume you mean you aim to use a Business event to make it not active. It is going to be a tricky one to achieve as you will need to look at all the inventory movements for each warehouse to see if there are any for the last 6 months. If you make the warehouse inactive and there is a quantity in any location in that warehouse you wont be able to sell it so do you need to factor the stock quantities. 

I think you will need a SQL query to create the GI to determine which warehouse is inactive and then use this to drive a business event on a scheduler

 


Hello, 

Thank you for your response.

Yes, I was thinking of creating a query to retrieve the same data from the screen warehouse (non-moving items IN405500) using the last purchase and last sale dates (> 6 months) as a condition to do a scheduled task and make these warehouses inactive, as you mentioned.

What do you think ?


Yes but be aware the  the IN405500 is not a table so may not be available in a GI so you may have to build all the logic using the transaction tables to do so.


Reply