Understanding Inventory Transactions

Inventory transactions are any material movement transactions that have a financial affect on inventory balances, such as purchase receipts, adjustments, and issues. Inventory transactions include route to production kit transactions. Route to Production kit transactions are the transactions that occur when an assembly item is completed on a production ID or schedule, and it can be routed to another production ID, where it is used as a component on the next-higher-level assembly. The component's issue method must be set to kit in order for you to route directly to production.

This information is derived from the transaction history records (TRANSACTION_INV and TRANS_INV_CM). Inventory transactions include these transaction groups:

Transaction Group Description Transaction Process Menu Path

010

Receipt to Inspection.

Put away an item that is received from a purchase order that requires inspection.

Inventory, Putaway Stock, Complete Putaway

012

Return to Vendor.

Inventory that is returned from a storage location. The express issue request type must be marked as supplier returns.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

013

Return to Vendor from Inspection.

Inventory returned from an inspection location. The express issue request type must be marked as supplier returns.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

020

Putaway.

Put away an item that is received from a purchase order, one that doesn't require inspection.

  • Inventory, Putaway Stock, Complete Putaway

  • Inventory, Putaway Stock, Express Putaway

021

Receipts from Production.

Put away an assembly completion that is routed to a storage area or another WIP location.

  • Inventory, Putaway Stock, Complete Putaway

  • Production Control, Process Production, Complete Production, Record Completions and Scrap (if Putaway Action is set to Putaway at Receipt Save Time)

022

IBU Transfer Receipts.

Receive an item that is shipped to the inventory business unit from another inventory business unit.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Inventory, Putaway Stock, InterUnit and RMA Receiving

024

Customer Returns.

Receive an item from a customer and it specifies RMA receipt.

Inventory, Putaway Stock, InterUnit and RMA Receiving

025

InterCompany Receipts.

Receive material from an inventory business unit that is associated with another general ledger, where intercompany processing is indicated.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Inventory, Putaway Stock, InterUnit and RMA Receiving

026

Expensed Issue Return.

Receive material returned from an interunit expensed issue using the IN_DEMAND_TPRC table.

Inventory, Putaway Stock, Expense Issue Return

030

Usages & Shipments.

Issuing material to fulfill a sales order, express issue, or material stock request.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

031

InterBU Transfer Shipments.

Issuing material for a shipment to another inventory business unit, which is entered through an express issue or material stock request.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

034

Shipments on Behalf of Other BU.

Issuing material for a customer shipment based on a Sales Order that is taken in an Order Management Business Unit. The Order Management and Billing units must post to a different General Ledger business unit than is posted by the inventory unit.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

035

InterCompany Transfers.

Transfer material from an inventory business unit that is associated with another general ledger, where intercompany processing is indicated.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

036

InterUnit Expensed Issue.

Expense material from an inventory business unit to an internal department of an unrelated general ledger business unit.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the cost by cost elements.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

037

VMI Interunit shipment

Record the shipment of non-consigned goods from an inventory business unit to a VMI business unit by debiting the cost of goods sold account and crediting the inventory account.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

038

VMI Consumption

Record the consumption of materials in a VMI business unit by debiting the cost of goods sold account and crediting the inventory account.

SCM Integrations, Process Transactions, Inventory, VMI Quantity On Hand

040

Physical Count Adjustments.

Record inventory adjustments from a physical inventory.

Inventory, Inventory Counts, Reconcile Inventory Balances, Update Stock Quantity

041

Cycle Count Adjustments.

Record inventory adjustments from a cycle count.

Inventory, Inventory Counts, Reconcile Inventory Balances, Update Stock Quantity

042

IBU Transfer Adjustments.

Receive more or less than the quantity that is shipped by using the Inter Business Unit Shipment. When the interunit receipt is closed, a comparison is made between the shipment quantity and the receipt quantity. Any differences are recorded here.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Inventory, Putaway Stock, InterUnit and RMA Receiving

050

User Adjustments.

Specify a quantity adjustment type of increase or decrease.

Inventory, Manage Inventory, Adjustments

051

Inventory Scrap.

Specify an adjustment type of scrap.

Inventory, Manage Inventory, Adjustments

052

Shipping Adjustment.

Deplete less than the quantity that is picked for a shipment that is entered by using a sales order, an express issue, or material stock request. If the picked quantity differs from the depletion quantity, that difference is accounted for here.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

053

Floor Stock Issues/Ret.

Specify an adjustment type of Miscellaneous Issue or Miscellaneous Receipt.

Inventory, Manage Inventory, Adjustments

054

Inventory Scrap for RTV.

Specify an adjustment type of scrap RTV.

Inventory, Manage Inventory, Adjustments

060

Bin-to-Bin Transfers.

Transfer inventory from one storage location to another. This can be a direct bin-to-bin transfer, a material release of a production pick plan for components using the issue method, or the result of a replenishment workflow work it action.

  • Inventory, Manage Inventory, Transfers, EZ Transfers

  • Production Control, Process Production, Issue Materials, Material Release

220

Component Kit.

Transfer of inventory from a storage area directly to a production ID. This is accomplished in material release of a production pick plan for components using the kit issue method or by doing a single issue of a kit component.

Dekitting a production ID creates reversing entries, as does a return of a kitted component.

  • Production Control, Process Production, Issue Materials, Material Release

  • Production Control, Process Production, Issue Materials, Issue/Return Kit Components

  • Production Control, Process Production, Issue Materials, De-Kit Components

  • Production Control, Process Production, Issue Materials, Issue/Return Kit Components

221

Route To Production Kit.

Record completions of an assembly at the last operation and route the completed assembly to another production ID. The assembly must be a component whose issue method is set to kit at the next higher production ID.

  • Production Control, Process Production, Complete Production, Record Completions and Scrap

  • Production Control, Process Production, Subcontract Production, Receive Subcontract Assembly

  • Production Control, Process Production, Complete Production, Process Completions and Scrap

222

Waste Completion.

Record completion of a waste product on a PID or schedule.

Production Control, Process Production, Complete Production, Record Completions and Scrap

223

Component/Output Transfers.

Moving components or outputs from one PID to another as a result of a PID split. You can also move components from one PID to another to reallocate material issues.

Production Control, Process Production, Split Production, Production ID Split

230

Component Consumption.

Material is consumed from the WIP location during a completion or scrap transaction. The components issue method must be set to issue or replenish.

  • Production Control, Process Production, Complete Production, Record Completions and Scrap

  • Production Control, Process Production, Issue Materials, Edit/Issue Components

  • Production Control, Process Production, Complete Production, Record Completions and Scrap

231

WM Usage (Maintenance Management Usage)

Issuing material to a work order in PeopleSoft Maintenance Management to maintain or repair an asset. Material returned to inventory from a work order also uses this transaction group.

Inventory, Fulfill Work Orders, Issue to Work Orders

300

Gain/Loss on Transfer Price.

Ship an item to another inventory business unit specifying a transfer price that differs from the items cost.

or

Receive an Inter Business Unit Shipment for a standard cost item with a transfer price that differs from the item's cost.

or

Record additional transfer costs in the transfer price.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Note: This transaction doesn't appear on the Transaction History record, but is calculated as part of the Transaction Costing process when costing IBU shipments and receipts.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

301

InterCompany Cost of Goods.

Issuing material to an inventory business unit that is associated with another general ledger, where intercompany processing is indicated.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Note: This transaction doesn't appear on the Transaction History record, but is calculated as part of the Transaction Costing process when costing InterCompany shipments (transaction group 035).

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

302

ShipOnBehalf Gain/Loss

Issuing material for a customer shipment based on a Sales Order that is taken in an Order Management Business Unit. The Order Management and Billing units must post to a different General Ledger business unit than is posted by the inventory unit. Gain or loss is recorded when the transfer price differs from the item cost or additional transfer costs are applied.

In addition to the TRANSACTION_INV table, the IN_DEMAND_TPRC table stores the transfer price by cost elements.

Inventory, Fulfill Stock Orders, Shipping, Deplete On Hand Quantity

400

Std Cost Variance Receipts.

Receive a standard cost item from a purchase order into inspection or stock. If the purchase order price differs from the standard cost of the item, a PPV entry is calculated.

Note: This transaction doesn't appear on the Transaction History record, but is calculated as part of the Transaction Costing process when costing purchase receipts to inspection or stock.

Or

Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation

 

 

Receive an actual cost item from a purchase order into inspection or stock. Later, if the purchase order price differs from the voucher price record the difference in an expense account rather than update the inventory receipt and depletion transactions. This option is only valid if you have selected the Writeoff PPV and ERV check box on the Cost Profile page.

Or

 

 

 

For standard cost items, voucher an invoice in Accounts Payable, match, post and run the Landed Cost Extract process. If the invoice price differs from the purchase order price, a PPV entry is posted.

Note: This transaction doesn't appear on the Transaction History record, but is calculated as part of the Vouchering and Matching process.

  • Accounts Payable, Batch Processes, Vouchers, Matching

  • Accounts Payable, Batch Processes, Vouchers, Voucher Posting

  • Accounts Payable, Batch Processes, Extracts and Loads, Extract Landed Cost

402

Std Cost Exchange Rate Var.

Accounts for any differences between the exchange rate that is specified on a purchase order and the exchange rate that is used during the Vouchering process.

Note: This transaction doesn't appear on the Transaction History record, but is calculated as part of the Vouchering and Matching process.

  • Accounts Payable, Batch Processes, Vouchers, Matching

  • Accounts Payable, Batch Processes, Vouchers, Voucher Posting

  • Accounts Payable, Batch Processes, Extracts and Loads, Extract Landed Cost

407

Subcontract Standard Cost PPV2

For subcontracted purchases using standard costing, this is the purchase price variance that records the price difference between the purchase order and the voucher.

Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation

408

Subcontract Standard Cost PPV2 ERV

For subcontracted purchases using standard costing, this is the purchase price variance that records the exchange rate difference between the purchase order and the voucher.

Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation

461

PO Voucher Variance

Run the Transaction Costing process to record the difference between a user adjusted cost and the vouchered cost. This variance is recorded for purchased items using standard or actual cost. The variance between the PO price and the user adjusted cost is recorded in transaction group 400 for standard cost items.

Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation