Projected stock for all raw materials

SOLVED

Hello Community! 

My company has a large database of raw materials, currently the purchasing plan is done manually using MRP results along with checking Projected for each raw material , one at a time. As such it's a very tedious and inefficient process at the moment. Thus, is there any way where we'll be able to view projected stock for the entirety of the raw materials on the same screen ( either on the interface or using queries) ?

I am open to other suggestions, if any, that can facilitate the task.

Thank you in advance,

Top Replies

Parents Reply
  • +1 in reply to Hana amamou
    verified answer

    Hi  

    So you tried to build a function to view the projected stock for all components required in a selection of work orders.

    I am correct, then I confirm this is not a standard function but you ca try to set a query or report to do this. You would need to startt with MFGHEAD table to base your filter and then linked MFGMAT to identify corresponding materials and next would be ORDERS & ITMMVT to calculate the projected stock. I am not 100% sure would be possible using standard query but I am fairly confident this would be possible using an SQL query. 

Children