1 Reply Latest reply: Mar 27, 2013 9:39 PM by 995074 RSS

    projected on hand quantity calculation logic

    960034
      Hi ,

      I am trying to extract information for projected on hand quantities.
      Here were my findings
      1. MTL_SUPPLY_DEMAND_TEMP
      this table has one column called ON_HAND_QUANTITY which stores Projected on hand quantity based on accumulating supply and Demand ( as per trm), However this table is a temporary table and data is also session specific, data will be gone once the session get closed.
      2. From Inventory user guide I got a point that "The projected on hand quantity of the item is , defined as Current Available + all future sources of supply and - all future sources of demand."

      Now my question is
      a. Is there a direct table for calculating projected on hand quantity in application.
      b. How do I calculate current available quantity then future source of suuply and future sources of demand.

      Thanks in advance
        • 1. Re: projected on hand quantity calculation logic
          995074
          Hi:

          ~ There is no direct table to get the projected inventory details.

          ~ Current on hand Qty for a given item shall be obtained from ON HAND QTY table.
          For calculating the future supply upto a patricular date, all the expected supplies such as Receipts, Jobs, Internal SO transfer, etc to be considered.

          For calculating the future demand, qty required for SO demand, forecast demand, ISO demand etc to be considered.

          Projected Inventory = Current Stock (OHQ) + Expected Supply - Expected Demand.