Using the IN Populate Usage Desktop Application Engine Process

Use the Usage Desktop inquiry pages to view summarized item usage information. When you run the IN Populate Usage Desktop process to update this information, the system:

  • Determines each period or month's start and end dates.

  • Determines the on-order quantity for the item, based on:

    • Interunit transfers.

    • Purchase orders (and requisitions when selected), if PeopleSoft Purchasing is installed.

    • Production orders (including co- and by-products when selected), if PeopleSoft Manufacturing is installed.

Note: The system calculates and stores quantities using the item's standard UOM for the PeopleSoft Inventory business unit.

  • Calculates the usage quantity totals for each period and stores the data in the IN_ITM_MTH_USG table.

  • Calculates the monthly quantities for internal and external customers based on shipment transactions (transaction groups 024, 030 − 036) and stores the data in the IN_ITM_SHIP_DTL table.

  • Calculates the periodic usage totals by transaction group and stores the data in the IN_ITM_TRAN_QTY table.

    Transactions that decrease on-hand inventory are considered positive usage (+), and transactions that increase the on-hand quantity are considered negative usage (-). The following transactions are included in the summarization:

    • 024 − Customer Returns (-)

    • 026–Expensed Issue Return (-)

    • 030 − Issues (+)

    • 031 − Inter Business Unit Issue (+)

    • 032 − Non Stock Shipments (+)

    • 034 − Shipments on behalf of other business unit (+)

    • 035 − InterCompany Shipment (+)

    • 036 − Interunit Expensed Issue (+)

    • 037 – VMI InterUnit Shipment (+)

    • 038 – VMI Consumption (+)

    • 040 − Physical Accounting (Negative Adj = +; Positive = –)

    • 041 − Cycle Count Adjustments (Negative Adj = +; Positive = –)

    • 042 − IBU Transfers Adjustments (Negative Adj = +; Positive = –)

    • 050 − Adjustments (Negative Adj = +; Positive = –)

    • 051 − Inventory Scrap (+)

    • 052 − Shipping Adjustment (+)

    • 053 – Floor Stock Issues/Ret (Adjust Type : Misc Issue = +; Adjust Type: Misc return = –)

    • 220 − Component Kit (+)

    • 221 − Route to Production Kit (+)

    • 230 − Component Consumption (+)

Note: The system does not provide transaction history detail for the Route to Production Kit transaction (221), because that transaction is not included in the PeopleSoft Inventory tables.

Note: The IN Populate Usage Desktop process is associated with the process group INALL. It can run on both the client and the server.