REFERENCE MANUAL

INCORPORATING BUSINESS SYSTEM TEST SCRIPT AND HIGH LEVEL USER MANUAL

Oracle Cost Management

Prepared by DATAMAT DBA Company Ltd

Author: Nick Taylor

Creation Date: 24th January, 2003
Last Updated: 27th February, 2003
Document Ref: COST Reference-TH
VSS Version: 3

Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved.

 Cost Management

Contents

Introduction............................................................................................................................. 4
Document Purpose .......................................................................................................... 4
Future Business Process Model ..................................................................................... 4
Business System Test Script ........................................................................................... 4
High Level User Manual ................................................................................................ 4
Key Stroke Notation ............................................................................................................... 5

Oracle Toolbars and Keyboard Shortcuts............................................................................ 6

Toolbar .............................................................................................................................. 6
Toolbar Icons .................................................................................................................... 6
Keyboard Shortcuts ......................................................................................................... 7
Cost Management Processes Summary Diagram .............................................................. 8

Cost Management: Structure of Item Costs ....................................................................... 9

Cost Management: Work In Process Transaction Cost Flow.......................................... 10

Cost Management: Standard Cost Update........................................................................ 11

Cost Management Processes ............................................................................................... 12

CM S.0 Setting Up.......................................................................................................... 12
CM S.1 Select Standard, Average, FIFO, or LIFO costing method................................. 12
CM S.2 Use rule-based accounting for revenue and cost of goods sold........................ 13
CM S.3 Set up material sub-elements and assign to items ............................................. 14
CM S.4 Set up material overhead sub-elements and assign to item types................... 15
CM S.5 Set up resource sub-elements ............................................................................... 15
CM S.6 Set up Outside Processing sub-elements ............................................................ 15
CM S.7 Set up overhead sub-elements and applications................................................. 16
CM S.8 Apply overheads using different drivers............................................................. 17
CM M.0 Maintenance Tasks......................................................................................... 18
CM M.1 Create resources to be charged at standard cost ............................................... 18
CM M.2 Setup a “Person” type resource that charges at actual cost ............................. 19
CM M.3 Setup an employee and charge rate .................................................................... 20
CM M.4 Setup a “Machine” type resource that charges at actual cost .......................... 21
CM 1.0 Manufacturing Costing ................................................................................... 22
CM 1.1 Automatically create all inventory accounting entries....................................... 22
CM 1.2 Analyze accounting transactions on-line ............................................................. 22
CM 1.3 Charge resources automatically based on operation completion ..................... 23
CM 1.4 Charge resources manually ................................................................................... 24
CM 1.5 Automatically create all Work In Process accounting transactions. View Work
in Process account balances by transaction, job, or schedule ......................................... 25
CM 1.6 Use WIP accounting classes concept to manage, project, repair, R&D, and
construction costs. ................................................................................................................ 26
CM 1.7 Track variances........................................................................................................ 27
CM 2.0 Product Costing................................................................................................ 28
CM 2.1 Assign costs to items............................................................................................... 28
CM 2.2 Roll up costs for bills and routings based on standard costs ............................ 29
COST Reference-TH.doc
Page 2 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management
CM 2.3 Use mass edits to easily maintain costs and accounts........................................ 30
CM 2.4 Copy costs across cost types or organizations..................................................... 31
CM 2.5 Create alternate bill/routing snapshot for rollup ............................................... 32
CM 3.0 Standard Cost Updates.................................................................................... 33
CM 3.1 Update Standard Costs........................................................................................... 33
CM 4.0 Cost Simulations .............................................................................................. 34
CM 4.1 Create unlimited sets of item cost types............................................................... 34
CM 4.2 Compare costs between cost types ....................................................................... 35
CM 4.3 Run inventory valuation reports........................................................................... 35
CM 4.4 Run margin analysis reports.................................................................................. 36
CM 5.0 Financial Integration........................................................................................ 37
CM 5.1 Open/Close accounting period............................................................................. 37
CM 5.2 Transfer transactions to GL (Daily, weekly)........................................................ 38
CM 5.3 Print month end reports for reconciliation .......................................................... 38
CM 5.4 Transfer to general ledger in summary or detail ................................................ 39

Appendix A – Input Source Documents............................................................................ 40

Appendix B - Key Output Reports ..................................................................................... 41

COST Reference-TH.doc
Page 3 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Introduction

Document Purpose
This RapidSTART document provides a detailed description of the generic, core business processes supported by
the Oracle Applications Cost Management module.

The ‘Process Summary’ diagram details the high level tasks that can be performed within this module. Where
necessary, the frequently used tasks are diagrammed in more detail in the ‘Process Flow’ diagrams.
Finally, the textual ‘Process Steps’ section details how to perform the business process using Oracle Applications.
Reference numbers used in both the summary and detailed diagrams and in the process steps are common
throughout the document and provide a link between the 3 levels of detail.

This document is generic and represents ‘Core’ Oracle business processes. This document serves three purposes:-

Future Business Process Model

This document details the RapidSTART ‘Core’ business processes. These provide the foundations for a company’s
implementation of this Oracle Applications module.

Business System Test Script

When RapidSTART has been implemented and set up completed by the Customer, it will need to be tested to
ensure it will satisfy their business processes. Business System Testing (BST) should be based around ‘live’
sample documents collected by the implementing company (see Appendix A).

For each business process, this document details how to verify the results of the process (either by a screen
inquiry or via a report) and also provides a link to a ‘Core’ functionality Acceptance Certificate that can be signed
when the process is tested successfully. When all appropriate Acceptance Certificates have been signed and no
major issues documented, the module’s implementation is deemed complete.

This document is intended that it satisfy 80% of the Customer’s testing requirements (excluding supporting
manual processes, destructive testing and security requirements).

High Level User Manual

Subsequent to implementation and setup this document can be used as a high level User Manual.

The Summary and Process diagrams provide a numbered reference to the text that describes how to perform a
business process. In some cases (for more infrequently used processes), the text detail simply provides the
navigation path to the required form and a reference to the Oracle User Manual (if required). For ‘Core’ processes
the text describes the navigation path plus details on how to perform the task once the user enters the form.

Although, this document does not intend to replace Oracle User Guides, it can provide the experienced user with
a quick reference manual that can assist them in their day-to-day tasks.

COST Reference-TH.doc
Page 4 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Key Stroke Notation

Within this document, specific keystroke notations have been used in order to simplify the text. These keystrokes
are very specific to actions within Oracle and will become clear after Oracle training. If you have any questions
regarding these notations, please feel free to contact a DBA Consultant.

Navigation, Input and Output

(N) Inventory > Setup > Templates To Navigate to the ‘CMentory’ Main menu, ‘Setup’ sub-menu,
‘Templates’ form.
(Input) Item Master file Listing Input source document used in the process.
(R) Receiving Transaction Register Output report name
**Refer To: Reference to Oracle manuals

Conventions:
a) > for navigator menu levels
b) [ ] for form actions
c) { } for form icons
d) “ ” for selections
e) <> for user entered information
f) ( ) for comments
g) Field names are written with no modification

Examples:
a) [ ] for form actions
[Button] Open represents a button option
[Tab] Lines represents a tab (alternate region)
[Menu] Tools \Cycle Count Scheduler represents a menu\submenu selection
[Row Select] <any order> would be used to select a row of data
[Select] Conversions: Both would select a radio button choice in a window
labeled “Conversions”
[Click] Item would activate a selection menu from the field “Item”
Stockable [Check] means the Stockable check box has been marked

b) { } for Oracle form icons

{Save}, {Find}, {New}

c) <> for user entered information

Name <Organization name>
Item <Master item number>

d) “ ” for selections
[Select] “Min-Max” would select the “Min- Max” option from several available options

e) ( ) for comments
[Unit of Measure] Primary [Click] (to generate a list of UOMs) are used to further
explain the step to the user

f) Field names are written with no modification

Item
Unit of Measure: Primary represents the Primary field in the Unit of Measure box

Unit of Measure: Primary represents the Primary field in the Unit of Measure box

COST Reference-TH.doc
Page 5 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Oracle Toolbars and Keyboard Shortcuts

Oracle Applications can be driven by a combination of Menu selections, Toolbar Icon selections and Keyboard
shortcuts. This section describes the Toolbar icons and keyboard shortcuts you will need to use the Application.
For further information please refer to the ‘Oracle Applications User’s Guide’.

Toolbar
The Oracle Applications toolbar is shown below
Note: Icon’s may change and become enabled/disabled depending on the context.

Toolbar Icons

New – opens a new record in the active form.

Find – Displays the find window to retrieve records
Show Navigator – Displays the Navigator Window
Save – Saves any pending changes in the active form.

Next Step – Updates the process workflow in the navigator by advancing to the next step in the process.
Print – Prints the current screen that the cursor is in. In some cases it may print a report associated with
the current data.
Close Form – Closes all windows of the current form.
Cut – cuts the current selection to the clipboard.

Copy – copies the current selection to the clipboard.

Paste – pastes from the clipboard to the current field.

Clear record – erases the current record from the window.

Delete – deletes the current record from the database.

Edit – Displays the editor window for the current field.

Zoom – CMokes customer defined zoom (drill down behaviour).

Translation – CMokes the Translation window.
Attach - CMokes the Attachment window. If one or more attachments already exists, the icon changes to
a paper clip on a piece of paper.
Help – Displays help for the current window.

Export – CMokes the Export window.

COST Reference-TH.doc
Page 6 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Keyboard Shortcuts

Function Keyboard Shortcut

Block Menu Ctrl+B
Clear Block F7
Clear Field F5
Clear Form F8
Clear Record F6
Commit Ctrl+S
Count Query F12
Display Error Shift+Ctrl+E
Down Down
Duplicate Field Shift+F5
Duplicate Record Shift+F6
Edit Ctrl+E
Enter Query F11
Execute Query Ctril+F11
Exit F4
Help Ctrl+H
Insert record Ctrl+Down
List of Values Ctrl+L
List Tab Pages F2
Next Block Shift+PageDown
Next Field Tab
Next Primary Key Shift+F7
Next Record Down
Next Set of records Shift+F8
Previous Block Shift+PageUp
Previous Field Shift+Tab
Previous Record Up
Print Ctrl+P
Return Return
Scroll Down PageDown
Scroll Up PageUp
Show Keys Ctrl+K
Up Up
Update Record Ctrl+U

COST Reference-TH.doc
Page 7 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
Cost Management Processes Summary Diagram
 Cost Management

Cost Management: Structure of Item Costs

COST Reference-TH.doc
Page 9 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Cost Management: Work In Process Transaction Cost Flow

COST Reference-TH.doc
Page 10 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Cost Management: Standard Cost Update

COST Reference-TH.doc
Page 11 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Cost Management Processes

CM S.0 Setting Up
Process and Steps Verify Results Acceptance
Certificate
Name

CM S.1 Select Standard, Average, FIFO, or LIFO costing method

Set up the costing method to be used by the organization.
The costing method used by the system is determined at the time of system setup COST_INV_C00
and depends on the requirements of the organization. Each organization may have 1.doc
a different costing method. COST_INV_C00
4.doc
Important: Once costing or inventory transactions are generated the Costing
Method cannot be changed!

To view the Costing Method used by an organization:

1) (N) Inventory > Setup > Organizations > Parameters {Tab] Costing, [Field]
Costing Method

COST Reference-TH.doc
Page 12 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM S.2 Use rule-based accounting for revenue and cost of goods sold
Rules defined in Oracle Order Management manage COGS and revenue COST_INV_C00
transactions at the time of shipping. This is covered in more detail in the Order 5.doc
Management User’s Guide.

Note: Determining accounts and rules is done at setup and any changes should not
be attempted without proper authorization.

To view the Invoicing and Accounting rules, and COGS account:

1) (N) Order Management > Setup > Transaction Types > Define
2) Transaction Type: <Select a desired transaction type such as an order line type>
3) [Tab] Finance
4) View the accounts and rules

To view the Receivable and Revenue accounts:

1) (N) Order Management > Setup > Financials > Transaction Type
2) Name: <Invoice>
3) View the accounts and rules

COST Reference-TH.doc
Page 13 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM S.3 Set up material sub-elements and assign to items

Material sub-elements are used to define the company specific material types that COST_PROD_C
the company wishes to track. Examples could be packaging, plastic parts, cloth, etc. 002.doc

The material sub-element “MATERIAL” is predefined by the system. All items

should be assigned to this sub-element at the time of item creation.

To define material sub-elements:

1) (N) Cost > Setup > Sub-elements > Material
2) Material: <Enter the material type to be tracked, e.g. “Packaging”>
3) Description: <Description>
4) Default Basis: <Item or Lot>

To assign an item to one or more material sub-elements:

1) (N) Cost > Item Costs > Item Costs
2) Item: <Enter the item >, [Button] Costs (The Item Cost Details Window appears)
3) Cost Type: <Click select a Cost Type from the list>
4) [Button] Costs (The Item Cost Window appears)
5) Cost Element: <Click select the Material cost element>
6) Sub-element: <Click select the desired sub-element (default is Material)
7) Basis: <Click select Item or Lot>
8) Rate or Amount <Enter the cost to be used>
9) Repeat as necessary, since an item may be assigned to more than one sub-element.
10) {Save}

Note: It is recommended that the assignment of sub-elements to items and

assigning standard costs be done at the time the item is created at: (N) Inventory >
Items > Master Items, [Menu] Tools \ Item Costs

COST Reference-TH.doc
Page 14 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM S.4 Set up material overhead sub-elements and assign to item types

COST_PROD_C
Material Overhead sub-elements are created the same way as Overheads. The sub- 004.doc
elements are the resources that are assigned to the Overhead. See Task CM S.7. COST_PROD_C
002.doc
You can use material overhead and overhead cost subelements to add indirect costs
to item costs on either a percentage basis or as a fixed amount in both standard and
average costing organizations. Material Overhead sub-elements are created the
same way as Overheads. See Task CM S.7.

You can define and update default material overhead subelements and rates. These defaults
speed data entry when defining items. When you define items, these material overheads are
defaulted into the
Frozen cost type under standard costing, and into the cost type you defined to hold average
rates under average costing. For buy items, enter material costs. For make items, roll up
costs.

Material Overhead sub-elements are assigned to Item Types (ATO Item, Finished
Goods Item, Purchased Item) or Categories.

To assign Material Over head rates to items:

1) (N) Cost > Setup > Sub-elements > Defaults
2) Material Overhead: <Select from the list of previously defined Material Overheads>
3) Item Type: <Select from the list>
4) Basis: <Select the basis on which the rate or amount is to be applied>
5) Rate or Amount: <The rate or amount to be assigned>

CM S.5 Set up resource sub-elements

Resources defined in BOM or Cost Management act as resource sub-elements to the COST_PROD_C
resource element. See Tasks CM M.1, CM M2 for more details on setting up costed 002.doc
resources.

(N) Cost > Setup > Sub-elements > Resources

CM S.6 Set up Outside Processing sub-elements

COST Reference-TH.doc
Page 15 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

Outside Processing sub-elements are Resources defined in BOM or Cost COST_PROD_C

Management that are checked as Outside Processing Resources. See Tasks CM M.1, 002.doc
CM M2 for more details on setting up costed resources.

(N) Cost > Setup > Sub-elements > Resources

CM S.7 Set up overhead sub-elements and applications

Overhead sub-elements must be set up before they can be applied to resources. COST_PROD_C
002.doc
To define overhead sub-elements:
1) (N) Cost > Setup > Sub-elements > Overheads
2) Overhead: <Enter the overhead name, e.g. “Facility”>
3) Cost Element: <”Overhead” or “Material Overhead”>
4) Absorption Account < Use the pre-defined Overhead Absorption account>
5) Default Basis <Resource Unit is a common choice (See next task, below for useful
combinations)>
6) [Button] Rates
a) Cost Type <Pending, etc> Note that “Frozen” cannot be used
b) Department <enter the appropriate department>
c) Rate <enter as appropriate> See next task for more detail
d) {Close}
7) {Button] Resources – Recommend not to use this button and to associate resources to
overheads when the resource is defined. These are the resources in the department that
have overhead applied at the defined rate.

COST Reference-TH.doc
Page 16 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM S.8 Apply overheads using different drivers

COST_MANUF
In the previous task various combinations of Cost Element and Default Basis can be _C004.doc
used to determine how overheads are applied to items and lots: COST_PROD_C
006.doc
• Fixed amount per item:
Default Basis <Item>, enter amount per item in [Button] Rates, Rate or
Amount <Amount to use>
• Fixed amount per lot :
Default Basis <Lot>, enter amount per item in [Button] Rates, Rate or
Amount <Amount to use>
• Percent of item value :
Cost Element <Material Overhead>, Default Basis <Total Value>, enter
amount per item in [Button] Rates, Rate or Amount <Amount to use>
• Percent of resource value (Resources must have already been associated
with the overhead) :
Cost Element <Overhead>, Default Basis <Resource value>, enter amount
per item in [Button] Rates, Rate or Amount <Amount to use>
• Fixed amount per resource unit (Resources must have already been
associated with the overhead) :
Cost Element <Overhead>, Default Basis <Resource unit>, enter amount
per item in [Button] Rates, Rate or Amount <Amount to use>

COST Reference-TH.doc
Page 17 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

CM M.0 Maintenance Tasks

Process and Steps Verify Results Acceptance
Certificate
Name

CM M.1 Create resources to be charged at standard cost

Standard resource costs are defined in the BOM module at the time the resource is defined. The costing of Report: COST_MANUF
resources must be defined at the time of resource creation.
(R) Resource Report _C002.doc
Important! Resource costing needs to be set up at the time the resource is created. If transactions are COST_MANUF
made against the resource, it cannot be changed. Because of this the costing should be set up at the time _C003.doc
the resource is created.

Note: This task only defines the costing aspects of defining a resource. Other aspects of resource
definition are defined in the BOM documentation concerning creating resources

To define a resource cost for a resource (See Note):

1) (N) Bills of Material > Routings > Resources
2) {Find} Find the resource or create a new one
3) Charge Type: (This determines how the resource is charged to the job)
a) WIP Move – Charged when the item is moved between operations.
b) Manual – Charged manually at the operation (Not used here if charging at Standard Cost)
c) PO Receipt – Charged when purchased material is received
d) PO Move - Used with outside processing
4) If Outside processing is used
a) Enabled [Check], the Outside Processing accounts will appear
5) Costed [Check]
6) Absorption Account: <Enter the absorption account code>
7) If using standard rates (used when not manually charging the resource):
a) Standard Rate [Check]
b) Variance Account: <Enter the resource variance account or resource rate variance account as
appropriate>
8) [Button] Rates
a) Cost Type < New Resources should have a Frozen rate entered at the time it is created >,
Resource Unit Cost <Enter the rate>
9) {Close}{Save}
10) If using overheads: [Button] Overheads
a) Cost Type: Select the Cost Types to be used . Recommend at least Frozen and Pending be used
at a minimum.
b) Resource Overhead Associations: Overhead: <Select the appropriate overhead to associate with
the resource> (Overheads and their application rates must have previously been defined)
c) {Close}, {Save}

Note: Overheads and their application rates are defined in:

(N) Costs > Setup > Subelements > Overheads

COST Reference-TH.doc
Page 18 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM M.2 Setup a “Person” type resource that charges at actual cost

To create resources that are charged at actual cost, the Charge Type (see previous Report: COST_MANUF
task) must be set to “Manual”: (R) Resource Report _C002.doc
(R) Resource Transaction Report COST_MANUF
To define a resource to charge a “Person” Type resource at actual cost: (R) Employee Rates Listing _C003.doc
1) (N) Bills of Material > Routings > Resources
2) {Find} Find the resource or create a new one
3) Charge Type: (This determines how the resource is charged to the job)
a) Manual – Charged manually at the operation
4) If Outside processing is used
a) Enabled [Check], the Outside Processing accounts will appear
5) Costed [Check]
a) Absorption Account: <Enter the absorption account code>
b) Standard Rate: [Do not check]
c) Variance Account: <Enter the resource variance account or resource rate
variance account as appropriate, optional, but recommended>
6) [Button] Rates
a) Cost Type <New Resources should have a Frozen rate entered at the time it
is created>, Resource Unit Cost <Enter the rate>
7) {Close}{Save}
8) [Button] Employees (The Employees window will appear)
a) Employee: Select the employees associated with this resource. They must
have been previously entered (see next task).
b) {Close}, {Save}
9) If using overheads see the Task CM.M1

COST Reference-TH.doc
Page 19 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM M.3 Setup an employee and charge rate

These can be used with The “Person” type resource defined in the previous task. Report:
(R) Employee Rates Listing
To create an employee and charge rate::
1) (N) Cost > Setup > Employees > Persons
2) Last Name, First Name, Title, Employment Dates must be entered
3) [Button] More
4) Style: <Select the home address style to be used> {Save}, {Close}
5) (N) Cost > Setup > Employees > Labor Rates
6) Name or Number <Enter Name or employee Number in order to find the
employee>, [Button] Find
7) Effective Date <Effective date of the labor rate>
8) Hourly Labor Rate: <Hourly labor rate>
9) {Save}

COST Reference-TH.doc
Page 20 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM M.4 Setup a “Machine” type resource that charges at actual cost

To create resources that are charged at actual cost, the Charge Type (see previous Report: COST_MANUF
task) must be set to “Manual”: (R) Resource Report _C002.doc
COST_MANUF
To define a resource to charge a “Machine” Type resource at actual cost: _C003.doc
1) (N) Bills of Material > Routings > Resources
2) {Find} Find the resource or create a new one
3) Charge Type: (This determines how the resource is charged to the job)
a) Manual – Charged manually at the operation
4) If Outside processing is used
a) Enabled [Check], the Outside Processing accounts will appear
5) Costed [Check]
a) Absorption Account: <Enter the absorption account code>
b) Standard Rate: [Do not check]
c) Variance Account: <Enter the resource variance account or resource rate
variance account as appropriate, optional, but recommended>
6) [Button] Rates
a) Cost Type < New Resources should have a Frozen rate entered at the time it
is created >, Resource Unit Cost <Enter the rate>
7) {Close}{Save}
8) [Button] Equipment (The equipment window will appear)
a) Equipment: <Select the equipment from the drop down list> Note: The
equipment type should have been previously created in inventory (as an
item with each piece of equipment having its own serial number - use the
Equipment item template) This field is for informational purposes only.
b) {Close}, {Save}
9) If using overheads see the Task CM.1

COST Reference-TH.doc
Page 21 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

CM 1.0 Manufacturing Costing

Process and Steps Verify Results Acceptance
Certificate
Name

CM 1.1 Automatically create all inventory accounting entries

The accounting information associated with COST_INV_C00

The system is designed so that all accounting requirements of inventory inventory transactions can be found in the following 2.doc
transactions are automatically recorded. This means the user does not need to know reports:
the accounts or make accounting transactions.
(R) Transaction Register
The (R) Transaction Register at (N) Cost > Report > Transactions serves as a (R) All Inventories Value Report
repository of transactions. The parameter screen provides may ways to sort and (R) Receiving Value Report
filter transactions. (R) WIP Value Report
(R) Transaction register
CM 1.2 Analyze accounting transactions on-line
All manufacturing accounting transactions can be viewed on-line.
The various screens for viewing accounting transactions on-line are shown below. Report: COST_INV_C00
All have very useful Find windows that enable the user to select the transactions to (R) Receiving Account Distribution Report 3.doc
be viewed in many different ways. (R) Receiving Transactions Register
(R) Material Account Distribution Summary Report
Inventory : (R) Material Account Distribution Detail Report
• (N) Cost > View Transactions > View Receiving Transactions (R) WIP Value Report
• (N) Cost > View Transactions > Material Transactions (R) Transaction register
• (N) Cost > View Transactions > Material Distributions (R) Resource Transaction Report
• (N) Cost > View Transactions > Material Transaction Layer Cost (LIFO/FIFO, (R) Move Transaction Report
Average Costing organizations only) (R) WIP Account Distribution Report
• (N) Cost > View Transactions > Transaction Summaries (R) Receiving Account Distribution Report

WIP:
• (N) Cost > View Transactions > WIP Value Summary
• (N) Cost > View Transactions > WIP Distributions
• (N) Cost > View Transactions > Move Transactions
• (N) Cost > View Transactions > Resource Transactions

COST Reference-TH.doc
Page 22 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 1.3 Charge resources automatically based on operation completion

This occurs when the charge type set up in the resource is set to “WIP Move”, “PO COST_MANUF
Receipt”, or “PO Move”. This is set at: _C003doc

1) (N) Bills of Material > Routings > Resources

2) {Find} Find the resource or create a new one
3) Charge Type: (This determines how the resource is charged to the job)
a) Select “WIP Move”, “PO Receipt”, or “PO Move” – The accounting charges
will be automatically generated when the item is moved between
operations, or received.

COST Reference-TH.doc
Page 23 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 1.4 Charge resources manually

Resources are that are created with a Charge Type of “Manual” allow resource Report:
charges to be added manually. The form can be accessed in three ways as shown (R) Resource Transaction Report
below: (R) WIP Value Report

To charge resources using the Discrete Workstation Time Charges form:

1) (N) WIP > Discrete > Discrete Workstation
2) Department:< Click select the department>
3) [Button] [Find]
4) Click on the job to which charges are to be applied
5) [Tab] Time Charges
a) Resource: Select the resource to be manually charged
b) Start Date: <Enter the operation start time for the resource>
c) End Date < Enter the operation end time for the resource>, The total hours
will be automatically calculated.
d) [Button] Save to save the inputs
e) If the resource is a “Person” type and an employee name and rate has been
assigned then select the name of the employee.
f) [Button] Save

To charge resources using the Discrete Workstation Resource Transactions form:

1) (N) WIP > Discrete > Discrete Workstation
2) Department:< Click select the department>, [Button] [Find]
3) Select the job/operation to be viewed
4) [Button] Charge Resources, The Resource Transactions window opens, [Button]
Continue
5) Enter the Quantity of resource to be charged against the operation

Continued …

COST Reference-TH.doc
Page 24 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

To charge resources using the Resource Transactions form:

1) (N) WIP > Resource Transactions > Resource Transactions
2) Job: <Enter the job number to apply the charges>, [Button] Continue
3) Operation Sequence <Select the Routing operation sequence>
4) Resource Sequence <Select the Resource sequence within the routing step>
5) Resource <Select the Resource to be charged>
6) Employee <If an employee Resource, optionally select the employee name>
7) Quantity <Enter the quantity (usually hours> of the resource used>
8) {Save}

Note: Resource charges can also be imported through an open interface.

CM 1.5 Automatically create all Work In Process accounting transactions. View Work
in Process account balances by transaction, job, or schedule
Work in Process accounting entries are automatically generated with the job Report: COST_MANUF
creation, movement and completion. They can be viewed online as follows: (R) WIP Value Report _C005doc
(R) Resource Transaction Report COST_MANUF
To view all WIP transactions to a job or schedule: _C006doc
9) (N) Costs > View Transactions > WIP Value Summary
10) Enter the job to be viewed in the Find screen.
11) [Button] [Find]
12) [Button] Distributions to see all transactions

To view all WIP transactions

13) (N) Costs > View Transactions > WIP Distributions
14) Enter the jobs or transaction dates, etc. to be viewed in the Find screen.
15) [Button] [Find]

COST Reference-TH.doc
Page 25 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 1.6 Use WIP accounting classes concept to manage, project, repair, R&D, and
construction costs.
The WIP accounting class concept can be used to draw costs to large jobs/projects. Report: COST_MANUF
Simply create a new WIP accounting class (non-standard) with appropriate (R) WIP Value Report _C011doc
accounts uniquely identified to the project. After creating the new WIP accounting (R) WIP Accounting Classes Report
class material (through BOM’s), resources, and overheads (through routings) can be
assigned to the job using discrete non-standard jobs, and subinventory transfers.

Note: This process is a really great way to record maintenance jobs.

To create the new WIP accounting class for a project:

1) (N) Cost > Setup > Account Assignments > WIP Accounting Classes
2) Class < Enter the name of the project>, Description: <Description>
3) Type: <Usually “Expense Non-standard”, “Asset Non-standard”, or
“Maintenance”>
4) Accounts, Valuation: Fill in the accounts required with the appropriate accounts
to be charged for the project. For example, a repair project may use the “Spare
Parts Used” account for repair parts, and the “Maintenance Labor” account for
the resource account.
5) Accounts, Variance: If there are no standards for the job, then use the same
account as the valuation account. If there are standard costs for the project then
create and use the appropriate variance accounts.
3) {Save}

COST Reference-TH.doc
Page 26 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 1.7 Track variances

Variances are recorded throughout the system and can be viewed on the same Reports: COST_MANUF
forms as transactions. See Task CM 1.2, Analyze Transactions Online, for the list of (R) Receiving Account Distribution Report _C007.doc
forms. Keep in mind the following: (R) Receiving Transactions Register COST_MANUF
(R) Material Account Distribution Summary Report _C008.doc
• Job variances are not recorded until job close. (R) Material Account Distribution Detail Report COST_MANUF
(R) WIP Value Report _C009.doc
• The WIP Value Summary Find form, (N) Cost > View Transactions > WIP (R) Transaction register COST_MANUF
Value Summary, has filters for reported and potential variances. (R) Resource Transaction Report _C010.doc
(R) Move Transaction Report
• Purchase variances are found in the Oracle Purchasing reports listed to the (R) WIP Account Distribution Report
right. (R) Receiving Account Distribution Report

Variance reports in Oracle Purchasing:

(R) Invoice Price Variance Report
(R) Invoice Price Variance by Vendor Report
(R) Purchase Price Variance Report

COST Reference-TH.doc
Page 27 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

CM 2.0 Product Costing

Process and Steps Verify Results Acceptance
Certificate
Name

CM 2.1 Assign costs to items

Costs can be assigned to items directly or based on rollups. Make item costs are Reports:
normally automatically defined as rollup at creation time based on the setting in the (R) Detailed Item Cost Report
item template. Buy items normally have their costs defined at item creation.
The Sub-elements for each Cost Element must have previously been set up in Tasks
CM S.3 – CM S.7.

Resource sub-elements are normally assigned to an item through rollup of the

routing. They are not normally directly assigned.
Note: The Find screen of (N) Cost > Item Cost > Item Costs is extremely useful for
filtering items with different aspects of costs. It can also be used to identify items to
which costs have not yet been assigned (Zero Cost Items Only).

To enter/change item costs:

1) (N) Cost > Item Cost > Item Costs
2) Enter The item or “%” for all [Button] Find
3) Select the row of the Cost Type to be modified (usually “Pending”), [Button]
Open, [Button] Costs
4) Cost Element: <Click select the desired cost element>
5) Sub-element: <Click select the desired sub-element>
6) Basis: <Click select Item or Lot>
7) Rate or Amount <Enter the cost to be used>
8) Repeat as necessary, since an item may be assigned to more than one element,
sub-element.
9) {Save}

To enter/change item costs at the time of item creation:

1) (N) Inventory > Items > Master Items
2) Create the item
3) [Menu] Tools \ Item Costs

COST Reference-TH.doc
Page 28 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 2.2 Roll up costs for bills and routings based on standard costs
Rollups can be performed at the time of BOM or Routing creation, or en masse by To view roll up results: COST_PROD_C
concurrent request. Recommend as good practice to roll up at time of (R) Cost Rollup – Print Report 001doc
BOM/Routing creation as well as have periodic mass rollups of all items. COST_PROD_C
014doc
See Task CM 2.5 for more information on saving BOM and Routing snapshots COST_PROD_C
during rollup. 008doc
COST_PROD_C
To do the cost rollup on an individual BOM/Routing at time of entry: 007doc
1) (N) Bill of Material > Bills > Bills or (N) Bill of Material > Routings > Routings COST_PROD_C
2) {Find}, Enter the item name of the Bill 010doc
3) [Menu] Tools\Rollup Costs (The Cost Rollup window will appear)
4) Cost Type <Usually pending or Frozen, but can be anything>
5) [Button] OK starts a concurrent request, [Button] Ok
6) Results are found at (N) Bill of Material > Bills > Indented Bills
7) Item: <Enter the item rolled up>
8) Display Costs [Check], Cost Type: <Cost Type (usually “Pending”>
9) [Button] Find, [Tab] Costing

To do mass cost rollups:

1) (R) Cost Rollup – No Report
2) Parameter: Cost Type <Usually Pending>

To do mass rollups automatically (daily):

1) Schedule the above report to run once daily by programming the Submit Report
screen used to run reports.
2) Follow the steps for doing the mass cost rollup, [Button] Schedule
3) Run the job: Periodically [Check], Fill in the other fields as appropriate
4) Save this schedule [Check]
5) [Button] OK, [Button] Submit

COST Reference-TH.doc
Page 29 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 2.3 Use mass edits to easily maintain costs and accounts

Mass edits is a powerful tool to make mass cost updates easy: COST_PROD_C
• Create new costs and change costs to a specified amount by a percentage or 012doc
an absolute amount COST_PROD_C
• Create new costs by averaging the purchase order price for open purchase 014doc
orders or historical purchase order receipts, or actual accounts payable
invoice prices for items
• Edit item shrinkage rates to a specified rate or a rate equal to your planning
shrinkage rates
• Apply new activity rates to item costs

To run a mass edit of item costs:

1) (N) Cost> Cost Mass Edits> Mass Edit Cost Information, [Button] OK
2) Name <%> [Tab], The list of report options will appear. Select the one desired.
3) Parameters:
a) Cost Type <Select appropriate from list>
b) Enter the high and low item numbers to be edited
c) Other parameters are optional
4) [Button] Submit, the report will run

To do mass copy of item costs automatically (daily, monthly):

1) Schedule the above report to run once daily by programming the Submit Report
screen used to run reports.
2) Follow the steps for doing the mass edits, [Button] Schedule
3) Run the job: Periodically [Check], Fill in the other fields as appropriate
4) Save this schedule [Check]
5) [Button] OK, [Button] Submit

COST Reference-TH.doc
Page 30 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 2.4 Copy costs across cost types or organizations

Mass edits can be used to copy/update costs across cost types (except for frozen COST_PROD_C
standard cost update). 013doc

To run a mass copy job:

1) (N) Cost> Cost Mass Edits> Copy Cost Information, [Button] OK
2) Name <%> [Tab], The list of report options will appear. Select the one desired
(usually “Copy Item Costs”).
3) Parameters:
a) Cost Type <Select appropriate from list>
b) Enter the high and low item numbers to be edited
c) Other parameters are optional
4) [Button] Submit, the report will run

To do mass edits automatically (daily, monthly)

1) Schedule the above report to run once daily by programming the Submit Report
screen used to run reports.
2) Follow the steps for doing the mass edits, [Button] Schedule
3) Run the job: Periodically [Check], Fill in the other fields as appropriate
4) Save this schedule [Check]
5) [Button] OK, [Button] Submit

COST Reference-TH.doc
Page 31 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 2.5 Create alternate bill/routing snapshot for rollup

COST_PROD_C
Since BOM and Routings often change, it is useful to have a copy of the BOM and 011.doc
Routings used at the time the rollup Frozen cost is created or at Standard Cost
update. The system allows the creation of a snapshot of a BOM and Routing at the
time of cost rollup.

Note: Alternate BOM and Routings must be created for rollup items
before copying rollups can take place.

To create a “SCSnapshot” BOM/Routing alternate type:

1) (N) Cost > Setup > Alternates
2) Alternate: <Alternate name, e.g. “SCSnapshot”>
3) Description: <e.g. “Standard Cost Snapshot”>

To save the BOM/Routing rollup to snapshots:

1) (N) Cost > Item Costs > Assembly Cost Rollup, “%” {Tab], Choose the
appropriate report
2) Parameter:
a) Cost Type <Usually “Pending”>
b) Alternate Bill: <Select the snapshot alternate, e.g. “SCSnapshot”>
c) Alternate Routing: <Select the snapshot alternate, e.g. “SCSnapshot”>

COST Reference-TH.doc
Page 32 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

CM 3.0 Standard Cost Updates

Process and Steps Verify Results Acceptance
Certificate
Name

CM 3.1 Update Standard Costs

The Standard Cost process updates the existing Frozen cost type values to the Pending Reports: COST_INV_C00
values. Inventory is automatically revalued after Standard Cost update. (R) Standard Cost Adjustment Report (Request Set) 6.doc
(R) Cost Type Comparison Report
It is a batch process that can be run anytime after period close, job close, or GL transfer
processes have been completed.
(R) Historical Inventory Standard Cost Adjustment
To do a Standard Cost update: Report
1) Run the (R) Cost Type Comparison Report to preview the changes to be made. R) Historical Intransit Standard Cost Adjustment
2) Make any necessary :corrections to the Pending costs Report
3) Run the Standard Cost Update job: (N) Cost > Item Costs > Standard Cost Update > Historical WIP Standard Cost Adjustment Report
Update Costs
4) Parameters:
a) Cost Type: <The Cost Type to be copied to the Frozen Cost Type, usually
“Pending”>
b) Adjustment Account: <Standard Cost Adjustment Account, RapidSTART:
10.000.670600.0000>.
c) Description <The name of the update>
d) Sort Option: <Select how the items will be sorted on the adjustment report>
e) Save Details <Recommend “Yes”> This saves a snapshot that be used to rerun the
adjustment reports in the future.

To view the results:

5) (N) Cost > Item Costs > Standard Cost Update > View Cost Update
a) Row Select the Update Date, [Button] History, all update details are available
6) Print the reports: Print the reports listed.

To view the cost history of an item:

(N) Cost > Item Costs > Standard Cost Update > View Cost History
(N) Cost > Report > Cost > Adjustment creates a report that shows the Standard Cost history
of items

To purge old history:

(N) Cost > Item Costs > Standard Cost Update > Purge Cost Update History

COST Reference-TH.doc
Page 33 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

CM 4.0 Cost Simulations

Process and Steps Verify Results Acceptance
Certificate
Name

CM 4.1 Create unlimited sets of item cost types

The user can create as many cost types as needed. Common additional cost types COST_SIMUL_
are: C001.doc

• What If: Used for simulation

• Prototype: Can be used for items in development
• Current: Can be used to store information on constantly changing
commodity process

To create additional cost types:

1) (N) Cost> Setup > Cost Types
2) Cost Type <The name of the new cost type>
3) Description <Description of the cost type>
4) Default Cost Type <Usually Frozen> (See note below)

Note:
For items where costs have not been defined for the cost type, the default cost type
is used as the next source of costs that the cost rollup and the inventory value
reports use for items not associated with the cost type being rolled up or reported
upon. You can have a cost type default to itself. The default reflects the current
organization’s costing method, Frozen for standard costing; Average for average
costing.

COST Reference-TH.doc
Page 34 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 4.2 Compare costs between cost types

The differences between two cost types can be viewed in the Cost Type Comparison COST_SIMUL_
Report. C004.doc

To run the Cost Type Comparison Report:

1) (N) Cost> Report>Item
2) Name <%> [Tab], The list of report options will appear. Select the “Cost Type
Comparison Report”.
3) Selected Parameters:
a) Cost Type 1<Select appropriate Cost Type from list>
b) Cost Type 2 <Select the other Cost Type from the list>
c) Group By <Select appropriate grouping>
4) [Button] Submit, the report will run

CM 4.3 Run inventory valuation reports

A wide variety of inventory valuation reports are available as follows: Report: COST_SIMUL_
(R) All Inventories Value Report C003.doc
To run the Cost Type Comparison Report: (R) Elemental Inventory Value Report
1) (N) Cost> Report>Value (R) Intransit Value Report
2) Name <%> [Tab], The list of report associated with inventory value will appear (R) Subinventory Account Value Report
(see next column). (R) ABC descending value report
3) Select the report and run (R) Period close value summary
(R) Receiving Value Report
(R) Receiving Value by Destination Account
(R) Discrete Job Value Report – Standard Costing
(R) Expense Job Value Report
(R) Repetitive Value Report
(R) WIP Value Report

COST Reference-TH.doc
Page 35 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 4.4 Run margin analysis reports

The (R) Margin Analysis Report With Order Management is extremely useful for COST_SIMUL_
analyzing the profitability of items, customers, or individual orders. The running of C003.doc
the report needs to be preceded by a run of the (R) Margin Analysis Load Run job.
Runs may be saved so that they can be compared with future runs. They can also be
built upon as more data is generated over time. This allows for a complete margin
analysis history to be built up over time.

To run the Margin Analysis Load job:

1) (N) Cost> Report>Operational Analysis, [Button] OK
2) (R) Margin Analysis Load Run [Tab], The list of report parameters will appear.
3) Parameters:
a) To Date: <Date of the latest data to include>
b) Overlap Days <The number of days this run should overlap the previous
run>
c) Load Option <”Increment”: to add to the last run, “Refresh” to completely
rebuild the run from the beginning of the overlap period>
4) [Button] OK, to run the job

To create and run the Margin Analysis Report With Order Management:
1) (N) Cost> Report>Operational Analysis, [Button] OK
2) (R) Margin Analysis Report With Order Management [Tab], The list of report
parameters will appear.
3) Selected Parameters:
a) Operating Unit: <Select appropriate(usually defaulted>
b) Exchange Rate <Usually “1”>
c) Additional parameters allow for a wide variety of filters.
4) [Button] OK, the report will run

To purge a Margin Analysis Load run:

1) (N) Cost> Report>Operational Analysis, [Button] OK
2) (R) Purge Margin Analysis Run [Tab], the list of report parameters will appear.
3) Parameters:
a) Build Name: <Select the Build Number to purge>
4) [Button] OK, to run the job

COST Reference-TH.doc
Page 36 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

CM 5.0 Financial Integration

Process and Steps Verify Results Acceptance
Certificate
Name

CM 5.1 Open/Close accounting period

The next period must be manually opened after completing month-end processing. COST_FINANC
E_C001.doc
Accounting period statuses
• open - Data can be input into the open period and can be posted also.
• closed - Data can not be input into closed period.
• future entry - Data can be input into future open period but can not be posted.

More than one period can be open at a time and reconciliation of the previous
period can continue while transactions are posted to the next period.

To open/close a period:
1) (N) Cost > Accounting Close Cycle > Inventory Accounting Periods
2) [Row Select]
3) [Button] Change Status

Closing Period Note: If there are no required pending transactions and there are no
previous open periods, then the period will close. If there transactions with pending
statuses that must be completed before period close then the period will not close
and a list of pending transactions pop up. See Task INV 4.6 from more details
concerning resolving Pending Transactions.

COST Reference-TH.doc
Page 37 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 5.2 Transfer transactions to GL (Daily, weekly)

Material transactions need to be transferred to GL on a regular basis, and COST_FINANC
immediately before closing the period. Recommend this be done on a daily or at E_C002.doc
most, weekly basis.

To transfer transactions to GL:

(N) Cost > Accounting Close Cycle > General Ledger Transfers

To view the transactions transferred to GL:

(N) Cost > Accounting Close Cycle > View General Ledger Transfers

CM 5.3 Print month end reports for reconciliation

Create and submit a request set to print all reports at the same time. The request can COST_FINANC
be setup by the system administrator. E_C005.doc

The following reports may of particular interest to the Controller at month end:
(R) Inventory Value Report
(R) Period close value summary
(R) Material Account Distribution Detail
(R) Material Account Distribution Summary

Reports required by the government should also be produced:

1) (N) Inventory > Reports > All
a) (R) Thai Goods and Raw Materials Report (Stock Card)
b) (R) Thai Goods and Raw Materials with Cost Report (Stock Card)

Other reports should be added as appropriate.

COST Reference-TH.doc
Page 38 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Process and Steps Verify Results Acceptance

Certificate
Name

CM 5.4 Transfer to general ledger in summary or detail

Transactions transferred to the general ledger can be transferred in Summary or COST_FINANC
Detail form. Recommend that Detail be used for the first few months until there is E_C003.doc
confidence that transactions are posting correctly. After several months transferring
in Summary should be sufficient. Transferring in Detail will require a large amount
of disk space.

To view/change the setting for transferring transactions to GL:

(N) Cost > Setup > Account Assignments > Organization Parameters [Tab] Costing
Information, Transfer to GL < “Summary”, “Detail” or “None”>

COST Reference-TH.doc
Page 39 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Appendix A – Input Source Documents

The following is a list of documents that are used by many organizations in managing their business processes. When a source document listed below is used as an input
to a process it is included in the process step for that task and is shown in green e.g.

(Input) Item Master file Listing

To support the Business System Test (BST) companies are advised to collect samples of documents listed below ready for controlled input into the Application.

Source Documents for this module are:-

1. New item master file information

2. Stock receiving document
3. Stock issue document (pick slip / stock movement request / stock transfer forms)
4. CMentory cycle count listing

COST Reference-TH.doc
Page 40 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Appendix B - Key Output Reports

Sorted by Oracle Report Name

Instructions on how to submit a report are detailed in the ‘Report Printing’ Process or in the specific ‘Verify Results’ section of the process step.
Oracle Report Name Primary User Frequency Comment

All Inventories Value Report Plant Monthly This report lists the quantity and value of items for all inventory for the specified cost type.
Controller If you run this report using either the Frozen or Average cost type, depending on the costing
method, the subinventories (stock) and intransit items are valued at current Frozen standard
or Average costs.
All Inventories Value Report – Plant Monthly Same as above, except used in average costing organizations.
Average Costing Controller
Consolidated Bills of Material Cost Plant As needed Use the Consolidated Bills of Material Cost Report to report assembly costs. This report
Report Controller consolidates usage quantities of components across all bill levels.
Cost Type Comparison Report Plant Before Standard Use the Cost Type Comparison Report to review the differences in your item costs by cost
Controller, Cost Update, as type.
Product needed
Manager
Detailed Item Cost Report Plant As needed Use the Detailed Item Cost Report to analyze item cost details for any cost type.
Controller,
Product
Manager
Discrete Job Value Report – Average Plant As needed The Discrete Job Value Report – Average Costing assists you in analyzing your standard
Costing Controller discrete jobs and non–standard asset jobs.
Elemental Cost Report Plant As needed Use the Elemental Cost Report to report and summarize item costs by cost element.
Controller
Elemental Inventory Value Report Plant As needed This report lists the subinventory quantity and value of items by cost element. Elemental
Controller values are the material, material overhead, resource, overhead, and outside processing cost
elements of inventory items.
Indented Bills of Material Cost Report Plant As needed This report lists item costs by level, detailiing assembly costs by subelement to the lowest
Controller level of your bill. Each item is detailed regardless of the number of levels it appears at on
the bill.
Intransit Standard Cost Adjustment Plant Before Standard (For items intransit) This report lists preliminary standard cost adjustments to inventory, or
Report Controller Cost Update final (historical) adjustments made to the standards by the cost update process.

Intransit Value Report Plant As needed Use the Intransit Value Report to report the value and quantity of items in intransit
Controller inventory.

COST Reference-TH.doc
Page 41 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Oracle Report Name Primary User Frequency Comment

Inventory Master Book Report Plant Monthly or for Use the Inventory Master Book Report if you are in a country with a fiscal
Controller audit inventory reporting requirement.
Inventory Standard Cost Adjustment Plant Before Standard Use the Inventory Standard Cost Adjustment Report to review either preliminary standard
Report Controller Cost Update cost adjustments to inventory, or to show the final adjustments made to the standards by the
cost update process.
Inventory Subledger Report Plant As needed Use the Inventory Subledger Report to show quantity, valuation, and detailed item
Controller information for the subinventories you specify.
Inventory Value Report Plant As needed Use the Inventory Value Report to show quantity, valuation, and detailed item
Controller information for the subinventories you specify.
Invoice Transfer to Inventory Report Plant As needed Use the Invoice Transfer to Inventory Report to provide detailed invoice information to
Controller support the cost update interface transactions created by the Invoice Transfer processor. The
report displays the invoice price variance amounts of all the invoice distribution lines for
each PO distribution.
Item Cost Reports Plant As needed Use the Item Cost Reports to analyze item costs for any cost type.
Controller
Layer Inventory Value Report – Plant As needed Use the Layer Inventory Value Report – FIFO/LIFO Costing to show the quantity, unit cost
FIFO/LIFO Costing Controller and value of your on– hand inventory. If you run this report using either the FIFO or LIFO
cost type, depending on the costing method, the subinventories (stock) and intransit items
are
valued at FIFO or LIFO costs.
Margin Analysis Report Plant As needed Use the Margin Analysis Reports to report sales revenue, cost of goods sold, and gross
Controller, margin information for each item shipped/invoiced within the specified date range. These
Product reports can print both summary and detail information. The detail report provides the
Management, information by customer, order, and line number. Results can be stored as “builds”.
Senior
Management
Margin Analysis Report – Order Plant As needed Same as above, but can work with sales orders.
Management Controller
Overhead Report Plant As needed Use the Overhead Report to report overhead information.
Controller
Receiving Value Report Plant As needed
Controller
Subinventory Account Value Report Plant As needed
Controller
Transaction Value Historical Plant As needed
Summary Report – Average Costing Controller
Transaction Value Historical Plant As needed

COST Reference-TH.doc
Page 42 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved
 Cost Management

Oracle Report Name Primary User Frequency Comment

Summary Report – Standard Controller

Costing
WIP Standard Cost Adjustment Plant As needed
Report Controller

*** END of DOCUMENT ***

COST Reference-TH.doc
Page 43 of 43
Copyright © 2002, DATAMAT DBA Company Ltd. All Rights reserved