Forum Discussion
Projecting Inventory to Expire based on forecast
Hi everyone! Posting this question for my inventory tracking project. Summary: I would like to build a tracker/dashboard to track my inventory expiration risks based on forecasted usage. In...
hi, since Anonymous ist not active I will try to put some logic.
Expiration date should pe a parameter until when the goods can be used.
In case that FC qty. until the expiration day is lower than stock on hand, you will end up with excessive stock that has to be evaluated. In this case from the day of expiration you need to switch to the next exp. date batch of the same product if existing and continue to supply according to the forecast.
In the opposite case where FC qty. ist higher than qty. expirarion day simply switch to next batch if available when stock ist utilised.
Hope it helps. br Mila
Anonymous thank you so much for your response.
Your logic makes sense. The next challenging part is how will the dax be around this logic?