Making Adjustments Using the Inventory Adjustment EIP

Third-party systems can stage stock quantity adjustments to PeopleSoft Inventory using the Inventory Adjustment EIP, an asynchronous service operation. Once the quantity adjustment data has been staged, the Inventory Adjustment process loads it into the system tables.

PeopleSoft delivers the service operations in PeopleSoft Integration Broker with a default status of Inactive. You must activate each service operation before attempting to send or receive data from a third-party source or another PeopleSoft system, such as CRM.

To set up this EIP within PeopleSoft Integration Broker and Enterprise Components, use the information in the table below and refer to the setup instruction in the PeopleSoft Supply Chain Management Integrations, "Implementing Integrations" topic, Setting Up Service Operations section.

Service Operation

Direction and Type

Handlers

Chunking Available?

Integrates With

INVENTORY_ADJUSTMENT

Inbound

Asynchronous

InventoryAdjustment

No

Third-party systems, such as electronic data collection systems, warehouse management systems, or PeopleSoft CRM

The Inventory Adjustment EIP (0410) can be used to integrate to electronic data collection systems, warehouse management systems, PeopleSoft CRM, or as EDI transaction that fulfills X.12 947. This EIP reports adjustments in stock quantity balances to PeopleSoft.

You use the Inventory Adjustment page to enter transaction details. When you save the transaction, PeopleSoft Inventory inserts the information into the transaction log. You then run the Inventory Adjustment process (INPVIADJ), which retrieves information from the transaction log, processes the transaction, and updates the appropriate system tables. If errors occur during the Inventory Adjustment process, use the Inventory Adjustment page to correct the errors and resubmit the transactional data.

The logic for the Inventory Adjustment transactional data is similar to that for the online Adjustments page, with the following exceptions:

  • ChartField overrides are not permitted.

  • Conditions that result in a warning when you use the Inventory Adjustments page, such as quantity increases in a suspended location, quantity decreases that result in negative quantity adjustments for restricted or rejected items, or for lots in non-inspection locations, are ignored in the Inventory Adjustments process.

    Warning messages displayed on panels are not shown on data collection transactions. If you allow negative quantity adjustments and the Display Warning Messages option is activated, no warning is generated.

Note: Third-party systems can stage stock quantity adjustments to PeopleSoft Inventory using the Inventory Adjustment EIP. Once these adjustments have been staged, the Inventory Adjustment process loads the adjustment data into the system tables.

Page Name

Definition Name

Usage

Message Definition Page

IB_MESSAGE_BUILDER

View the fields to be used by the service operation within PeopleSoft Integration Broker. In order to correctly populate the incoming data, review the message definition. This is a setup step that is not repeated for each transaction request.

Quantity Adjustment Page

BCT_INV_REQIADJ

Establish run control parameters for the Quantity Adjustment process and load quantity balance adjustment data staged by third-party applications using the Inventory Adjustment EIP. These third-party applications include electronic data collection systems and warehouse management systems.

Transaction Maintenance Page

BCT_CTL_UPD

View all electronic transactions in the transaction log (inbound staging tables) and access the detail pages that enable you to correct transaction errors.

Use the Message Definition page (IB_MESSAGE_BUILDER) to view the fields to be used by the service operation within PeopleSoft Integration Broker.

In order to correctly populate the incoming data, review the message definition. This is a setup step that is not repeated for each transaction request.

Navigation:

PeopleTools > Integration Broker > Integration Setup > Messages

This example illustrates the fields and controls on the View the fields included in the message used by the INVENTORY_ADJUSTMENT service operation. You can find definitions for the fields and controls later on this page.

View the fields included in the message used by the INVENTORY_ADJUSTMENT service operation

In order to correctly populate the incoming data, review the message definition. Message definitions provide the physical description of the data that is being sent, including; fields, field types, and field lengths. Messages do not contain any processing logic. All processing logic is defined in service operations, using service operation handlers. In this section, consider some important fields in the INVENTORY_ADJUSTMENT message.

For more information about messages, see the "Managing Messages" topic of the PeopleTools : PeopleSoft Integration Broker.

See the product documentation for PeopleTools: Integration Broker

Use the Quantity Adjustment page (BCT_INV_REQIADJ) to establish run control parameters for the Quantity Adjustment process and load quantity balance adjustment data staged by third-party applications using the Inventory Adjustment EIP.

These third-party applications include electronic data collection systems and warehouse management systems.

Navigation:

SCM Integrations > Process Transactions > Inventory > Create Batch Inventory Adjust

This example illustrates the fields and controls on the Quantity Adjustment process page. You can find definitions for the fields and controls later on this page.

Quantity Adjustment process page