Creating and Using VMI Enterprise Integration Points

Page Name

Definition Name

Usage

VMI QOH and Inventory Adjustment Page

BCT_INV_VMI_QOH

Enter quantity adjustments to VMI stock manually or by using an electronic data collection (EDC) device.

VMI Quantity On Hand Page

BCT_IN_VMI_QOH

Define the run control parameters and launch the VMI Quantity On Hand process (VMI_QOH_EIP) by selecting SCM Integrations > Process Transactions > VMI Quantity On Hand Report.

This process retrieves third-party data from the transaction logs and post the data into the Inventory application tables. This data includes the current quantity on hand (QOH) for stock located at a customer site. The VMI Quantity On Hand process creates any adjustments necessary to update the PeopleSoft Inventory QOH balances. The third-party data can be loaded into the transaction logs by the VMI Quantity On Hand EIP or the VMI Inventory Adjustment EIP.

InterUnit Receiving Page

BCT_INV_IURCV

Enter interunit receipts for VMI stock manually or by using an EDC device.

Inventory IU Receipts Page

BCT_INV_REQIURV

Process interunit receipts for VMI stock by selecting SCM Integrations > Process Transactions > Inventory > Create Batch Interunit Receipt.

This process loads receipt quantities from third-party applications.

VMI Interunit Expected Receipts Page

IN_RUN_SHPVMI_IU

Publish the VMI Expected Receipts EIP for interunit transfer orders that have been depleted from the source business unit and not received by the customer.

VMI inventory is on hand at a customer location. You and your customers can communicate inventory levels and inventory movement by using service operations in PeopleSoft Integration Broker (EIPs). Four EIPs support VMI:

  • VMI On Hand Quantity - inbound communication of inventory quantities that are on hand at the customer site.

  • VMI Inventory Adjustment - inbound communication of inventory transactions at the customer site.

  • VMI Interunit Receipt - inbound communication of goods received by the customer.

  • VMI Expected Receipt - outbound communication of goods shipped to the customer.

Maintaining Inventory Balances

You can receive updates to customer inventory quantities using EIPs, service operations in PeopleSoft Integration Broker. There are two service operations that support bringing inventory quantities into the PeopleSoft system. Both service operations are inbound asynchronous messages that can be mapped to the X.12 852 Product Activity transaction.

  • The VMI_INVENTORY_ADJUSTMENT EIP is used to bring adjustment transactions into the system.

    The adjustment can be an increase, a decrease, a scrap adjustment, or a return of VMI Goods. Adjustment data is stored in the transaction log using the 0910 transaction code.

  • The VMI_QUANTITY_ON_HAND EIP is used to bring inventory balances into the PeopleSoft system.

    When an inventory balance is received, the quantity in the inbound data is compared to the on hand inventory already existing in inventory, and an inventory adjustment is made to synchronize the balances. Balance data is stored in the transaction log using the 0900 transaction code.

Transaction details can be entered manually on the VMI QOH and Inventory Adjust (BCT_INV_VMI_QOH) page or can be created using the EIP's. When you save the transaction, PeopleSoft Inventory inserts the information into the transaction log. You then run the VMI Quantity On Hand process (VMI_QOH_EIP), which retrieves data from the transaction log and processes the transaction. Use the Transaction Maintenance (BCT_CTL_UPD) component to correct the errors and resubmit the transaction.

The data processing capabilities described below apply to both the VMI Quantity on Hand and the VMI Inventory Adjustment EIPs:

  • Users may send in either the VMI OM Business Unit and Ship To Customer ID or the inventory location.

    Since these map one to one, the location can be determined if it is not included in the inbound data.

  • Users may send in either the Product ID or the Item ID.

    If product ID is sent in, the data processing will get the item ID from the customer, the VMI Business Unit or from the PROD_ITEM table.

  • If goods are lot-, serial-, or staged date controlled and the customer is a consigned customer, the inventory control information must be included in the inbound data.

  • If goods are lot-, serial-, or staged date controlled and the customer is a non-consigned customer, the inventory control information must be included in the inbound data when an increase to inventory is being done.

  • If goods are lot-, serial-, or staged date controlled and the customer is a non-consigned customer, the inventory control information need not be included in the inbound data if a decrease to inventory is being done.

    The data processing will remove goods from inventory on a FIFO basis, using lot birth date, serial ID, or staged date to determine the oldest goods on hand. The FIFO processing cannot be used to drive inventory negative. The incoming data will be set to Error status when this occurs.

Receiving VMI Interunit Data

Inventory balances in the VMI business unit can also be updated using the VMI_INTERUNIT_RECEIPT EIP. VMI Interunit transfer orders are created in the PeopleSoft system to move stock between the source inventory business unit and the VMI business unit. The VMI Interunit Receipt EIP updates inventory quantities that are received by the VMI customer. The VMI Interunit Receipt EIP is an asynchronous service operation.

Processing VMI Interunit Expected Receipts

The VMI_EXPECTED_RECEIPT EIP is an asynchronous outbound service operation that notifies the customers system that an inventory business unit has shipped an interunit transfer order. The VMI Expected Receipt EIP meets X.12 EDI requirements of the 943 - Warehouse Stock Transfer Shipment Advice transaction set and can be used with warehouse management systems. VMI Interunit transfer orders are created in the PeopleSoft system to move stock between the source inventory business unit and the VMI business unit.

The VMI Interunit Receipt EIP provides one option for notifying VMI customers that inventory has been shipped. You can use the VMI Expected Receipt EIP in integrated implementations where a third-party system is controlling an inventory business unit. Transactional data is generated when an interunit transfer order that has a destination business unit that is under external warehouse control is depleted. The third-party system uses the data from the VMI expected receipt EIP to validate the receipt of goods when the shipment arrives at the destination warehouse.

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. To set up these service operations:

  1. Set up within the PeopleSoft Inventory application:

    For the VMI Expected Receipt EIP, select the Use External Warehouse Control check box on the Inventory Definition-Business Unit Options page.

  2. Set up 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

VMI_QUANTITY_ON_HAND

Inbound

Asynchronous

VmiQuantityOnHand

No

Third-party systems

VMI_INVENTORY_ADJUSTMENT

Inbound

Asynchronous

InventoryAdjustment

No

Third-party systems

VMI_INTERUNIT_RECEIPT

Inbound

Asynchronous

VMIinterunitReceipt

No

Third-party systems

VMI_EXPECTED_RECEIPT

Outbound

Asynchronous

Yes

Third-party systems

See the product documentation for PeopleTools: Integration Broker

Use the VMI QOH and Inventory Adjustment page (BCT_INV_VMI_QOH) to enter quantity adjustments to VMI stock manually or by using an electronic data collection (EDC) device.

Navigation:

SCM Integrations > Create Transactions > Inventory > Create VMI Adjustments to QOH

Field or Control

Description

Trans Code (transaction code)

Select the transactions code:

0900 - VMI Quantity On Hand.

0910 - VMI Inventory Adjustment.

VMI OM UnitVMI Order Management Unit

Enter the VMI Order Management business unit. The VMI order management business unit in combination with the Ship To Customer can be entered in lieu of the Storage Location to identify location where the quantity is being adjusted.

Ship To Customer

Enter the Ship To Customer. The VMI order management business unit in combination with the Ship To Customer can be entered in lieu of the Storage Location to identify location where the quantity is being adjusted.

Storage Location

Enter the inventory location in which the quantity is being adjusted.

Item IDand Product ID

Enter the Item ID or the Product ID that is being adjusted.

Type

Enter the type of adjustment for 0910 transactions. VMI adjustment types are:

D - decrease.

I - increase.

S - scrape.

A - VMI return.

Quantity

Enter the on hand quantity of the item for 0900 transactions.

Enter the amount that you want to adjust the item for 0910 transactions.

UOM

Enter the UOM for the transaction. If the UOM conversion option is set to convert to the standard UOM or convert to the default stocking UOM for the business unit, you can enter adjustments in any valid UOM and PeopleSoft Inventory converts them to the item's standard UOM or the storage location's stocking UOM. If the UOM conversion option indicates that no conversion occurs for the business unit, you can enter adjustments in any valid stocking UOM. If negative inventory balances are permitted in the business unit, you can enter an adjustment that drives the quantity negative. You can also adjust the quantity in the storage location to zero.

RMA Number return material authorization number

Enter the RMA number if the adjustment Type is VMI Return.

RMA Line Numberreturn material authorization line number

Enter the RMA line number if the adjustment Type is VMI Return.

Note: The business unit's default display options determine how many storage location levels appear when you access this page. If you are entering a storage location that requires additional levels, enter the storage area, then refresh the page to display the remaining levels for that area.

Note: The business unit defaults that you established on the Inventory Display Options page determine whether lot, serial, staged date, and configuration fields appear when you access this page. Any fields for which the default is Yes always appear. Any fields for which the default is No appear when you save or refresh the page, and only if they apply to the item in question.

Use the VMI Interunit Expected Receipts page (IN_RUN_SHPVMI_IU) to publish the VMI Expected Receipts EIP for interunit transfer orders that have been depleted from the source business unit and not received by the customer.

Navigation:

SCM Integrations > Publish Outbound Message. Select VMI Interunit Expected Receipt. Click the VMI Interunit Expected Receipt link.

Field or Control

Description

Inventory Unit

Enter the inventory business unit that is shipping the stock.

Shipments

Select All to generate an expected receipt for all shipments for a business unit.

Select Specific and enter a Shipping ID to generate an expected receipt for a specific shipping ID.

OM Business Unitorder management business unit

Enter the PeopleSoft Order Management business unit that the customer is associated with.

Sold To Customer and Ship To Customer

Enter the Sold To or Ship To Customer that represents where the stock is being shipped.