Skip to main content
Solved

Inventory Future Demanded Orders


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 lauraj46

Hi @Pinny ,

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!

Laura

View original
Did this topic help you find an answer to your question?

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2158 replies
  • March 15, 2023

Hi @Pinny 

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. 

 


  • Author
  • 44 replies
  • March 16, 2023

@kandybeatty49 Thanks for your reply.

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.


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 502 replies
  • Answer
  • March 16, 2023

Hi @Pinny ,

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!

Laura


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings