Defining the Accounting Structure

Using the Accounting Rules page, you can create your steps for accounting entries, at any level of detail, for all transactions that have a financial impact on inventory. When a transaction is created, it contains the information that is used to find and create the accounting entries, including:

Field or Control

Description

Transaction Group

A system-defined code automatically embedded in each inventory transaction that defines the type of transaction. For example, the transaction code 030 (Usage and Shipments) is embedded on the Express Issues page for external issues. Any transaction that is recorded by using this page is coded with the transaction group 030.

Distribution Type

(Optional) A subset of transaction groups that can further define the transactions. This code is user-defined and can be added during transaction entry. For example, you could decide that the transaction group 030 (Usage & Shipments) is too general and opt to use distribution types to further define it as shipments to wholesale customers and shipments to retail customers.

Unit

The PeopleSoft Inventory business unit in which the transaction is recorded.

Item ID or Item Group

The item used in the transaction or the item group to which this transaction belongs.

Cost Element

A code used to categorize the different components of an item's cost and also define the debit and credit ChartFields for accounting entries. Adding a cost element to the Define Business Unit Item - General page, identifies an item's material cost.

When you run the Accounting Line Creation process, the system searches through the accounting rules definition data that you defined on the Accounting Rules page, looking for a match to the transaction's data going from most granular to least granular. For example, suppose that you process an entry from the Express Issues page (using the transaction group 030) for item ID 10001 in the business unit US008. The process searches for an Accounting Rules page with business unit US008, transaction group 030, and item ID 1001. If the system finds this combination, then it creates the accounting entries based on this transaction accounting rule. If more than one accounting rule can be used for the transaction, then the process uses the more specific rule, for example, item ID instead of item group.

If location accounting is turned on, then the process searches storage area accounts to find the credit account and uses the transaction accounting rule to find the debit account. Additional information about the Accounting Line Creation process is located in the Costing Transactions and Creating Accounting Entries topic.

To define the inventory accounting structure:

  1. Verify that the PeopleSoft financial structure has been defined including ChartFields and combination editing.

  2. Verify that the cost elements have been defined and attached to the various PeopleSoft pages that generate costs including:

    • The Define Business Unit Item page.

      A purchased item must always have a cost element defined.

    • The Misc Charge/Landed Cost Definition page.

    • The Conversion Rates page.

    • The Costing Conversion Overhead Rates page.

    • The Additional Item Costs page.

    • The Forecasted Purchase Costs page.

  3. Review the list of transaction groups codes.

  4. Define any distribution types needed to further breakdown the transaction groups.

  5. (Optional) Use the Default Distribution Type page to establish any default distribution types by transaction group.

  6. Define any item groups.

  7. Establish the accounting entries to be created using the Accounting Rules page.

After establishing the accounting structure, the Transaction Costing process (CM_COSTING) costs transactions and the Accounting Line Creation job process creates accounting entries. Both process are initiated using the Cost Accounting Creation process page.

Page Name

Definition Name

Usage

Cost Elements Page

CM_ELEMENT

Define cost elements to categorize different components of an item's cost.

Distribution Type Page

CM_DISTR_TYPE

Use to define debit and credit account ChartFields at a finer level of granularity.

Default Distribution Type Page

CM_TRANS_GROUP

Assign default distribution types for transactions.

Item Groups Page

INV_ITEM_GROUP

Create groups of similar items that should use the same ChartField combinations in their accounting entries.

Accounting Rules Page

CM_ACCTG_DIST

Create the debit and credit lines for the accounting entries based on the business unit, transaction group, distribution type, item or item group, and cost element.

Define Item - General: Common

INV_ITEMS_DEFIN1

Define the item group to which this item belongs.

Verify that the PeopleSoft financial structure has been defined, including ChartFields and combination editing. Note whether ChartField combination edits are being used. ChartField combination editing displays an error message when incorrect combinations are used. Combo edits are always based on the COMBO_DATA_TBL record. When the combo rules are changed, the new rules are not used until the Build Combo Data process is run to repopulate the record.

Use the Cost Elements page to define or maintain cost elements, that you use to categorize different components of an item's cost. When you perform a cost roll-up, you maintain an item's standard cost by cost element. You can use cost element categories to define the costs at a summarized or very detailed level by using one or many cost elements. Cost elements also help define the ChartField combinations that you used to create accounting entries during the Accounting Line Creation process. Once you define the cost elements, attach the appropriate cost elements to the different costs that PeopleSoft Cost Management generates including:

  • Attach a default cost element to each item on the Define Business Unit Item page.

  • Use landed cost elements to categorize landed costs on the Misc Charge/Landed Cost Definition page.

  • For make items, use the cost elements to define costing conversion rates, costing conversion overhead rates, additional item costs, and forecasted purchase costs.

Each transaction, with a financial impact, is embedded with a predetermined transaction group. The transaction group identifies the type of transaction entered and determines what records are populated, how costing is calculated, and what ChartFields are used to record accounting entries. PeopleSoft Cost Management maintains a transaction history for all transactions with a transaction group. This table lists the transaction group codes and descriptions:

Transaction Group Code

Transaction Group Description

001

CM Only NegQty Costing Opt

010

Receipt to Inspection

012

Return to Vendor

013

Return to Vendor from Inspection

020

Putaway

021

Receipts from Production*

022

IBU Transfer Receipts

024

Customer Returns

025

InterCompany Receipts

026

Expensed Issue Return

030

Usage & Shipments

031

InterBU Transfer Shipments

032

Non Stock Shipments

034

Ship on Behalf of Other BU

035

InterCompany Transfers

036

InterUnit Expensed Issue

037

VMI Interunit shipment

038

VMI Consumption

040

Physical Count Adjustments

041

Cycle Count Adjustments

042

IBU Transfer Adjustments

050

User Adjustments

051

Inventory Scrap

052

Shipping Adjustment

053

Floor Stock Issues/Ret*

054

Inventory Scrap for RTV

060

Bin-to-Bin Transfers

200

Inventory Revalue

201

Inventory Reval - Inspection

205

Value Adjustment

206

Value Adjust/ActCost Items

210

WIP Revalue (Comps, Assys)*

211

WIP Revalue (Conv Costs)*

212

WIP Revaluation (Scrap)*

220

Component Kit*

221

Route to Production Kit*

222

Waste Completion

223

Component/Output Transfers

230

Component Consumption*

231

WM Usage (Maintenance Management Usage)

240

Earned Labor*

250

Assembly Scrap*

261

Material Variances*

262

Conversion Variances*

263

Rework Expense*

264

Outside Processing PPV*

265

Teardown Variance*

300

Gain/Loss on Transfer Price

301

InterCompany Cost of Goods

302

ShipOnBehalf Gain/Loss

400

Std/Actual Cost PPV

401

Wt Avg Updates from AP

402

Std/Actual Cost ERV

403

Wt Avg Cost Updates - ERV

404

WtAvg cost ERV WO-IFRS

405

Wt Avg Update Writeoffs

406

Actual cost ERV WO-IFRS

407

Subcontract Standard Cost PPV2*

408

Subcontract Standard Cost PPV2 ERV*

415

RTV Variances

461

Voucher Variance Writeoffs

500

Miscellaneous Charges

501

Freight Charges

601

Wt Avg Upd Production Var*

605

Wt Avg Upd Prod Writeoffs*

606

Avg Rev Compl Write-off*

622

Actual Waste Cost*

630

Overhead*

640

Actual Labor Costs*

645

Actual Machine Costs*

651

Production Cost Writeoff*

661

Actual Cost Variances*

664

Subcontracted Cost

*Indicates a transaction group that is related to transactions generated in PeopleSoft Manufacturing.

To define distribution types, use the Distribution Type (CM_DISTR_TYPE) component. Use the Distribution Type component interface (CM_DISTR_TYPE_CI) to load data into the tables for this component.

Use the Distribution Type page (CM_DISTR_TYPE) to use to define debit and credit account ChartFields at a finer level of granularity.

Navigation:

Set Up Financials/Supply Chain > Product Related > Cost Accounting > Distribution Type

In most instances, the transaction determines the debit and credit account to charge. For example, a customer shipment typically debits a cost of goods sold account and credits inventory. For some transactions, like a miscellaneous issue from stock, the transaction accounting rule can depend on the party to whom you issue the material. You could charge different departmental expense accounts for the receipt of inventory, depending on who requisitions the material from stock. Use distribution types to have the option to define different departments or cost centers.

When used in conjunction with the transaction group, distribution types enable you to define debit and credit ChartFields at a finer level of granularity. A manufacturing organization, for example, can set up a distribution type for each of its production departments. You assign these distribution types to the appropriate work center when you define the manufacturing data. When you record assembly completions at an operation or to stock, the system records the earned labor, machine, and overhead costs. If you have assigned a distribution type to the work center, the system records this distribution type along with the costs. This identifies the department or cost center that earned the labor, machine, and overhead costs. You can then set up transaction accounting rules for the transaction group Earned Labor (240) and the distribution type (for example, one of the assembly departments). Debit the production area account for the value of costs added to WIP and credit each department expense for the earned labor and applied overhead.

You can set up distribution sets in PeopleSoft Order Management with a distribution type that can be transferred to PeopleSoft Inventory and PeopleSoft Cost Management. This enables you to use the distribution type to classify costs of sales appropriate to the sales account.

To define default distribution types, use the Default Distribution Types (CM_TRANS_GROUP) component.

Use the Default Distribution Type page (CM_TRANS_GROUP) to assign default distribution types for transactions.

Navigation:

Set Up Financials/Supply Chain > Product Related > Cost Accounting > Distribution Type Default > Default Distribution Type

Once you define at least one distribution type, you can also assign a default distribution type that appears whenever you process a transaction. It is not required that you define a default distribution type for every transaction group; however, it can reduce entry errors. For example, you can assign a distribution type to the transaction group User Adjustments (050). Then, if an inventory adjustment occurs, the distribution type associated with the transaction appears as the default. You can override the default distribution type on a transaction by transaction basis. The use of distribution types for a transaction group is optional.

You can assign transaction accounting rules to a grouping of items by using item groups.

To use item groups for defining transaction accounting rules:

  1. Define the item groups using the Item Group page.

  2. Attach the item groups to the corresponding items using the Item Definition - General: Common page.

  3. Use the item groups on the Accounting Rules page to define the ChartField combinations to be used for the accounting entries.

To define accounting distribution, use the Account Distribution component (CM_ACCTG_DIST). This component is also know as the Transaction Accounting Rules component.

Use the Accounting Rules page (CM_ACCTG_DIST) to create the debit and credit lines for the accounting entries based on the business unit, transaction group, distribution type, item or item group, and cost element.

Navigation:

Set Up Financials/Supply Chain > Product Related > Cost Accounting > Transaction Accounting Rules > Accounting Rules

This example illustrates the fields and controls on the Accounting Rules page (partial page). You can find definitions for the fields and controls later on this page.

Accounting Rules page (partial page)

On this page, create a template of the ChartField combinations (chart of accounts) to be used for creating accounting entries. Use separate rows for the debit and credit entries. Create a separate page (or template) for each type of transaction. Once you determine how you want to model accounting entries, you can assign the debit and credit ChartFields for any combination of business Unit, Transaction Group, Distrib. Type (distribution type), either Item ID or Item Group, and Cost Element. Business Unit and Transaction Group are the only required fields.

To save maintenance time, three of the transaction groups do not need to be created or maintained on the Accounting Rules page. The transaction group 206 uses the account distribution setup defined for the transaction group 205. The transaction groups 211 and 212 use the account distribution setup defined for the transaction group 210.

Searching for the Correct Transaction Accounting Rule

As you define transaction accounting rules, there are some situations where more than one Accounting Rules page can be used for the same transaction. The system uses the transaction accounting rules with the most specific information matching the transaction. The search for the correct Accounting Rules page uses the logic in the table starting with the first row and continuing until a match is found.

Row

Unit

Trans Group

Item ID

Item Group

Distrib Type

Cost Element

1

Business Unit

Transaction Group

Item ID

blank

Distribution Type

Cost Element

2

Business Unit

Transaction Group

Item ID

blank

Distribution Type

blank

3

Business Unit

Transaction Group

Item ID

blank

blank

Cost Element

4

Business Unit

Transaction Group

Item ID

blank

blank

blank

5

Business Unit

Transaction Group

blank

Item Group

Distribution Type

Cost Element

6

Business Unit

Transaction Group

blank

Item Group

Distribution Type

blank

7

Business Unit

Transaction Group

blank

Item Group

blank

Cost Element

8

Business Unit

Transaction Group

blank

Item Group

blank

blank

9

Business Unit

Transaction Group

blank

blank

Distribution Type

Cost Element

10

Business Unit

Transaction Group

blank

blank

Distribution Type

blank

11

Business Unit

Transaction Group

blank

blank

blank

Cost Element

12

Business Unit

Transaction Group

blank

blank

blank

blank

Working with Cost Elements and Using Blank Spaces for Cost Elements

An item can have one or more cost elements defined in its product structure. The Transaction Costing process calculates and stores the costs by cost element. In the Accounting Line Creation process, the system attempts to match up the item's transaction costs (categorized by cost element) to a transaction accounting rule with the same information. The system finds the correct ChartField combination by searching for a row in the Accounting Rules page with a cost element matching the transaction costs of the item. If the system does not locate this, then it uses a row with a blank cost element. Therefore, you add flexibility to the system by adding different combinations of cost elements using different rows on the same Accounting Rules page. You can use any combination of debit and credit rows. You can use rows with a blank cost element for any unspecified cost elements. If you can use the same ChartFields, regardless of the cost element, leave the Cost Element field blank.

Entering Adjustments

Adjustments can be either an increase or decrease. You only need to define the accounting to record an expense. The system reverses the entry to record an income transaction. For example, a cycle count adjustment could increase or decrease inventory stock. For adjustments in PeopleSoft Cost Management where you are using location accounting, you need only define the decrease (expense) scenario and the system knows to reverse the entry for any increase in stock or income. For example, when defining the transaction accounting rules for the Cycle Count Adjustments transaction group, you define the inventory adjustment expense as the debit account. The credit account in this example is an inventory location's asset account. When creating accounting lines for cycle count adjustments, the system creates an entry debiting the expense account and crediting the inventory account for all inventory losses. For any inventory gains, the system creates the entry in reverse, debiting the inventory account and crediting the expense account.

This table lists the adjustment and variance transaction groups for which this rule applies:

Transaction Group

Description

040

Physical Count Adjustments

041

Cycle Count Adjustments

042

IBU Transfer Adjustments

050

User Adjustments

052

Shipping Adjustments

053

Floor Stock Issues/Ret

200

Inventory Revalue

201

Inventory Reval - Inspection

205

Value Adjustment

206

Value Adjust/ActCost Items

210

WIP Revalue (Comps, Assys)

211

WIP Revalue (Conv Costs)

212

WIP Revaluation (Scrap)

261

Material Variances

262

Conversion Variances

263

Rework Expense

264

Outside Processing PPV

265

Teardown Variance

300

Gain/Loss on Transfer Price

302

ShipOnBehalf Gain/Loss

400

Std Cost Variance Receipts

401

Wt Avg Updates from AP*

402

Std Cost Exchange Rate Var

403

Wt Avg Cost Updates - ERV*

405

Wt Avg Update Writeoffs

407

Subcontract Standard Cost PPV2

408

Subcontract Standard Cost PPV2 ERV

415

RTV Variances

461

PO Voucher Variance

601

Wt Avg Upd Production Var*

605

Wt Avg Upd Prod Writeoffs

606

Avg Rev Compl Write-off*

651

Production Cost Writeoff*

661

Actual Cost Variances*

*In the case of transaction groups 401 (Wt Avg Updates from AP), 403 (Wt Avg Cost Updates - ERV), and 601 (Wt Avg Upd Production Var) the debit account is really the inventory account. The system updates the inventory value with any unfavorable purchase price variance or exchange rate variance.

Using the Accounting Rules page with Location or Production Area Accounting

If you are using the Location Accounting function, define only the debit or the credit side for certain transactions. The system derives the offsetting entry line from the ChartField combinations that you define for the production area, storage area, or the interunit ownership setup.