Understanding Financial Transaction Analysis
Monitoring general ledger activity is very important in any environment. PeopleSoft Cost Management provides several tools to review financial transactions, including:
Using online inquiry pages to review transactions in an interactive mode.
Generating reports that give vital information on the financial health of an organization.
You can begin to analyze financial information after PeopleSoft Cost Management accounting lines are created. To create accounting lines, you need to perform these functions:
Generate financial transactions by using PeopleSoft Distribution and Manufacturing.
Execute the Transaction Costing process (CM_COSTING) within the Cost Accounting Creation process to cost the financial transactions.
Execute the Accounting Line Creation process (CM_ALC) within the Cost Accounting Creation process to generate the accounting lines for the transactions.
Once the accounting lines are created, you can navigate, report on, and view accounting information within PeopleSoft Cost Management before it is processed through the Journal Generator.
After generating the accounting lines for the transactions, you can execute the Journal Generator process (FSPGJGEN) to prepare the transactions for posting to the journal. Once the Journal Generator process is completed, you have the ability to navigate from both PeopleSoft General Ledger and PeopleSoft Cost Management.
Field or Control |
Description |
|---|---|
|
Click the View Related Links button to go to the Transfer Menu, where you can drill to general ledger and transaction details. |
|
Click the More Details button to view an additional page with more detailed information. |
|
Click the Download button to load the data that appears on the page to a Microsoft Excel spreadsheet. |
FERC Code |
Federal Energy Regulatory Commission identification codes. This field appears only if you select FERC reporting on the PeopleSoft Inventory Options page. |
ChartFields |
Chart of accounts that are used to record accounting entries and journal entries in PeopleSoft. |
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. |
Transaction Group / Group |
Predefined codes that are attached to different types of transactions, such as stocking, issues, adjustments, and so on. |
Distribution Type |
User-defined codes that are a subset of transaction groups. This enables you to break down a transaction group into customized categories. |
Item Group |
A grouping of items that enable you to design an accounting structure for a group of similar items, such as sporting equipment or dress shoes. The item group is attached to an item by using the Item Definition - General page. |
Journal |
The general ledger journal ID number. This is assigned when the journal entry is created. |
Date |
The journal date. |
CM Unit |
PeopleSoft Cost Management business unit, which is the same unit as the Inventory and Manufacturing business units. |
Book Name |
The cost book that is used to record the accounting entry. |
Acctg Date (accounting date) |
Date that the accounting line is created. |
Base Amount |
Transaction amount that is expressed in the base currency of the unit. |
Base Quantity |
The item's quantity in the standard unit of measure for the item. |
Container ID |
The identification number of the storage container that is used to stock this inventory. |
Conversion Type |
The type of conversion costs that are incurred in the manufacturing process. Conversion types include labor setup, machine setup, labor fixed run, machine fixed run, labor run, machine run, labor post production, machine post production, and manufacturing overhead. |
OH Rate Type |
Overhead rate type. |
OH Lab/Mac |
Overhead labor and machine. |
Variance Type |
Identifies the type of variance. The variances are: 01 configuration, 02 usage, 03 component yield, 04 labor lot size, 05 rtg var (process routing variance), 06 efficiency variance, 07 rate variance, 08 material lot size, 09 rework expense, 10 rework labor expense, 11 outside processing PPV, 12 mix variance, 13 teardown material expense, and 14 teardown conversion expense. |
Variance Source |
Indicates when the variance is recorded. A variance source of C (close) indicates that the variances are calculated when the production ID or schedule is closed for accounting by using Production Control, Close and Analyze Production, Close Production. A variance source of O (open) indicates that production is reopened and all previously recorded variances are reversed by using Production Control, Close and Analyze Production, Reopen Production. |
Production Type |
The type of production. The options are: PR (production), RW (rework), and TD (teardown). |
TL Scrap |
This-level scrap cost that is associated with the scrap cost transaction. |
LL Scrap |
Lower-level scrap cost that is associated with the scrap cost transaction. |
Revalue Type |
The types of revaluation include: 01 inv (inventory), 02 inspection, 03 WIP- component costs, 04 WIP - assembly costs, and 05 WIP - waste costs. |
Shipping Charge Type |
Shipping charge types include freight charges, miscellaneous charges, and non-stockable items. |
CC Status |
Options include: A (all), E (error), N (not budget checked), and V (valid). |
