Appendix: Additional Information for the Costing Structure

This appendix discusses how to:

Click to jump to parent topicUsing Transaction Groups

Each transaction with a financial impact is embedded with a transaction group. The transaction group identifies the type of transaction that is entered and determines what records are populated, how costing is calculated, and what ChartFields are used to record accounting entries. In this section, we identify all the transaction groups by code, description, transaction process description, and specific menu paths. We divide the transaction groups into their logical categories, including:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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 vendor 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 vendor 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

Click to jump to top of pageClick to jump to parent topicUnderstanding Earned Conversion Cost Transactions

Earned conversion cost transactions account for the labor, machine, and subcontracting costs that are earned and also the manufacturing overhead that is applied when completing assemblies at an operation or to stock. These transaction groups include:

Transaction Group

Description

Transaction Process

Menu Path

240

Earned Labor.

Recording completions or scrap for an assembly at an operation.

  • 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

211

WIP Revalue (Conversion Costs).

Revaluation of WIP inventory. If conversion costs are recorded prior to the standards change, the costs are revalued as part of the WIP revaluation calculation.

Cost Accounting, Item Costs, Update Costs, Cost Update/Revalue

Click to jump to top of pageClick to jump to parent topicUnderstanding Production Variance Transactions

Production variance transactions represent material variances and conversion variances that are incurred on a production ID or schedule when production is closed for accounting. These transaction groups include:

Transaction Group

Description

Transaction Process

Menu Path

261

Material Variances

Material variances incurred on a production ID or schedule when production is closed for accounting.

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

262

Conversion Variances

Conversion variances incurred on a production ID or schedule when production is closed for accounting.

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

263

Rework Expense

Variance incurred on a production ID when you repair or rework previously completed assemblies.

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

264

Outside Processing PPV

For standard cost makeable items, this transaction group records the variance between the standard cost and the purchase order price of the subcontracted service.

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

265

Teardown Variance

Variance incurred on a production ID when you break an assembly down into its component parts and return the components to inventory.

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

415

RTV Variances

Records the difference between the inventory value of goods being returned and the amount of the vendor refund recorded in accounts payable.

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

661

Actual Cost Variances

For actual cost makeable items, this transaction group records the variance between the actual cost of the components and the standard cost of the end items.

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

664

Subcontract Variance

For actual cost makeable items, this transaction group records the variance between the purchase order price and the voucher price of the subcontracted service for actual cost components.

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

Click to jump to top of pageClick to jump to parent topicUnderstanding Production Scrap Cost Transactions

Production scrap cost transactions account for the cost of assemblies that scrapped in process while recording operation and assembly completions. The information that appears here is derived from the Assembly Scrap Cost record (SF_SCRAPCOST). The transaction groups that are used to record scrap are:

Transaction Group

Description

Transaction Process

Menu Path

212

WIP Revaluation (Scrap)

Revaluation of WIP inventory. If assembly scrap is recorded prior to the standards change, the scrap costs are revalued as part of the WIP revaluation calculation.

Cost Accounting, Item Costs, Update Standard Costs, Cost Update/Revalue, Update Production

250

Assembly Scrap

Recording scrap for an assembly at an operation.

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

  • Process Production, Subcontract Production, Receive Subcontract Assembly

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

Click to jump to top of pageClick to jump to parent topicUnderstanding Production Actual Cost Transactions

Production actual cost transactions account for the actual cost of production when the make item uses an actual or average cost method. Actual production costs include the actual cost of materials, conversion costs, conversion overhead costs, subcontracted components, and additional costs. The transaction groups that are used to record production actual costs are:

Transaction Group

Description

Transaction Process

Menu Path

601

Wt Avg Upd Production Var.

Run the Transaction Costing process for a production ID or production schedule that is closed for accounting.

If the make (end) item is average costed, then this transaction group accounts for average cost updates due to new cost information on receipts from manufacturing, usually when the estimated manufacturing cost from partial receipts from work in process are updated to a finalized manufacturing cost once the production order or production schedule is complete.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

605

Wt Avg Upd Prod Writeoffs.

Run the Transaction Costing process for a production ID or production schedule that is closed for accounting.

If the make (end) item is average costed, then this transaction group creates a writeoff when the average cost of the item needs to be updated, due to new cost information on receipts from manufacturing, but there is not enough quantity currently in stock to absorb the updated costs.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

606

Avg Rev Compl Write-off

Run the Transaction Costing process for a production ID or production schedule that is closed for accounting.

If the make (end) item uses the perpetual weighted average method, then this transaction group creates a writeoff, when needed, to clear the production costs from WIP.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

622

Actual Waste Cost.

Run the Transaction Costing process for a production ID or production schedule that is closed for accounting.

If the make (end) item is actual or average costed and a waste by-product is produced, then this transaction group credits an expense account and debits the finished goods inventory account.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

630

Overhead

Run the Transaction Costing process for a production ID or production schedule that has been closed for accounting.

If the make (end) item is actual or average costed, then this transaction group debits WIP and credits a manufacturing overhead cost absorption account for overhead costs of the production. These costs are applied using material, labor, and machine amounts as the basis for allocating overhead charges to production outputs.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

640

Actual Labor Costs.

Run the Transaction Costing process for a production ID or production schedule that has been closed for accounting.

If the make (end) item is actual or average costed and the operation sequence is complete, then this transaction group credits earned labor account and debits WIP with the actual labor costs.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

645

Actual Machine Costs.

Run the Transaction Costing process for a production ID or production schedule that is closed for accounting.

If the make (end) item is actual or average costed and the operation sequence is complete, then this transaction group credits earned machine account and debits WIP with the actual machine costs.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

651

Production Cost Writeoff.

Run the Transaction Costing process for a production ID or production schedule that is closed for accounting.

This transaction group is used when there is an overriding adjustment and additional costs hit WIP. This transaction group writes off those WIP costs which do not belong in finished goods.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

661

Actual Cost Variances

Run the Transaction Costing process for a production ID or production schedule that is closed for accounting.

If the make (end) item is standard costed and one or more of the components uses actual or average cost, then this transaction group relieves WIP for the difference between the actual cost of the component consumption transaction and the standard cost of the component which was used to build up the standard cost of the end item. The offset is posted to a period variances ChartField.

Although the inputs to standard cost end items can have standard costs themselves, the input items can still use any cost profile for accounting purposes. As components are depleted, the cost on the depletion becomes part of the actual cost of the output items.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

664

Subcontracted Cost.

Run the Transaction Costing process for a production ID or production schedule that is closed for accounting.

This transaction group records the variance between subcontracted costs on the purchase order and the actual subcontracted costs on the voucher. This transaction group is used only for actual or average cost items.

Cost Accounting, Inventory and Mfg Accounting, Created Accounting Entries, Inventory Transaction Costing, Transaction Costing

Click to jump to top of pageClick to jump to parent topicUnderstanding Standard Cost Revaluation Transactions

Standard cost revaluation transactions are the transactions that occur when you change standard costs and update the production cost record with the new version of costs. At that time, the system:

The WIP revaluation information that is displayed here is associated with the revaluation of the components issued to the production ID or schedule as well as the revaluation of the assembly item itself. Detail information is derived from the Posted Item Cost Variance record (CE_ITEMCVAR_PST). The transaction groups are:

Transaction Group

Description

Transaction Process

Menu Path

200

Inventory Revalue.

Once production costs are updated, this transaction accounts for the change in inventory value in storage areas or WIP locations.

Cost Accounting, Item Costs, Update Standard Costs, Cost Update/Revalue, Update Production

201

Inventory Reval - Inspection.

Once production costs are updated, this transaction accounts for the change in inventory value in inspection locations.

Cost Accounting, Item Costs, Update Standard Costs, Cost Update/Revalue, Update Production

210

WIP Revalue (Comps, Assy).

Revaluation of WIP. This transaction accounts for the change in component and assembly costs that are still in process.

Cost Accounting, Item Costs, Update Standard Costs, Cost Update/Revalue, Update Production

Click to jump to top of pageClick to jump to parent topicUnderstanding Average Cost Adjustment Transactions

Average cost value adjustment transactions occur when adjusting the cost of the perpetual weighted average cost or the retroactive perpetual weighted average cost items and the resulting change in inventory value. Value adjustments for items using perpetual weighted average costing or retroactive perpetual weighted average costing can be:

These transactions are displayed in this table:

Transaction Group

Description

Transaction Process

Menu Path

205

Value Adjustment.

Records an adjustment to change the value of the current inventory stock for a specific item using perpetual average or retroactive perpetual average costing.

This transaction group applies only to perpetual average and retroactive perpetual average items.

  • Cost Accounting, Item Costs, Update Costs, Adjust Average Cost

  • Cost Accounting, Item Costs, Update Costs, Adjust Retroactive Averages

401

Wt Avg Updates from AP.

Records an adjustment to update the perpetual weighted average cost with posted purchase price variances (PPV).

Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Inventory Transaction Costing. Select the Apply Perpetual Average Adjs check box.

403

Wt Avg Cost Updates - ERV.

Records an adjustment to update the perpetual weighted average cost with posted exchange rate variances (ERV).

Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Inventory Transaction Costing. Select the Apply Perpetual Average Adjs check box.

405

Wt Avg Update Writeoffs.

Records an adjustment to account for any PPV or ERV not applied into the perpetual weighted average cost.

Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Inventory Transaction Costing. Select the Apply Perpetual Average Adjs check box.

Click to jump to top of pageClick to jump to parent topicUnderstanding Actual Cost Adjustment Transactions

Actual cost value adjustment transactions occur when adjusting the cost of the actual cost items and the resulting change in inventory value. Actual cost items are adjusted using the Adjust Actual Cost component. The transaction is:

Transaction Group

Description

Transaction Process

Menu Path

206

Value Adjust/ActCost Items.

Records an adjustment to change the value of the current inventory stock for a specific item using actual costing.

Cost Accounting, Item Costs, Update Costs, Adjust Actual Cost

Click to jump to top of pageClick to jump to parent topicUnderstanding Non-stock Shipment Transactions

Non-stock shipment transactions are the transactions that occur when you specify a non-stocked item on a sales order in PeopleSoft Order Management and mark it for billing. The transaction is:

Transaction Group

Description

Transaction Process

Menu Path

032

Non Stock Shipments

Designate a nonshippable item as ready for billing.

Order Management, Quotes and Orders, Create OM Billing Entries, Mark Lines for Billing

Click to jump to parent topicUsing Costing Flow Diagrams

This diagram illustrates how the Transaction Costing process (within the Cost Accounting Creation process) calculates the cost of each inventory transaction:

Detailed Costing Flow Diagram - Transaction Costing Process

The Transaction Costing process:

  1. Expands the inventory transactions in TRANSACTION_INV into the PeopleSoft Cost Management CM_TRANSACTION table adding a separate row for each business unit and cost book combination. Interunit transactions are expanded for compound accounting entries and stored in the CM_INTRANSIT record. Shipment on Behalf of transactions are stored in the CM_SHIPONBEHALF and CM_SHIPONB_BOOK tables. Interunit Expensed Issue Returns are stored in the TRANS_INV_CM table. For interunit transfers, interunit expensed issues, and shipment on behalf of transactions, the IN_DEMAND_TPRC table is used in combination with the TRANSACTION_INV table.

  2. Places putaway transactions into CM_RECEIPTS and dummy deplete rows in CM_DEPLETE to complete the join for CM_ONHAND_VW.

  3. Inserts all cost adjustments from PeopleSoft Manufacturing production IDs, Payable vouchers, and user-entered cost adjustments. Stores the actual cost value adjustments in the record CM_USER_CST_ADJ where the adjustment then flows into the CM_RECEIPT_COST record to be picked up by the Accounting Line Creation process. Stores the value adjustments for items using perpetual average and retroactive perpetual average costing in the record CM_COST_ADJ, and then expands the adjustment by cost book into the CM_COST_ADJB record. The Accounting Line Creation process picks up the data from the CM_COST_ADJB record.

  4. Adds depletion transactions into CM_DEPLETION table.

  5. Matches up each depletion transaction in CM_DEPLETION with a qualifying putaway from CM_ONHAND_VW. These depleted depletions are inserted into the CM_DEPLETE table.

  6. Calculates the cost of receipts and placed them into CM_RECEIPT_COST, CM_VARIANCES, and CM_VARIANC_COST tables.

  7. Calculates the cost of depletions in CM_DEPLETE table and placed them in the CM_DEPLETE_COST table. In addition, it also calculates the gain or loss on interunit transfers and places them in the CM_TRANSVAR and CM_TRANSVAR_COST tables.

  8. Calculates the cost of make items produced in PeopleSoft Manufacturing. The end item costs are computed and placed in CE_ACTUAL_COST table.

This diagram illustrates how the Accounting Line Creation process creates the accounting entries for each inventory transaction:

Detailed Costing Flow Diagram - Accounting Line Creation Process