I have SO that need to be filled immediately and SO to be fulfilled at a later date, when checking stock status reports it shows the stock levels based on all sales orders.
I want to see my current demand and future demand separately, so that I can see at a glance if my inventory level is sufficient to fill current demand orders and not get confused by future demand orders.
Is there a solution how to do it?
Best answer by lauraj46View original
There is not anything currently out of the box that would provide that.
Have you thought of using the Sales Orders Inquiry and using Filters on that? You could filter by Status of Orders or other things to get what you are looking for.
I don't think the Sales Orders Inquiry would help me with this.
my issue is with inventory status reports it messes up my numbers showing that i don't have quantities available while I do have enough to cover my currant demand there are just a few sales orders booked for next month which will be fulfilled with new inbounds, I would like to see within SO Booked how many pieces are needed for immediate fulfilment and how many needed for future fulfilment.
Any solution will be appreciated.
To add to the suggestion by
@kandybeatty49 , I would suggest including SOLine in a Generic Inquiry to find the inventory item, open quantity, and ship date for each line on the order. Use the DateDiff function in a formula to calculate the difference between today and ShipDate (e.g. =DateDiff(‘d’, [SOLine.ShipDate], TodayUTC()). Then you can sort filter on this calculated field to see the requirements for a particular timeframe.
Hope this helps!