Inventory Balance Audit SQR Reports (INS9090)
Seven reports are included in the Inventory Balance Audit reports.
Business Unit Level Balances report
The Business Unit Level Balances report compares business unit quantities calculated from balances in the storage location, demand, and putaway staging tables with quantity balances recorded in the BU_ITEMS_INV record. Any variance indicates a possible balance issue. The end of the report lists the total number of item records audited, together with the total number of item quantity variances detailed by on-hand quantity, reserved quantity, and available quantity variances. This report is included in the set of Inventory Balance Audit reports when you select the Business Unit Level Balances option on the Inventory Balance page.
If you select the Show Calc for BU Balances option on the Inventory Balance page, the first page of the Business Unit Level Balances report includes a summary of the formulas used to calculate the item quantities. The numbers in the column headings of this report reference formulas included in this summary.
If you select Show All Detail option on the Inventory Balance page, all selected items are listed on the report, regardless of whether a quantity variance exists between the recorded quantity balance and the calculated quantity balance. However, only items with quantity variances show data in the first three difference columns of the report. If you do not select the Show All Detail option, only items with quantity variances appear on the report.
This report is sorted by item ID and has the following columns:
| Field or Control | Description |
|---|---|
|
Item/Std UOM (standard unit of measure) |
Item IDs appear in ascending alphanumeric order. |
|
BU Own Qty (business unit owned quantity) /Calc Own Qty/Difference (calculated owned quantity) |
This column lists three values per item: the business unit's recorded owned quantity (BU_ITEMS_INV.qty_owned, the calculated owned quantity, and the difference between the two values. The system computes the calculated owned quantity with the formula: Calc Own Qty = Calc OH Qty less PI Non-Own – Conf Non-Own less Staged Non-Own The calculated values for the variables in this formula appear for each item in other columns of the Business Unit Level Balances report. For details about each variable, see the associated column heading documented in this section. |
|
BU OH Qty (business unit on-hand quantity)/ Calc OH Qty (calculated on-hand quantity)/ Difference |
This column lists three values per item: the business unit's recorded quantity on hand (BU_ITEMS_INV.qty_onhand), the calculated quantity on hand, and the difference between the two values. The system computes the calculated quantity on hand with the formula: Calc OH Qty = PI Base + Conf Avail + Conf Unavail + Staged Avail + Staged Unavail The calculated values for the variables in this formula appear for each item in other columns of the Business Unit Level Balances report. For details about each variable, see the associated column heading documented in this section. |
|
BU Res Qty (business unit reserved quantity)/− Calc Res Qty (calculated reserved quantity)/ Difference |
This column lists three values per item: the business unit's recorded quantity reserved (BU_ITEMS_INV.qty_reserved), the calculated quantity reserved, and the difference between the two values. The system computes the calculated quantity reserved with the formula: Calc Res Qty = Cust Resv + Conf Avail + WIP Avail + Staged Avail + Prod Resv The calculated values for the variables in this formula appear for each item in other columns of the Business Unit Level Balances report. For details about each variable, see the associated column heading documented in this section. |
|
BU Avail Qty (business unit available quantity)/− Calc Avail (calculated available)/ Difference |
This column lists three values per item: the business unit's recorded quantity available (BU_ITEMS_INV.qty_available), the calculated quantity available, and the difference between the two values. The system computes the calculated quantity available with the formula: Calc Avail = Calc OH Qty less Calc Res Qty less Conf Unavail less PI Unavail less Staged Unavail The calculated values for the variables in this formula appear for each item in other columns of the Business Unit Level Balances report. For details about each variable, see the associated column heading documented in this section. |
|
BU Qty On Hand (business unit quantity on hand)/ BU Qty Reserved (business unit quantity reserved)/ BU Qty Available (business unit quantity available) |
For each item, this column lists the values recorded in the primary quantity fields from the BU_ITEMS_INV record: qty_onhand, qty_reserved, and qty_available. |
|
PI Base / Conf Avail (confirmed available)/ Conf Unavail (confirmed unavailable)/ Staged Avail (staged available) |
For each item, this column lists the values for four variables used in the Calc OH Qty, Calc Res Qty, or Calc Avail equation. PI base represents the total stock quantity in the item's standard UOM that is recorded for each storage location in the business unit. This value is the sum of the qty_base field values for all of the item's storage location records in the PHYSICAL_INV table. Confirmed available represents the total stock quantity confirmed as picked but not depleted that has an Open inventory status and was picked from a nettable storage location. If you select the Incl Non-Open in Avail Qty option for the business unit, this quantity also includes the total stock quantity confirmed as picked but not depleted that has a Restricted status and was picked from a nettable storage location. Until the Deplete On Hand Qty (Depletion) process runs, this stock quantity is included in the business unit's quantity on hand and quantity reserved. An item's confirmed available value is derived from a joining of the DEMAND_PHYS_INV and the IN_DEMAND tables. Confirmed unavailable represents the total stock quantity confirmed as picked but not depleted that (1) has a Non-Open inventory status, with the Incl Non-Open in Avail Qty option not selected for the business unit, or (2) was picked from a non-nettable storage location. Until the Deplete On Hand Qty (Depletion) process runs, this stock quantity is included in the business unit's quantity on hand. An item's confirmed unavailable value is derived from a joining of the DEMAND_PHYS_INV and the IN_DEMAND tables. Staged available represents the total stock quantity in the item's standard UOM that was confirmed as picked, then canceled or short shipped but not put away. This quantity includes only those stock quantities that were picked from nettable locations with an inventory status of (1) Open or (2) the Restricted with the Incl Non-Open in Avail Qty option selected for the business unit. If a demand line is canceled or short shipped after the demand quantity is confirmed as picked, the canceled demand quantity or short-shipped quantity is staged for putaway processing in the STAGED_ITEM_INV table. Until the Complete Putaway process (INPPPTWY) runs, this stock quantity (recorded in STAGED_ITEM_INV.qty_base field) is included in the business unit's quantity reserved. |
|
Staged Unavail (staged unavailable)/ Cust Resv (customer reserved)/ WIP Avail (work in progress available)/ Prod Resv (production reserved) |
For each item, this column lists the values for four variables used in the Calc OH Qty, the Calc Res Qty, or the Calc Avail equation. Staged Unavail represents the total stock quantity in the item's standard UOM that was confirmed as picked, then canceled or short shipped but not put away. This quantity includes only stock picked from non-nettable locations or stock with an inventory status of Restricted and with the Incl Non-Open in Avail Qty option not selected for the business unit. If a demand line is canceled or short shipped after the demand quantity was confirmed as picked, the canceled demand quantity or short-shipped quantity is staged for putaway processing in the STAGED_ITEM_INV table. Cust Resv represents the total stock quantity in the item's standard UOM that has been lot allocated or soft reserved by the Reserve Materials process (IN_FUL_RSV) and is greater than 0 only for those items with soft reservations selected. This value is the sum of the item's qty_alloc_base field values for lot-allocated demand lines (lot_alloc_flg = 'Y') on the IN_DEMAND table. Until the Deplete On Hand Qty (Depletion) process runs, the customer reserved quantity is included in the business unit's quantity reserved. WIP Avail represents the total stock quantity in the item's standard UOM (qty_base) that is stored in work-in-progress storage locations. If the Incl Non-Open in Avail Qty option is selected for the business unit, the work-in-progress available value includes stock with Open (avail_status = 1), Restricted (avail_status = 2), and Hold (avail_status = 3) inventory status in nettable locations. If the Incl Non-Open in Avail Qty option is not selected, the WIP Avail value includes only stock quantity with an Open status in nettable work-in-progress locations. Stock quantity that is transferred to work-in-progress storage locations is considered a part of the business unit's quantity reserved, because it can be used only for production purposes. An item's work-in-progress available value is derived from a joining of the PHYSICAL_INV and STOR_LOC_INV tables, where nettable_flg = Y and wip_loc_flg = Y. Prod Resv represents the total stock quantity in non-WIP storage locations (wip_loc_flg = N) that has been reserved for production by the Material Picking Plans process (SFS6000) in PeopleSoft Manufacturing. If Incl Non-Open in Avail Qty is selected for the business unit, the Prod Resv value includes stock with Open (avail_status = 1), Restricted (avail_status = 2), and Hold (avail_status = 3) inventory status in nettable locations. If the Incl Non-Open in Avail Qty option is not selected, production reserved includes only stock quantity with an Open inventory status (avail_status = 1) in nettable (nettable_flg = Y) locations. The production reserved value is in the item's standard UOM (qty_picked) and is derived from a joining of the SF_ISS_TRANSFERS, PHYSICAL_INV, and STOR_LOC_INV tables, where stor_Loc_inv.wip_loc_flg = N and stor_loc_inv.nettable_flg = Y and physical_inv.avail_status <> 4. |
|
PI Unavail (PHYSICAL_INV unavailable) /PI Non-Own/Conf Non-Own (confirmed non-owned) /Staged Non-Own (staged non-owned) |
For each item, this column lists the values used in the Calc Available and Calc Own Qty equations. PI Unavail represents the total stock quantity stored in non-nettable storage locations (nettable_flg = N), plus the total stock quantity stored in nettable locations and having an inventory status that is not included in the business unit's available quantity. If the Incl Non-Open in Avail Qty option is selected for the business unit, PHYSICAL_INV unavail includes stock quantity in nettable locations with a Rejected inventory status (avail_status = 4). If the Incl Non-Open in Avail Qty option is not selected, the PHYSICAL_INV unavailable value includes stock quantity in nettable locations with an inventory status of Restricted (avail_status = 2), Hold (avail_status = 3), or Rejected (avail_status = 4). The PHYSICAL_INV unavailable value is in the item's standard UOM (qty_base) and is derived from a joining of the PHYSICAL_INV and STOR_LOC_INV tables. PI Non Own represents the total non-owned stock quantity in the item's standard UOM that is recorded for each storage location in the business unit. This value is the sum of the qty_base field values for all non-owned stock recorded in the item's storage location records in the PHYSICAL_INV table. Conf Non-Own represents the total non-owned stock quantity that is confirmed as picked but not depleted, has an Open inventory status, and was picked from a nettable storage location. If the Incl Non-Open in Avail Qty option is selected for the business unit, this quantity also includes the total stock quantity confirmed as picked but not depleted that has a Restricted status and was picked from a nettable storage location. Until the Deplete On Hand Qty (Depletion) process runs, this stock quantity is included in the business unit's quantity on hand and quantity reserved. The configured non-owned value is derived from a joining of the DEMAND_PHYS_INV and the IN_DEMAND tables. Staged Non-Own represents the total non-owned stock quantity in the item's standard UOM that was confirmed as picked, then canceled or short shipped but not put away. This quantity includes only those stock quantities that were picked from nettable locations and had inventory status of (1) Open or (2) Restricted with the Incl Non-Open in Avail Qty option selected for the business unit. If a demand line is canceled or short shipped after the demand quantity is confirmed as picked, the canceled demand quantity or short-shipped quantity is staged for putaway processing in the STAGED_ITEM_INV table. Until the Complete Putaway process runs, this stock quantity (recorded in STAGED_ITEM_INV.qty_base field) is included in the business unit's quantity reserved. |
Check Demand Tables for Negative Quantities report (INS9090)
The Check Demand Tables for Negative Quantities report is included in the set of Inventory Balance Audit reports when you select the Rollup of Demand Tables option on the Inventory Balance page In this report, a business unit's demand table (IN_DEMAND) is audited for negative quantities. Even in environments that permit transactions to drive business unit and storage location quantities negative, negative quantities should not exist in this table. You cannot request a negative quantity, you cannot fulfill a negative quantity, and you cannot ship a negative quantity. A negative balance in any of these tables indicates a possible balance issue.
The report is divided into three sections, one for each demand table. The total number of negative quantity balance discrepancies for each table prints at the end of each section. A summary of all discrepancies found for the demand tables, including the negative demand quantities and the roll-up discrepancies, prints on the last page of the Rollup of Demand Tables report, the other report generated when you select the Rollup of Demand Tables option.
If you select the Show All Detail option on the Inventory Balance page, the report lists all demand lines selected in the business unit, regardless of whether a negative quantity balance exists. Demand lines with negative quantity are marked with a balance error message that indicates which fulfillment transaction quantity is negative. If you do not select the Show All Detail option, only demand lines with negative quantity print.
| Field or Control | Description |
|---|---|
|
Demand Src (demand source) / Source BU (source business unit) |
This column lists two of the eight key fields for the demand line: the demand source and the business unit ID of the demand source. Demand source is a two-letter identifier indicating how the demand was generated. Values are: IN: Demand entered using the Create/Update Stock Request component and the Create Par Replenishment Requests process (INPGCDMD) in PeopleSoft Inventory. OM: Demand entered using the sales order entry pages in PeopleSoft Order Management. PL: Demand from a planning requisition message originating in PeopleSoft Supply Planning and entered by the Apply Planning Messages process. PO: Demand created from the PeopleSoft Purchasing sourcing process, which checks a defined Distribution Network to secure needed stock across PeopleSoft Inventory business units. The PO demand source code is also used to identify miscellaneous demand from such PeopleSoft Inventory sources as external uploads or par location replenishment requests. PR: Demand created directly from a purchase requisition originating in PeopleSoft Purchasing. RT: Demand based on a return-to-supplier request originating in PeopleSoft Purchasing. SF: Demand created by a production request originating in PeopleSoft Manufacturing. |
|
Order Number/Item |
This column lists two of the eight key fields for the demand line: the order number and the item ID. |
|
Order Line/Sched Line (schedule line) |
This column lists two of the eight key fields for the demand line: the order line number and the schedule line number. |
|
Dem Ln (demand line) |
This column lists one of the eight key fields for the demand line: the demand line number. Any number greater than 1 indicates a backorder. |
|
Qty Requested (quantity requested)/ Qty Backordered (quantity backordered) |
This column lists two quantity values for demand lines in the IN_DEMAND table: the quantity requested (qty_requested) in the ordering UOM and the portion of the requested quantity that was backordered (qty_backorder) in the ordering UOM. If a negative quantity exists in either of these fields, an error message prints in the last column of the report. |
|
Qty Allocated (quantity allocated)/ Qty Allocated Std (quantity allocated in the standard unit of measure) |
This column lists two quantity values for demand lines in the IN_DEMAND table: the quantity allocated (qty_allocated) in the ordering UOM and the quantity allocated in the item's standard UOM (qty_alloc_base). If a negative quantity exists in either of these quantity fields, an error message prints in the last column of the report. |
|
Qty Picked (quantity picked) / Qty Picked Std (quantity picked standard UOM) |
This column lists two quantity values for demand lines: the quantity picked (qty_picked) in the ordering UOM and the quantity picked in the item's standard UOM (qty_pick_base). The quantity picked (qty_picked) and the quantity picked in the standard UOM (qty_pick_base) are listed on the IN_DEMAND table. If a negative quantity exists in either of these fields, an error message prints in the last column of the report. |
|
Qty Shipped (quantity shipped)/ Qty Shipped Std (quantity shipped standard)/Qty Shipped Conv (quantity shipped converted) |
This column lists three quantity values for demand lines in the IN_DEMAND table: the quantity shipped in the item's ordering UOM (qty_shipped), the quantity shipped in the item's standard UOM (qty_ship_base), and the quantity shipped in the item's converted UOM (Qty_Shipped_Conv). If a negative quantity exists in any of these fields, an error message prints in the last column of the report. |
|
Last Qty Shipped (last quantity shipped)/Last Qty Ship Base(last quantity ship base)/ Std Ord Shp (UOM) |
This column lists two values for the demand lines in the IN_DEMAND table: the quantity requested that has been shipped less any undershipment quantity that was putaway (LAST_QTY_SHIP) and the quantity requested that has been shipped less any undershipment quantity that was putaway, expressed in the item's standard UOM (LAST_QTY_SHIP_BASE). Std Ord Ship (UOM) displays the standard, ordering, and shipping UOM for these quantities. |
|
Messages |
This column lists an error message indicating that a negative quantity value exists for the demand line, if applicable. |
Check Storage Locations for Negative Balances report (INS9090)
The Check Storage Locations for Negative Balances report is included in the set of Inventory Balance Audit reports when you select the Storage Location Balances option on the Inventory Balance page In this report, the storage location records in the PHYSICAL_INV table are audited for negative quantities. A negative value in the qty_reserved and qty_reserved_base fields indicates a discrepancy. These values should never be negative in any business unit. If a business unit does not permit transactions to drive business unit and storage location quantities negative, negative balances in the qty and qty_base fields also indicate a discrepancy. However, for those business units that do permit transactions to drive business unit or storage location quantities negative, negative values may legitimately exist in the qty and qty_base fields.
If you select the Show All Detail option on the Inventory Balance page, the report lists all items regardless of whether negative balances exist in the storage location. If you leave the Show All Detail check box clear, only items with invalid negative quantities appear.
At the end, the report lists the number of storage locations audited and the total number of negative quantity values found in PHYSICAL_INV.
This report is sorted by item ID and has the following columns:
| Field or Control | Description |
|---|---|
|
Item/Std UOM (standard unit of measure) |
Item IDs are listed in ascending alphanumeric order. |
|
Lot/Container ID |
This column lists two values: the lot IDs for each item and the container ID, if applicable. If the item is not lot controlled, the report lists the default value established on the Installation Options - Inventory page. |
|
Serial ID/Staged Date |
This column lists two values: serial ID and staged date. If the item is serial controlled, the report lists the serial ID for each unit. If the item is not serial controlled, the report lists the default value established on the Installation Options - Inventory page. If the item is staged date controlled, the report lists the staged date for the item. If the item is not staged date controlled, the report lists the default value established on the Installation Options - Inventory page. |
|
Area, Lev1, Lev2, Lev3, and Lev4 |
These five columns define the item's storage location. |
|
Phys Inv Qty Std |
This column displays negative values found in the PHYSICAL_INV.qty_base field. The report process checks the setting that allows negative quantities, which was established for the business unit on the Inventory Definition - Business Unit Options page. If you do not select the Show All Detail option on the Inventory Balance Report page, only negative quantities found for business units that do not allow transactions to drive storage location quantities negative are printed. In this case, any negative balance printed in this column indicates a quantity discrepancy. When you select the Show All Details option, all balances are printed, regardless of whether negative balances exist in the storage location. |
|
Phys Inv Res Std |
This column displays values found in the PHYSICAL_INV.qty_reserved_base field. Any negative balance printed in this column indicates a quantity discrepancy. |
|
Phys Inv Qty |
This column displays negative values found in the PHYSICAL_INV.qty field. The report process checks the setting that allows negative quantities, which was established for the business unit on the Inventory Definition - Business Unit Options page. If you do not select the Show All Detail option on the Inventory Balance Report page, only negative quantities found for business units that do not allow transactions to drive storage location quantities negative are printed. In this case, any negative balance printed in this column indicates a quantity discrepancy. When you select the Show All Details option, all balances are printed, regardless of whether negative balances exist in the storage location. |
|
Phys Inv Qty Res |
This column displays values found in the PHYSICAL_INV.qty_reserved field. Any negative balance printed in this column indicates a quantity discrepancy. |
See Understanding Inventory Material Storage Structures.
Lot-Controlled Item Balances report (INS9090)
The Lot-Controlled Item Balances report is one of two reports included in the set of Inventory Balance Audit reports when you select the Lot Level Balances option on the Inventory Balance page. In this report, a business unit's lot-quantity balances are calculated from balances in the PHYSICAL_INV table. The calculated business unit lot quantities are compared with the quantity balances recorded in the LOT_CONTROL_INV table. Any variance indicates a possible balance issue.
If you select the Show All Detail option on the Inventory Balance page, the report lists all selected lot-controlled items, regardless of whether a quantity variance exists between LOT_CONTROL_INV and PHYSICAL_INV. Items with quantity variances are marked with a balance error message. If you do not select the Show All Detail option, only items with quantity variances print; no balance error message appears.
At the end, the report lists the number of lot records audited, the number of lot-record variances found, and the number of storage locations audited.
This report is sorted by item ID and has the following columns:
| Field or Control | Description |
|---|---|
|
Item |
This column lists the lot-controlled item IDs in ascending alphanumeric order. |
|
Lot |
This column lists the lot IDs for each item in ascending alphanumeric order. |
|
Lot Status |
This column lists the lot status (LOT_CONTROL_INV.avail_status ) of the lot-controlled item: 1 = Open 2 = Restricted 3 = Hold 4 = Rejected |
|
Qty On Hand (quantity on hand)/ − Calc OH Qty (calculated on-hand quantity)/ Difference |
This column lists three values per item: the business unit's recorded lot quantity on hand (LOT_CONTROL_INV.qty_onhand), the calculated quantity on hand, and the difference between the two values. The calculated quantity on hand is the sum of the qty_base field values for lot-controlled items in the PHYSICAL_INV table. |
|
Qty Allocated (quantity allocated)/ − Calc Allocations (calculated allocations)/ Difference |
This column lists three values per item: the business unit's recorded lot quantity allocated (LOT_CONTROL_INV.qty_allocated), the calculated quantity allocated, and the difference between the two values. The calculated quantity allocated is the sum of the qty_reserved_base field values for lot-controlled items in the PHYSICAL_INV table, where the lot-controlled item has an Open status (PHYSICAL_INV.avail_status = 1) and the storage location is nettable (STOR_LOC_INV.nettable_flg = Y) and non-WIP (STOR_LOC_INV.wip_loc_flg = N). |
|
Qty Available (quantity available)/ − Calc Avail (calculated quantity available)/ Difference |
This column lists three values per item: the business unit's recorded lot quantity available (LOT_CONTROL_INV.qty_available), the calculated lot quantity available, and the difference between the two values. The calculated lot quantity available is the sum of the PHYSICAL_INV.qty_base field values minus the sum of the PHYSICAL_INV.qty_reserve_base field values, where the lot-controlled item has an Open status (PHYSICAL_INV.avail_status = 1) and the storage location is nettable (STOR_LOC_INV.nettable_flg = 1) and non-WIP (STOR_LOC_INV.wip_loc_flg = N). |
|
Qty On Hand (quantity on hand)/ Qty Allocated (quantity allocated)/ Qty Available (quantity available) |
This column lists three values per item: the business unit's recorded lot quantity on hand (LOT_CONTROL_INV.qty_onhand), the business unit's recorded lot quantity allocated (LOT_CONTROL_INV.qty_allocated), and the business unit's recorded lot quantity available (LOT_CONTROL_INV.qty_available). |
See Understanding Inventory Status.
Missing Lot Master Records report (INS9090)
The Missing Lot Master Records report is one of two reports included in the set of Inventory Balance Audit reports when you select the Lot Level Balances option on the Inventory Balance page. This report lists any lot-controlled items that have a record in the PHYSICAL_INV table but not in the LOT_CONTROL_INV table. The total number of lot records missing from LOT_CONTROL_INV prints at the end of the report.
Note:
If a lot-controlled item record is missing from the LOT_CONTROL_INV table, its quantity balance is not audited in the Lot-Controlled Item Balances report.
This report is sorted by item ID and has the following columns:
| Field or Control | Description |
|---|---|
|
Item |
This column lists the item IDs in ascending alphanumeric order. |
|
Lot |
This column lists the lot IDs for each lot-controlled item in ascending alphanumeric order. |
|
Staged Date |
If the item is staged date-controlled, this column lists the date that the item was staged for putaway processing (the date that the Load Staged Items process inserted the item record into the STAGED_ITEM_INV table.) If the item is not staged date-controlled, this column lists the default value established on the Installation Options - Inventory page. |
|
Serial ID |
If the item is serial controlled, this column lists the serial ID for each unit. If the item is not serial controlled, this column lists the default value established on the Installation Options - Inventory page. |
|
Area, Lev 1, Lev 2, Lev 3, and Lev 4 |
The storage location for each lot-controlled item. |
|
Phy Inv Qty Base |
The amount of lot-controlled stock in the storage location, in the item's standard UOM. This is the value recorded in the qty_base field in the PHYSICAL_INV table. For serial-controlled units, this value should always be 1. |
Rollup of Demand Tables report (INS9090)
The Rollup of Demand Tables report is one of two reports included in the set of Inventory Balance Audit reports when you select the Rollup of Demand Tables option on the Inventory Balance page. This report compares the quantity confirmed as picked for a demand line (IN_DEMAND.qty_pick_base) with the sum of the quantities picked across all storage locations for the demand line (DEMAND_PHYS_INV.qty_base). These values should match; any variance indicates a possible balance issue.
If you select the Show All Detail option on the Inventory Balance page, the report lists all selected demand lines in the business unit, regardless of whether a quantity variance exists. Demand lines with a variance are marked with an error message. If you do not select the Show All Detail option, only demand lines with variances print.
At the end of each roll-up section, the report lists the total number of discrepancies found. A summary of all discrepancies found for the demand tables, including the roll-up discrepancies and the negative demand quantities, prints on the last page of the report.
| Field or Control | Description |
|---|---|
|
Demand Src (demand source)/ Source BU (source business unit) |
This column lists two of the eight key fields for the demand line: the demand source and the business unit ID of the demand source. Demand source is a two-letter identifier indicating how the demand was generated. Values are: IN: Demand entered using the Create/Update Stock Request component and the Create Par Replenishment Requests process in PeopleSoft Inventory. OM: Demand entered using the sales order entry pages in PeopleSoft Order Management. PL: Demand from a planning requisition message originating in PeopleSoft Supply Planning and entered by the Apply Planning Messages process. PO: Demand created from the PeopleSoft Purchasing sourcing process, which checks a defined Distribution Network to secure needed stock across PeopleSoft Inventory business units. The PO demand source code is also used to identify miscellaneous demand from various PeopleSoft Inventory sources, such as external uploads or par location replenishment requests. PR: Demand created directly from a purchase requisition originating in PeopleSoft Purchasing. RT: Demand based on a return-to-vendor request originating in PeopleSoft Purchasing. SF: Demand created by a production request originating in PeopleSoft Manufacturing. |
|
Order Number/Item |
This column lists two of the eight key fields for the demand line: the order number and the item ID. |
|
Order Line/Sched Line (schedule line) |
This column lists two of the eight key fields for the demand line: the order line number and the schedule line number. |
|
Dem Ln (demand line) |
This column lists the demand line number. Any number greater than 1 indicates a backorder. |
|
Qty Picked (IN_DEMAND.qyt_pick_base)/ Qty Picked Std (DEMAND_PHYS_INV.qty_base) |
This column lists the picked quantity in the item's standard UOM from the IN_DEMAND table and the DEMAND_PHYS_INV table. |
|
Last Qty Ship Base (IN_DEMAND.last_qty_ship_base)/ Calculated Last Quantity Ship (DEMAND_PHYS_INV. last_qty_ship_base)/ Difference |
This column lists the last quantity shipped in the item's standard UOM from the IN_DEMAND table, the DEMAND_PHYS_INV table, and the difference between them. This value is calculated as the quantity requested that has been shipped minus any undershipment quantity that was putaway. |
|
Std UOM |
Displays the item's standard UOM. |
|
Messages |
If a difference exists between the compared quantity values, a message prints in this column to indicate a roll-up error. |
Location Reserved Quantity report (INS9090)
The Location Reserved Quantity report compares the demand line quantity reserved balances (DEMAND_PHYS_INV and SF_ISS_TRANSFER tables) against the quantity reserved in the storage location levels of the business unit (PHYSICAL_INV table).
The demand table quantities are those items that have been picked or allocated from a storage location and not necessarily if the order has been reserved using the Reserve Materials process. When you generate a push or pull picking plan, the Production Picking Plan process (SFS6000) inserts demand line records in the SF_ISS_TRANSFER table. Pull picking plans do not record the picking location information in the table. When you specify picking line information for pull picking plans using the Review Plan page and save the page, picking location records are inserted into SF_ISS_TRANSFER. Rows get deleted from SF_ISS_TRANSFER when the material is released to production or the work-in-progress location (or if the user deletes the pick lines). When the material is released the quantities are unreserved in PHYSICAL_INV and BU_ITEMS_INV
If you select the Show All Detail option on the Inventory Balance page, the report lists all selected reserved quantities in the business unit, regardless of whether a quantity variance exists. Reserved quantities with a variance are marked with an error message. If you do not select the Show All Detail option, only demand lines with variances print.
This report is sorted by item ID, staged date, lot ID, serial ID, storage area, and then storage location levels.
| Field or Control | Description |
|---|---|
|
Area, Lev 1, Lev 2, Lev 3, and Lev 4 |
Identifies the material storage location of the reserved quantities in PHYSICAL_INV. |
| Field or Control | Description |
|---|---|
|
Location Reserved Quantity |
The total of reserved quantity from the material storage locations of the business unit. This is from the QTY_RESERVED field on the PHYSICAL_INV table. |
| Field or Control | Description |
|---|---|
|
Calc Reserved Quantity |
The total quantity reserved to specific storage locations to fulfill demand lines in the DEMAND_PHYS_INV and SF_ISS_TRANSFER tables. |
|
Difference |
Displays any difference between the reserved quantity from the PHYSICAL_INV table and the DEMAND_PHYS_INV and SF_ISS_TRANSFER tables. |